contig_metadata
11 rows where bioproject = "PRJNA814235", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5054715 | 5054715 | PRJNA814235_P_NODE_200424_length_150_cov_2.911504_g199029_i0 | PRJNA814235 | 200424 | 150 | 2.911504 | 4.367256 | Polyplacophora | 6650 | Mollusca | Mollusca | 137 | 3.28e-28 | NTclustered | gi|82622095|gb|DQ279957.1| | 126420 | g199029 | i0 | 84.667 | 100.173333333333 | 150 | 10 | 96 | 10 | 7 | 150 | 1132 | 1274 | Acanthochitona crinita 28S ribosomal RNA gene, partial sequence | blastn | 15026 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Acanthochitonidae | Acanthochitona | Acanthochitona crinita | |
| 5054804 | 5054804 | PRJNA814235_P_NODE_23924_length_390_cov_4.240793_g22556_i0 | PRJNA814235 | 23924 | 390 | 4.240793 | 16.5390927 | Ambigolimax | 1338343 | Mollusca | Mollusca | 710 | 0 | NTclustered | gi|2214778894|gb|ON128215.1| | 1338344 | g22556 | i0 | 99.487 | 99.5820512820513 | 390 | 2 | 100 | 0 | 1 | 390 | 112 | 501 | Ambigolimax valentianus isolate 2300 large subunit ribosomal RNA gene, partial sequence | blastn | 38837 | 710 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Limacidae | Ambigolimax | Ambigolimax valentianus | |
| 6331655 | 6331655 | PRJNA814235_P_NODE_81005_length_211_cov_2.298851_g79610_i0 | PRJNA814235 | 81005 | 211 | 2.298851 | 4.85057561 | Metazoa | 33208 | Mollusca | Mollusca | 390 | 3.459999999999999e-104 | NTclustered | gi|1928112764|gb|MT947788.1| | 6523 | g79610 | i0 | 100 | 100 | 211 | 0 | 100 | 0 | 1 | 211 | 425 | 215 | Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds | blastn | 21100 | 390 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 9744669 | 9744669 | PRJNA814235_P_NODE_174408_length_156_cov_1.865546_g173013_i0 | PRJNA814235 | 174408 | 156 | 1.865546 | 2.91025176 | Angulyagra sp. 1 AJ-2009 | 634704 | Mollusca | Mollusca | 130 | 5.77e-26 | NTclustered | gi|228552837|gb|FJ405819.1| | 634704 | g173013 | i0 | 82.353 | 57.3461538461538 | 153 | 23 | 97 | 4 | 6 | 156 | 331 | 181 | Angulyagra sp. 1 AJ-2009 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 8946 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Viviparidae | Angulyagra | Angulyagra sp. 1 AJ-2009 | |
| 13571853 | 13571853 | PRJNA814235_P_NODE_67571_length_231_cov_6.185567_g66176_i0 | PRJNA814235 | 67571 | 231 | 6.185567 | 14.28865977 | Deroceras reticulatum | 145610 | Mollusca | Mollusca | 368 | 1.7999999999999995e-97 | NTclustered | gi|973291011|gb|KU341314.1| | 145610 | g66176 | i0 | 95.671 | 100.904761904762 | 231 | 7 | 100 | 3 | 1 | 231 | 846 | 1073 | Deroceras reticulatum isolate N_derr_ci 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 23309 | 368 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Agriolimacidae | Deroceras | Deroceras reticulatum | |
| 16118878 | 16118878 | PRJNA814235_P_NODE_160613_length_166_cov_1.209302_g159218_i0 | PRJNA814235 | 160613 | 166 | 1.209302 | 2.00744132 | Geomalacus anguiformis | 1505099 | Mollusca | Mollusca | 307 | 2.69e-79 | NTclustered | gi|1511255144|gb|MK152514.1| | 1505099 | g159218 | i0 | 100 | 153.650602409639 | 166 | 0 | 100 | 0 | 1 | 166 | 184 | 349 | Geomalacus anguiformis isolate USCM:6251 small subunit ribosomal RNA gene, partial sequence | blastn | 25506 | 307 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Arionidae | Geomalacus | Geomalacus anguiformis | |
| 18669160 | 18669160 | PRJNA814235_P_NODE_46255_length_280_cov_3.954733_g44863_i0 | PRJNA814235 | 46255 | 280 | 3.954733 | 11.0732524 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 67.6 | 9.21e-7 | NTclustered | gi|2616504246|ref|XR_009624436.1| | 129788 | g44863 | i0 | 84.848 | 0.235714285714286 | 66 | 10 | 24 | 0 | 12 | 77 | 112 | 177 | PREDICTED: Ruditapes philippinarum uncharacterized LOC132721255 (LOC132721255), ncRNA | blastn | 66 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 20354048 | 20354048 | PRJNA814235_P_NODE_83376_length_208_cov_2.134503_g81981_i0 | PRJNA814235 | 83376 | 208 | 2.134503 | 4.43976624 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|1835526098|ref|XM_033895980.1| | 6579 | g81981 | i0 | 94.595 | 1.18269230769231 | 37 | 1 | 17 | 1 | 81 | 116 | 1719 | 1755 | PREDICTED: Pecten maximus uncharacterized LOC117335790 (LOC117335790), mRNA | blastn | 246 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 23768212 | 23768212 | PRJNA814235_P_NODE_136979_length_187_cov_1.926667_g135584_i0 | PRJNA814235 | 136979 | 187 | 1.926667 | 3.60286729 | Ambigolimax valentianus | 1338344 | Mollusca | Mollusca | 340 | 3.0499999999999998e-89 | NTclustered | gi|1371950955|dbj|LC375324.1| | 1338344 | g135584 | i0 | 99.465 | 100.149732620321 | 187 | 1 | 100 | 0 | 1 | 187 | 237 | 51 | Ambigolimax valentianus 18S ribosomal RNA, partial sequence | blastn | 18728 | 340 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Limacidae | Ambigolimax | Ambigolimax valentianus | |
| 25453792 | 25453792 | PRJNA814235_P_NODE_51920_length_264_cov_3.925110_g50526_i0 | PRJNA814235 | 51920 | 264 | 3.92511 | 10.3622904 | Stylommatophora | 6527 | Mollusca | Mollusca | 470 | 5.62e-128 | NTclustered | gi|1220130441|gb|MF444870.1| | 2017780 | g50526 | i0 | 99.231 | 98.4848484848485 | 260 | 2 | 98 | 0 | 5 | 264 | 3385 | 3126 | Cecilioides gokweanus isolate cecg 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 26000 | 470 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Ferussaciidae | Cecilioides | Cecilioides gokweanus | |
| 29517399 | 29517399 | PRJNA814235_P_NODE_159270_length_167_cov_1.200000_g157875_i0 | PRJNA814235 | 159270 | 167 | 1.2 | 2.004 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 53.1 | 2.8e-6 | NR | KAH3698300.1 | 45954 | g157875 | i0 | 69.4 | 0.646706586826347 | 36 | 10 | 64.7 | 1 | 165 | 58 | 400 | 434 | KAH3698300.1 hypothetical protein DPMN_085819, partial [Dreissena polymorpha] | diamond | 108 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha |
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);;