contig_metadata
7 rows where bioproject = "PRJNA577226" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4965348 | 4965348 | PRJNA577226_S_NODE_25864_length_246_cov_9.119617_g24925_i0 | PRJNA577226 | 25864 | 246 | 9.119617 | 22.43425782 | Stylommatophora | 6527 | Mollusca | Mollusca | 455 | 1.4500000000000002e-123 | NTclustered | gi|45360329|gb|AY546382.1| | 42349 | g24925 | i0 | 100 | 152.906504065041 | 246 | 0 | 100 | 0 | 1 | 246 | 118 | 363 | Albinaria caerulea 18S ribosomal RNA gene, partial sequence | blastn | 37615 | 455 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Clausiliidae | Albinaria | Albinaria caerulea | |
| 7515187 | 7515187 | PRJNA577226_S_NODE_36326_length_206_cov_3.715976_g35387_i0 | PRJNA577226 | 36326 | 206 | 3.715976 | 7.65491056 | Cochlicopa | 82565 | Mollusca | Mollusca | 375 | 9.41e-100 | NTclustered | gi|13794040|gb|AY014020.1| | 82566 | g35387 | i0 | 99.515 | 100.033980582524 | 206 | 1 | 100 | 0 | 1 | 206 | 865 | 660 | Cochlicopa lubricella 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 20607 | 375 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Cochlicopidae | Cochlicopa | Cochlicopa lubricella | |
| 8214444 | 8214444 | PRJNA577226_S_NODE_19427_length_288_cov_5.270916_g18488_i0 | PRJNA577226 | 19427 | 288 | 5.270916 | 15.18023808 | Apoecus ramelauensis | 1918943 | Mollusca | Mollusca | 466 | 8.03e-127 | NTclustered | gi|1108658002|gb|KX015964.1| | 1918943 | g18488 | i0 | 96.14 | 177.559027777778 | 285 | 11 | 99 | 0 | 4 | 288 | 3736 | 3452 | Apoecus ramelauensis voucher AM C.488753 28S ribosomal RNA gene, partial sequence | blastn | 51137 | 466 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Apoecus | Apoecus ramelauensis | |
| 13315529 | 13315529 | PRJNA577226_S_NODE_25871_length_246_cov_3.454545_g24932_i0 | PRJNA577226 | 25871 | 246 | 3.454545 | 8.4981807 | Cochlicopa lubrica | 82567 | Mollusca | Mollusca | 448 | 2.4299999999999995e-121 | NTclustered | gi|13794039|gb|AY014019.1| | 82567 | g24932 | i0 | 99.593 | 100.182926829268 | 246 | 0 | 100 | 1 | 1 | 246 | 1147 | 1391 | Cochlicopa lubrica 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 24645 | 448 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Cochlicopidae | Cochlicopa | Cochlicopa lubrica | |
| 13891345 | 13891345 | PRJNA577226_S_NODE_32271_length_219_cov_4.489011_g31332_i0 | PRJNA577226 | 32271 | 219 | 4.489011 | 9.83093409 | Stylommatophora | 6527 | Mollusca | Mollusca | 399 | 6.009999999999999e-107 | NTclustered | gi|1700712068|gb|MN022659.1| | 69431 | g31332 | i0 | 99.543 | 100 | 219 | 1 | 100 | 0 | 1 | 219 | 3200 | 3418 | Albinaria xanthostoma 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 21900 | 399 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Clausiliidae | Albinaria | Albinaria xanthostoma | |
| 19688893 | 19688893 | PRJNA577226_S_NODE_61236_length_161_cov_0.943548_g60297_i0 | PRJNA577226 | 61236 | 161 | 0.943548 | 1.51911228 | Haliotis asinina | 109174 | Mollusca | Mollusca | 147 | 5.959999999999999e-31 | NTclustered | gi|2793421131|ref|XM_067823665.1| | 109174 | g60297 | i0 | 83.125 | 21.2422360248447 | 160 | 27 | 99 | 0 | 2 | 161 | 2965 | 3124 | PREDICTED: Haliotis asinina uncharacterized protein (LOC137292124), mRNA | blastn | 3420 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 29290063 | 29290063 | PRJNA577226_S_NODE_29889_length_228_cov_3.633508_g28950_i0 | PRJNA577226 | 29889 | 228 | 3.633508 | 8.28439824 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 63.9 | 1.04e-9 | NR | KAH3698300.1 | 45954 | g28950 | i0 | 60.6 | 0.868421052631579 | 66 | 21 | 86.8 | 1 | 25 | 222 | 378 | 438 | KAH3698300.1 hypothetical protein DPMN_085819, partial [Dreissena polymorpha] | diamond | 198 | 63.9 | 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);;