contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA415856" and tax_phylum = "Mollusca"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | analysis_used | target | taxid | gene | allele | pident | sumperc_cov | alnlen | mismatch | qcov | gapopen | qstart | qend | tstart | tend | target_title | analysis | sumalnlen | maxbits | bits_percmax | tax_superkingdom | tax_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1694277 | 1694277 | PRJNA415856_P_NODE_50462_length_162_cov_0.902655_g50201_i0 | PRJNA415856 | 50462 | 162 | 0.902655 | 1.4623011 | Octopus bimaculoides | 37653 | Mollusca | Mollusca | 115 | 1.7e-21 | NTclustered | gi|2427275127|ref|XM_014914820.2| | 37653 | g50201 | i0 | 81.884 | 4.37037037037037 | 138 | 23 | 85 | 2 | 9 | 145 | 1224 | 1088 | PREDICTED: Octopus bimaculoides ubiquitin carboxyl-terminal hydrolase 15 (LOC106869189), transcript variant X1, mRNA | blastn | 708 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 5523076 | 5523076 | PRJNA415856_P_NODE_3425_length_537_cov_2.075820_g3177_i0 | PRJNA415856 | 3425 | 537 | 2.07582 | 11.1471534 | Patella vulgata | 6465 | Mollusca | Mollusca | 60.2 | 3.15e-4 | NTclustered | gi|2506333682|ref|XM_050552704.2| | 6465 | g3177 | i0 | 100 | 1.91620111731844 | 32 | 0 | 6 | 0 | 397 | 428 | 2796 | 2765 | PREDICTED: Patella vulgata importin-7 (LOC126823734), mRNA | blastn | 1029 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 6186621 | 6186621 | PRJNA415856_P_NODE_50905_length_161_cov_1.821429_g50644_i0 | PRJNA415856 | 50905 | 161 | 1.821429 | 2.93250069 | Cyclophorus | 75122 | Mollusca | Mollusca | 71.3 | 3.69e-8 | NTclustered | gi|2251842947|dbj|LC658828.1| | 494922 | g50644 | i0 | 85.333 | 46.0124223602485 | 75 | 4 | 44 | 7 | 82 | 152 | 506 | 435 | Cyclophorus formosaensis KC8691 mitochondrial gene for 16S rRNA, partial sequence | blastn | 7408 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Cyclophoridae | Cyclophorus | Cyclophorus formosaensis | |
| 9347262 | 9347262 | PRJNA415856_P_NODE_10588_length_272_cov_1.950673_g10327_i0 | PRJNA415856 | 10588 | 272 | 1.950673 | 5.30583056 | Haliotis asinina | 109174 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2793372023|ref|XM_067797346.1| | 109174 | g10327 | i0 | 96.97 | 0.121323529411765 | 33 | 1 | 12 | 0 | 74 | 106 | 917 | 949 | PREDICTED: Haliotis asinina mucin-22-like (LOC137259746), partial mRNA | blastn | 33 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 14448164 | 14448164 | PRJNA415856_P_NODE_27452_length_179_cov_1.030769_g27191_i0 | PRJNA415856 | 27452 | 179 | 1.030769 | 1.84507651 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.015 | NTclustered | gi|2913001038|dbj|AP039608.1| | 145626 | g27191 | i0 | 100 | 0.156424581005587 | 28 | 0 | 16 | 0 | 8 | 35 | 32885172 | 32885145 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 27, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 15721833 | 15721833 | PRJNA415856_P_NODE_13933_length_232_cov_2.131148_g13672_i0 | PRJNA415856 | 13933 | 232 | 2.131148 | 4.94426336 | Mytilus edulis | 6550 | Mollusca | Mollusca | 52.8 | 0.021 | NTclustered | gi|2912321271|ref|XM_071270946.1| | 6550 | g13672 | i0 | 100 | 0.241379310344828 | 28 | 0 | 12 | 0 | 13 | 40 | 8013 | 7986 | PREDICTED: Mytilus edulis potassium voltage-gated channel protein Shaw-like (LOC139486159), transcript variant X2, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;