contig_metadata
15 rows where bioproject = "PRJNA734348", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1993025 | 1993025 | PRJNA734348_P_NODE_115862_length_245_cov_0.895349_g115164_i0 | PRJNA734348 | 115862 | 245 | 0.895349 | 2.19360505 | Desmaulus extinctorium | 211681 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2519763012|ref|NC_079658.1| | 211681 | g115164 | i0 | 100 | 0.114285714285714 | 28 | 0 | 11 | 0 | 35 | 62 | 1533 | 1560 | Desmaulus extinctorium mitochondrion, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Calyptraeidae | Desmaulus | Desmaulus extinctorium | |
| 1994617 | 1994617 | PRJNA734348_P_NODE_60922_length_278_cov_5.629268_g60225_i0 | PRJNA734348 | 60922 | 278 | 5.629268 | 15.64936504 | Aplysia californica | 6500 | Mollusca | Mollusca | 333 | 8.159999999999999e-87 | NTclustered | gi|1897939407|ref|XR_004859148.1| | 6500 | g60225 | i0 | 89.007 | 105.964028776978 | 282 | 14 | 100 | 12 | 1 | 278 | 3736 | 3468 | PREDICTED: Aplysia californica large subunit ribosomal RNA (LOC118478578), rRNA | blastn | 29458 | 333 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 6301641 | 6301641 | PRJNA734348_P_NODE_95405_length_250_cov_1.559322_g94707_i0 | PRJNA734348 | 95405 | 250 | 1.559322 | 3.898305 | Lymnaeidae | 6521 | Mollusca | Mollusca | 457 | 4.1099999999999985e-124 | NTclustered | gi|2581856089|gb|OR600223.1| | 161081 | g94707 | i0 | 99.6 | 99.9 | 250 | 1 | 100 | 0 | 1 | 250 | 696 | 447 | Ampullaceana lagotis isolate UO5 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 24975 | 457 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Ampullaceana | Ampullaceana lagotis | ||
| 19048821 | 19048821 | PRJNA734348_P_NODE_18555_length_475_cov_1.330846_g17865_i0 | PRJNA734348 | 18555 | 475 | 1.330846 | 6.3215185 | Opisthokonta | 33154 | Mollusca | Mollusca | 213 | 2.7699999999999998e-67 | NR | KAH9496419.1 | 55810 | g17865 | i0 | 72.9 | 27.7705263157895 | 144 | 39 | 90.9 | 0 | 474 | 43 | 52 | 195 | KAH9496419.1 40S ribosomal protein S16 [Bulinus truncatus] | diamond | 13191 | 214 | 0.995327102803738 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Bulinus | Bulinus truncatus | ||
| 21121557 | 21121557 | PRJNA734348_P_NODE_83537_length_257_cov_2.869565_g82839_i0 | PRJNA734348 | 83537 | 257 | 2.869565 | 7.37478205 | Mytilus californianus | 6549 | Mollusca | Mollusca | 52.8 | 0.023 | NTclustered | gi|2334757812|ref|XM_052208460.1| | 6549 | g82839 | i0 | 100 | 0.326848249027237 | 28 | 0 | 11 | 0 | 1 | 28 | 2038 | 2065 | PREDICTED: Mytilus californianus potassium voltage-gated channel protein Shaker-like (LOC127704423), transcript variant X3, mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 23671237 | 23671237 | PRJNA734348_P_NODE_40219_length_310_cov_3.464135_g39523_i0 | PRJNA734348 | 40219 | 310 | 3.464135 | 10.7388185 | Patella vulgata | 6465 | Mollusca | Mollusca | 63.9 | 1.34e-5 | NTclustered | gi|2506338476|ref|XM_050557452.2| | 6465 | g39523 | i0 | 85.484 | 0.470967741935484 | 62 | 8 | 20 | 1 | 241 | 302 | 3402 | 3462 | PREDICTED: Patella vulgata protein MON2 homolog (LOC126827883), mRNA | blastn | 146 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 27125447 | 27125447 | PRJNA734348_P_NODE_59362_length_280_cov_1.826087_g58665_i0 | PRJNA734348 | 59362 | 280 | 1.826087 | 5.1130436 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 85.9 | 4.02e-17 | NR | XP_021379695.1 | 6573 | g58665 | i0 | 48.9 | 18.8892857142857 | 94 | 41 | 97.5 | 3 | 3 | 275 | 2247 | 2336 | XP_021379695.1 ubiquitin carboxyl-terminal hydrolase 34-like isoform X1 [Mizuhopecten yessoensis] | diamond | 5289 | 86.3 | 0.995365005793743 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 27242024 | 27242024 | PRJNA734348_P_NODE_85923_length_255_cov_2.747253_g85225_i0 | PRJNA734348 | 85923 | 255 | 2.747253 | 7.00549515 | Argopecten irradians | 31199 | Mollusca | Mollusca | 45.4 | 0.00473 | NR | XP_069110020.1 | 31199 | g85225 | i0 | 60.7 | 10.2 | 28 | 9 | 32.9 | 1 | 242 | 159 | 556 | 581 | XP_069110020.1 uncharacterized protein [Argopecten irradians] | diamond | 2601 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 28094761 | 28094761 | PRJNA734348_S_NODE_325_length_456_cov_4.091384_g316_i0 | PRJNA734348 | 325 | 456 | 4.091384 | 18.65671104 | Mytilus edulis | 6550 | Mollusca | Mollusca | 55.5 | 9.37e-6 | NR | CAG2187267.1 | 6550 | g316 | i0 | 41.3 | 2.08552631578947 | 63 | 36 | 40.8 | 1 | 60 | 245 | 192 | 254 | CAG2187267.1 unnamed protein product [Mytilus edulis] | diamond | 951 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 29399392 | 29399392 | PRJNA734348_P_NODE_109049_length_247_cov_0.885057_g108351_i0 | PRJNA734348 | 109049 | 247 | 0.885057 | 2.18609079 | Metazoa | 33208 | Mollusca | Mollusca | 57.8 | 1.93e-7 | NR | XP_022301073.1 | 6565 | g108351 | i0 | 40.3 | 5.24696356275304 | 72 | 43 | 87.4 | 0 | 216 | 1 | 231 | 302 | XP_022301073.1 uncharacterized protein LOC111109279 [Crassostrea virginica] | diamond | 1296 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 30684222 | 30684222 | PRJNA734348_P_NODE_55653_length_284_cov_1.459716_g54956_i0 | PRJNA734348 | 55653 | 284 | 1.459716 | 4.14559344 | Mytilus edulis | 6550 | Mollusca | Mollusca | 90.5 | 9.17e-19 | NR | CAG2200053.1 | 6550 | g54956 | i0 | 84.9 | 1.11971830985915 | 53 | 8 | 56 | 0 | 126 | 284 | 387 | 439 | CAG2200053.1 TMEM129 [Mytilus edulis] | diamond | 318 | 90.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 31094998 | 31094998 | PRJNA734348_P_NODE_123395_length_243_cov_0.905882_g122697_i0 | PRJNA734348 | 123395 | 243 | 0.905882 | 2.20129326 | Batillaria attramentaria | 370345 | Mollusca | Mollusca | 87.4 | 6.8e-18 | NR | KAK7501083.1 | 370345 | g122697 | i0 | 57 | 2.07407407407407 | 79 | 34 | 97.5 | 0 | 2 | 238 | 138 | 216 | KAK7501083.1 hypothetical protein BaRGS_00007568 [Batillaria attramentaria] | diamond | 504 | 87.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Batillariidae | Batillaria | Batillaria attramentaria | ||
| 31284623 | 31284623 | PRJNA734348_P_NODE_117635_length_245_cov_0.895349_g116937_i0 | PRJNA734348 | 117635 | 245 | 0.895349 | 2.19360505 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 75.1 | 8.49e-16 | NR | KAH3829317.1 | 45954 | g116937 | i0 | 70.9 | 1.33469387755102 | 55 | 16 | 67.3 | 0 | 34 | 198 | 1 | 55 | KAH3829317.1 hypothetical protein DPMN_131313 [Dreissena polymorpha] | diamond | 327 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 32297441 | 32297441 | PRJNA734348_P_NODE_139039_length_233_cov_5.862500_g138341_i0 | PRJNA734348 | 139039 | 233 | 5.8625 | 13.659625 | Mytilus edulis | 6550 | Mollusca | Mollusca | 50.1 | 7.82e-5 | NR | CAG2187267.1 | 6550 | g138341 | i0 | 45.3 | 2.02145922746781 | 53 | 28 | 67 | 1 | 74 | 229 | 192 | 244 | CAG2187267.1 unnamed protein product [Mytilus edulis] | diamond | 471 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 32497259 | 32497259 | PRJNA734348_P_NODE_127499_length_242_cov_1.088757_g126801_i0 | PRJNA734348 | 127499 | 242 | 1.088757 | 2.63479194 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 124 | 4.459999999999999e-34 | NR | XP_045177423.1 | 6596 | g126801 | i0 | 74.1 | 19.0537190082645 | 81 | 20 | 99.2 | 1 | 2 | 241 | 4 | 84 | XP_045177423.1 40S ribosomal protein S10-like isoform X2 [Mercenaria mercenaria] | diamond | 4611 | 125 | 0.992 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria |
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);;