contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA1093008" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12952124 | 12952124 | PRJNA1093008_S_NODE_12191_length_422_cov_2.538682_g11865_i0 | PRJNA1093008 | 12191 | 422 | 2.538682 | 10.71323804 | root | 1 | Root_unresolved | Root_unresolved | 114 | 2.9500000000000003e-27 | NR | XP_022322533.1 | 6565 | g11865 | i0 | 48.4 | 1.77725118483412 | 126 | 54 | 83.9 | 4 | 421 | 68 | 243 | 365 | XP_022322533.1 protein SGT1 homolog [Crassostrea virginica] | diamond | 750 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 27541622 | 27541622 | PRJNA1093008_S_NODE_36704_length_321_cov_0.915323_g36377_i0 | PRJNA1093008 | 36704 | 321 | 0.915323 | 2.93818683 | Sinanodonta woodiana | 1069815 | Mollusca | Mollusca | 96.3 | 1.03e-21 | NR | KAL3886275.1 | 1069815 | g36377 | i0 | 74.6 | 3.30841121495327 | 59 | 15 | 55.1 | 0 | 288 | 112 | 192 | 250 | KAL3886275.1 hypothetical protein ACJMK2_026282 [Sinanodonta woodiana] | diamond | 1062 | 96.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Sinanodonta | Sinanodonta woodiana | |
| 27699747 | 27699747 | PRJNA1093008_S_NODE_70584_length_264_cov_1.209424_g70257_i0 | PRJNA1093008 | 70584 | 264 | 1.209424 | 3.19287936 | Pinctada imbricata | 66713 | Mollusca | Mollusca | 53.1 | 1.02e-5 | NR | KAK3102618.1 | 66713 | g70257 | i0 | 37.4 | 4.11363636363636 | 91 | 52 | 97.7 | 1 | 2 | 259 | 30 | 120 | KAK3102618.1 hypothetical protein FSP39_012698 [Pinctada imbricata] | diamond | 1086 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada imbricata | |
| 27943479 | 27943479 | PRJNA1093008_S_NODE_62605_length_274_cov_2.681592_g62278_i0 | PRJNA1093008 | 62605 | 274 | 2.681592 | 7.34756208 | Metazoa | 33208 | Mollusca | Mollusca | 56.2 | 9.59e-7 | NR | XP_021348650.1 | 6573 | g62278 | i0 | 66.7 | 7.12773722627737 | 39 | 13 | 42.7 | 0 | 117 | 1 | 465 | 503 | XP_021348650.1 WD40 repeat-containing protein SMU1 [Mizuhopecten yessoensis] | diamond | 1953 | 56.6 | 0.992932862190813 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 28141688 | 28141688 | PRJNA1093008_S_NODE_66345_length_269_cov_2.357143_g66018_i0 | PRJNA1093008 | 66345 | 269 | 2.357143 | 6.34071467 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 47 | 0.00161 | NR | XP_052221657.1 | 45954 | g66018 | i0 | 36.9 | 4.29368029739777 | 65 | 33 | 72.5 | 1 | 3 | 197 | 431 | 487 | XP_052221657.1 zinc finger BED domain-containing protein 4-like [Dreissena polymorpha] | diamond | 1155 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 28709957 | 28709957 | PRJNA1093008_S_NODE_82967_length_250_cov_1.299435_g82640_i0 | PRJNA1093008 | 82967 | 250 | 1.299435 | 3.2485875 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 43.5 | 0.0182 | NR | KAK7105128.1 | 31220 | g82640 | i0 | 48.7 | 0.852 | 39 | 17 | 46.8 | 1 | 125 | 241 | 187 | 222 | KAK7105128.1 hypothetical protein V1264_019730 [Littorina saxatilis] | diamond | 213 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 29909796 | 29909796 | PRJNA1093008_S_NODE_98231_length_234_cov_3.757764_g97904_i0 | PRJNA1093008 | 98231 | 234 | 3.757764 | 8.79316776 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 62 | 5.24e-9 | NR | XP_060597076.1 | 129788 | g97904 | i0 | 53.4 | 0.743589743589744 | 58 | 26 | 73.1 | 1 | 47 | 217 | 24 | 81 | XP_060597076.1 uncharacterized protein LOC132750994 isoform X1 [Ruditapes philippinarum] | diamond | 174 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 30375366 | 30375366 | PRJNA1093008_S_NODE_39472_length_314_cov_3.136929_g39145_i0 | PRJNA1093008 | 39472 | 314 | 3.136929 | 9.84995706 | root | 1 | Root_unresolved | Root_unresolved | 51.6 | 6.85e-5 | NR | KAK3105572.1 | 66713 | g39145 | i0 | 34.7 | 2.65605095541401 | 72 | 42 | 64 | 2 | 269 | 69 | 181 | 252 | KAK3105572.1 hypothetical protein FSP39_000853 [Pinctada imbricata] | diamond | 834 | 52 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada imbricata | |
| 30627504 | 30627504 | PRJNA1093008_S_NODE_73153_length_260_cov_7.759358_g72826_i0 | PRJNA1093008 | 73153 | 260 | 7.759358 | 20.1743308 | Metazoa | 33208 | Mollusca | Mollusca | 50.1 | 1.18e-4 | NR | OWF51016.1 | 6573 | g72826 | i0 | 96.2 | 57.3 | 26 | 1 | 30 | 0 | 1 | 78 | 505 | 530 | OWF51016.1 Tubulin alpha-1A chain [Mizuhopecten yessoensis] | diamond | 14898 | 50.4 | 0.994047619047619 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 31164507 | 31164507 | PRJNA1093008_S_NODE_98995_length_232_cov_2.251572_g98668_i0 | PRJNA1093008 | 98995 | 232 | 2.251572 | 5.22364704 | Metazoa | 33208 | Mollusca | Mollusca | 88.6 | 1.47e-19 | NR | XP_046356566.1 | 6454 | g98668 | i0 | 92.5 | 22.3836206896552 | 40 | 3 | 51.7 | 0 | 70 | 189 | 103 | 142 | XP_046356566.1 polyadenylate-binding protein 2-B-like [Haliotis rufescens] | diamond | 5193 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 31354612 | 31354612 | PRJNA1093008_S_NODE_59196_length_279_cov_2.354369_g58869_i0 | PRJNA1093008 | 59196 | 279 | 2.354369 | 6.56868951 | Elysia | 71493 | Mollusca | Mollusca | 72.8 | 6.77e-14 | NR | KAK3697589.1 | 231223 | g58869 | i0 | 65.4 | 3.35483870967742 | 52 | 18 | 55.9 | 0 | 278 | 123 | 91 | 142 | KAK3697589.1 hypothetical protein RRG08_033319 [Elysia crispata] | diamond | 936 | 73.2 | 0.994535519125683 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 32027499 | 32027499 | PRJNA1093008_S_NODE_25678_length_351_cov_2.956835_g25351_i0 | PRJNA1093008 | 25678 | 351 | 2.956835 | 10.37849085 | Saccostrea cuccullata | 36930 | Mollusca | Mollusca | 45.1 | 0.0183 | NR | XP_062582245.1 | 36930 | g25351 | i0 | 45.5 | 2.11111111111111 | 55 | 27 | 44.4 | 1 | 186 | 341 | 426 | 480 | XP_062582245.1 uncharacterized protein LOC134244011 [Saccostrea cuccullata] | diamond | 741 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata |
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);;