contig_metadata
15 rows where bioproject = "PRJNA1264536", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2914581 | 2914581 | PRJNA1264536_P_NODE_223_length_1154_cov_23.558742_g186_i0 | PRJNA1264536 | 223 | 1154 | 23.558742 | 271.86788268 | Amplirhagada cf. alkuonides WAM S37656 | 1580562 | Mollusca | Mollusca | 71.3 | 3.25e-7 | NTclustered | gi|730451398|gb|KP085045.1| | 1580562 | g186 | i0 | 74.731 | 0.161178509532062 | 186 | 34 | 16 | 10 | 557 | 737 | 324 | 501 | Amplirhagada cf. alkuonides WAM S37656 clone a 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 186 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Amplirhagada | Amplirhagada cf. alkuonides WAM S37656 | |
| 5467226 | 5467226 | PRJNA1264536_P_NODE_2705_length_340_cov_2.093633_g2631_i0 | PRJNA1264536 | 2705 | 340 | 2.093633 | 7.1183522 | Metazoa | 33208 | Mollusca | Mollusca | 127 | 7.93e-35 | NR | KAL5016701.1 | 13268 | g2631 | i0 | 78 | 49.6147058823529 | 82 | 18 | 72.4 | 0 | 252 | 7 | 34 | 115 | KAL5016701.1 hypothetical protein ScPMuIL_006290 [Solemya velum] | diamond | 16869 | 128 | 0.9921875 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 8017272 | 8017272 | PRJNA1264536_P_NODE_3767_length_281_cov_1.096154_g3693_i0 | PRJNA1264536 | 3767 | 281 | 1.096154 | 3.08019274 | Mya arenaria | 6604 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|2427467042|ref|XM_052939866.1| | 6604 | g3693 | i0 | 100 | 0.206405693950178 | 29 | 0 | 10 | 0 | 92 | 120 | 938 | 966 | PREDICTED: Mya arenaria cell division control protein 42 homolog (LOC128228518), transcript variant X1, mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 14393037 | 14393037 | PRJNA1264536_P_NODE_1492_length_472_cov_1.438596_g1418_i0 | PRJNA1264536 | 1492 | 472 | 1.438596 | 6.79017312 | Physella acuta | 109671 | Mollusca | Mollusca | 52.8 | 0.046 | NTclustered | gi|2572411827|ref|XM_059320587.1| | 109671 | g1418 | i0 | 96.774 | 0.0656779661016949 | 31 | 1 | 7 | 0 | 169 | 199 | 2135 | 2165 | PREDICTED: Physella acuta uncharacterized LOC131956164 (LOC131956164), mRNA | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 16356454 | 16356454 | PRJNA1264536_P_NODE_4273_length_255_cov_1.978022_g4199_i0 | PRJNA1264536 | 4273 | 255 | 1.978022 | 5.0439561 | Corbicula | 45948 | Mollusca | Mollusca | 466 | 6.98e-127 | NTclustered | gi|8489067|gb|AF152024.1| | 45949 | g4199 | i0 | 100 | 98.5254901960784 | 252 | 0 | 99 | 0 | 1 | 252 | 96 | 347 | Corbicula fluminea 16S large subunit ribosomal RNA gene, partial sequence; mitochondrial gene for mitochondrial product | blastn | 25124 | 466 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Cyrenidae | Corbicula | Corbicula fluminea | |
| 22040540 | 22040540 | PRJNA1264536_P_NODE_2478_length_357_cov_1.021127_g2404_i0 | PRJNA1264536 | 2478 | 357 | 1.021127 | 3.64542339 | Metazoa | 33208 | Mollusca | Mollusca | 186 | 6.389999999999999e-54 | NR | XP_048252474.1 | 6454 | g2404 | i0 | 72.9 | 36.6890756302521 | 118 | 32 | 99.2 | 0 | 356 | 3 | 268 | 385 | XP_048252474.1 aldehyde dehydrogenase, mitochondrial-like [Haliotis rufescens] | diamond | 13098 | 187 | 0.994652406417112 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 24590177 | 24590177 | PRJNA1264536_P_NODE_3040_length_321_cov_1.479839_g2966_i0 | PRJNA1264536 | 3040 | 321 | 1.479839 | 4.75028319 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 120 | 2.58e-29 | NR | XP_021365646.1 | 6573 | g2966 | i0 | 67.1 | 8.62616822429907 | 82 | 27 | 76.6 | 0 | 75 | 320 | 7 | 88 | XP_021365646.1 retinal dehydrogenase 1-like isoform X1 [Mizuhopecten yessoensis] | diamond | 2769 | 121 | 0.991735537190083 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 27326815 | 27326815 | PRJNA1264536_P_NODE_4883_length_248_cov_0.891429_g4809_i0 | PRJNA1264536 | 4883 | 248 | 0.891429 | 2.21074392 | Solemya velum | 13268 | Mollusca | Mollusca | 73.2 | 7.15e-13 | NR | KAL5008673.1 | 13268 | g4809 | i0 | 46.8 | 2.04435483870968 | 79 | 37 | 91.9 | 2 | 18 | 245 | 12 | 88 | KAL5008673.1 hypothetical protein ScPMuIL_014254 [Solemya velum] | diamond | 507 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 27439658 | 27439658 | PRJNA1264536_P_NODE_3943_length_272_cov_1.567839_g3869_i0 | PRJNA1264536 | 3943 | 272 | 1.567839 | 4.26452208 | Haliotis | 6452 | Mollusca | Mollusca | 123 | 2.8799999999999997e-30 | NR | XP_071105100.1 | 6455 | g3869 | i0 | 60 | 4.66544117647059 | 85 | 34 | 93.8 | 0 | 15 | 269 | 603 | 687 | XP_071105100.1 probable chitinase 10 [Haliotis cracherodii] | diamond | 1269 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis cracherodii | |
| 27755370 | 27755370 | PRJNA1264536_P_NODE_5124_length_246_cov_0.901734_g5050_i0 | PRJNA1264536 | 5124 | 246 | 0.901734 | 2.21826564 | Mollusca | 6447 | Mollusca | Mollusca | 144 | 5.02e-41 | NR | XP_046375631.1 | 6454 | g5050 | i0 | 75.3 | 5.89024390243902 | 81 | 20 | 98.8 | 0 | 1 | 243 | 27 | 107 | XP_046375631.1 serine/arginine-rich splicing factor 7-like isoform X1 [Haliotis rufescens] | diamond | 1449 | 145 | 0.993103448275862 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 27895058 | 27895058 | PRJNA1264536_P_NODE_5505_length_242_cov_0.923077_g5431_i0 | PRJNA1264536 | 5505 | 242 | 0.923077 | 2.23384634 | Patella vulgata | 6465 | Mollusca | Mollusca | 69.3 | 5.75e-12 | NR | XP_050403898.1 | 6465 | g5431 | i0 | 56.8 | 1.00413223140496 | 81 | 26 | 99.2 | 3 | 242 | 3 | 151 | 223 | XP_050403898.1 U2 small nuclear ribonucleoprotein A' isoform X2 [Patella vulgata] | diamond | 243 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 29726183 | 29726183 | PRJNA1264536_P_NODE_5550_length_242_cov_0.923077_g5476_i0 | PRJNA1264536 | 5550 | 242 | 0.923077 | 2.23384634 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 56.6 | 4.05e-7 | NR | XP_025106186.1 | 400727 | g5476 | i0 | 44.6 | 0.805785123966942 | 65 | 35 | 80.6 | 1 | 240 | 46 | 186 | 249 | XP_025106186.1 40S ribosomal protein SA-like [Pomacea canaliculata] | diamond | 195 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 30421825 | 30421825 | PRJNA1264536_P_NODE_3393_length_301_cov_1.026316_g3319_i0 | PRJNA1264536 | 3393 | 301 | 1.026316 | 3.08921116 | Mactra antiquata | 2302425 | Mollusca | Mollusca | 61.6 | 1.63e-8 | NR | KAL4224857.1 | 2302425 | g3319 | i0 | 67.4 | 0.428571428571429 | 43 | 14 | 42.9 | 0 | 142 | 14 | 68 | 110 | KAL4224857.1 Nucleosome assembly protein 1-like 1 [Mactra antiquata] | diamond | 129 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Mactridae | Mactra | Mactra antiquata | |
| 30453294 | 30453294 | PRJNA1264536_P_NODE_3413_length_300_cov_1.030837_g3339_i0 | PRJNA1264536 | 3413 | 300 | 1.030837 | 3.092511 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 85.1 | 9.91e-17 | NR | XP_022333269.1 | 6565 | g3339 | i0 | 39.8 | 4.34 | 88 | 51 | 88 | 1 | 268 | 5 | 2683 | 2768 | XP_022333269.1 papilin-like isoform X1 [Crassostrea virginica] | diamond | 1302 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 32476903 | 32476903 | PRJNA1264536_P_NODE_3599_length_290_cov_1.078341_g3525_i0 | PRJNA1264536 | 3599 | 290 | 1.078341 | 3.1271889 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 77 | 5.88e-14 | NR | XP_021345467.1 | 6573 | g3525 | i0 | 44.8 | 0.993103448275862 | 96 | 53 | 99.3 | 0 | 3 | 290 | 316 | 411 | XP_021345467.1 paramyosin-like isoform X1 [Mizuhopecten yessoensis] | diamond | 288 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis |
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);;