contig_metadata
13 rows where bioproject = "PRJNA436017", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 430989 | 430989 | PRJNA436017_P_NODE_6681_length_345_cov_29.405844_g6384_i0 | PRJNA436017 | 6681 | 345 | 29.405844 | 101.4501618 | Physella acuta | 109671 | Mollusca | Mollusca | 632 | 9.17e-177 | NTclustered | gi|2572452079|ref|XR_009385380.1| | 109671 | g6384 | i0 | 99.71 | 4.27246376811594 | 345 | 1 | 100 | 0 | 1 | 345 | 3749 | 3405 | PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA | blastn | 1474 | 632 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 8083994 | 8083994 | PRJNA436017_P_NODE_18027_length_193_cov_1.480769_g17729_i0 | PRJNA436017 | 18027 | 193 | 1.480769 | 2.85788417 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.005 | NTclustered | gi|2912999747|dbj|AP039606.1| | 145626 | g17729 | i0 | 100 | 0.150259067357513 | 29 | 0 | 15 | 0 | 97 | 125 | 19922455 | 19922483 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 11292246 | 11292246 | PRJNA436017_P_NODE_25929_length_160_cov_1.268293_g25631_i0 | PRJNA436017 | 25929 | 160 | 1.268293 | 2.0292688 | Metazoa | 33208 | Mollusca | Mollusca | 296 | 5.55e-76 | NTclustered | gi|1928112764|gb|MT947788.1| | 6523 | g25631 | i0 | 100 | 99.975 | 160 | 0 | 100 | 0 | 1 | 160 | 618 | 777 | Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds | blastn | 15996 | 296 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 12567974 | 12567974 | PRJNA436017_P_NODE_9550_length_281_cov_1.356557_g9252_i0 | PRJNA436017 | 9550 | 281 | 1.356557 | 3.81192517 | Metazoa | 33208 | Mollusca | Mollusca | 520 | 5.909999999999999e-143 | NTclustered | gi|1928112764|gb|MT947788.1| | 6523 | g9252 | i0 | 100 | 99.7224199288256 | 281 | 0 | 100 | 0 | 1 | 281 | 36 | 316 | Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds | blastn | 28022 | 520 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 13184682 | 13184682 | PRJNA436017_P_NODE_7471_length_325_cov_1.652778_g7174_i0 | PRJNA436017 | 7471 | 325 | 1.652778 | 5.3715285 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 187 | 8.02e-43 | NTclustered | gi|1697450084|ref|XM_029784716.1| | 2607531 | g7174 | i0 | 84.946 | 52.5384615384615 | 186 | 26 | 57 | 2 | 1 | 185 | 143 | 327 | PREDICTED: Octopus sinensis histone H3.3-like (LOC115215535), mRNA | blastn | 17075 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 13842664 | 13842664 | PRJNA436017_P_NODE_851_length_997_cov_12.428125_g713_i0 | PRJNA436017 | 851 | 997 | 12.428125 | 123.90840625 | Metazoa | 33208 | Mollusca | Mollusca | 206 | 7.33e-48 | NTclustered | gi|2022611928|dbj|LC597644.1| | 6613 | g713 | i0 | 86.885 | 18.3309929789368 | 183 | 24 | 18 | 0 | 112 | 294 | 1975 | 1793 | Euprymna scolopes 2020GS-euscolo gene for 28S rRNA, partial sequence | blastn | 18276 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiolidae | Euprymna | Euprymna scolopes | |
| 25315224 | 25315224 | PRJNA436017_P_NODE_24820_length_164_cov_1.141732_g24522_i0 | PRJNA436017 | 24820 | 164 | 1.141732 | 1.87244048 | Octopoda | 6638 | Mollusca | Mollusca | 255 | 9.72e-64 | NTclustered | gi|2217048103|gb|ON156549.1| | 61709 | g24522 | i0 | 100 | 84.9512195121951 | 138 | 0 | 84 | 0 | 27 | 164 | 35 | 172 | Bolitaena pygmaea isolate A200083 small subunit ribosomal RNA gene, partial sequence | blastn | 13932 | 255 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Bolitaenidae | Bolitaena | Bolitaena pygmaea | |
| 27771014 | 27771014 | PRJNA436017_P_NODE_15004_length_214_cov_2.768362_g14706_i0 | PRJNA436017 | 15004 | 214 | 2.768362 | 5.92429468 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 42.7 | 0.0257 | NR | KAH3698300.1 | 45954 | g14706 | i0 | 51.2 | 0.602803738317757 | 43 | 21 | 60.3 | 0 | 52 | 180 | 413 | 455 | KAH3698300.1 hypothetical protein DPMN_085819, partial [Dreissena polymorpha] | diamond | 129 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 28545235 | 28545235 | PRJNA436017_P_NODE_24467_length_165_cov_1.203125_g24169_i0 | PRJNA436017 | 24467 | 165 | 1.203125 | 1.98515625 | Mollusca | 6447 | Mollusca | Mollusca | 66.2 | 6.53e-11 | NR | WAR00884.1 | 6604 | g24169 | i0 | 58 | 5.56363636363636 | 50 | 21 | 90.9 | 0 | 151 | 2 | 2046 | 2095 | WAR00884.1 SVEP1-like protein, partial [Mya arenaria] | diamond | 918 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 28576533 | 28576533 | PRJNA436017_P_NODE_24987_length_163_cov_1.531746_g24689_i0 | PRJNA436017 | 24987 | 163 | 1.531746 | 2.49674598 | root | 1 | Root_unresolved | Root_unresolved | 68.2 | 4.43e-12 | NR | XP_048779614.1 | 37623 | g24689 | i0 | 59.3 | 7.82208588957055 | 54 | 21 | 97.5 | 1 | 3 | 161 | 167 | 220 | XP_048779614.1 uncharacterized protein LOC125683004 isoform X1 [Ostrea edulis] | diamond | 1275 | 68.6 | 0.994169096209913 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 31118226 | 31118226 | PRJNA436017_P_NODE_20575_length_180_cov_1.895105_g20277_i0 | PRJNA436017 | 20575 | 180 | 1.895105 | 3.411189 | Bactronophorus thoracites | 2663719 | Mollusca | Mollusca | 65.5 | 9e-11 | NR | YP_010393075.1 | 2663719 | g20277 | i0 | 55.1 | 3.98333333333333 | 49 | 22 | 81.7 | 0 | 148 | 2 | 173 | 221 | YP_010393075.1 cytochrome c oxidase subunit III [Bactronophorus thoracites] | diamond | 717 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Teredinidae | Bactronophorus | Bactronophorus thoracites | |
| 31593032 | 31593032 | PRJNA436017_P_NODE_17936_length_193_cov_102.250000_g17638_i0 | PRJNA436017 | 17936 | 193 | 102.25 | 197.3425 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 43.9 | 0.00257 | NR | XP_041378708.1 | 1735272 | g17638 | i0 | 43.8 | 0.994818652849741 | 64 | 32 | 99.5 | 1 | 193 | 2 | 11 | 70 | XP_041378708.1 uncharacterized protein LOC121390953 [Gigantopelta aegis] | diamond | 192 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 32888294 | 32888294 | PRJNA436017_P_NODE_7920_length_314_cov_4.054152_g7623_i0 | PRJNA436017 | 7920 | 314 | 4.054152 | 12.73003728 | Potamilus streckersoni | 2493646 | Mollusca | Mollusca | 120 | 4.88e-31 | NR | KAK3584595.1 | 2493646 | g7623 | i0 | 67.8 | 19.0222929936306 | 90 | 29 | 86 | 0 | 270 | 1 | 105 | 194 | KAK3584595.1 hypothetical protein CHS0354_017741 [Potamilus streckersoni] | diamond | 5973 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni |
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);;