contig_metadata
15 rows where bioproject = "PRJNA429937", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1702148 | 1702148 | PRJNA429937_P_NODE_7242_length_1311_cov_15.304992_g4275_i0 | PRJNA429937 | 7242 | 1311 | 15.304992 | 200.64844512 | Sinonovacula constricta | 98310 | Mollusca | Mollusca | 54.7 | 0.037 | NTclustered | gi|937961735|gb|KR534869.1| | 98310 | g4275 | i0 | 100 | 0.0221205186880244 | 29 | 0 | 2 | 0 | 1 | 29 | 5 | 33 | Sinonovacula constricta insulin-like peptide 1 mRNA, complete cds | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Cardiida | Solecurtidae | Sinonovacula | Sinonovacula constricta | |
| 3638298 | 3638298 | PRJNA429937_P_NODE_117823_length_254_cov_1.968889_g95197_i0 | PRJNA429937 | 117823 | 254 | 1.968889 | 5.00097806 | Stylommatophora | 6527 | Mollusca | Mollusca | 222 | 1.66e-53 | NTclustered | gi|34369166|gb|AY145373.1| | 145610 | g95197 | i0 | 99.187 | 69.4685039370079 | 123 | 1 | 76 | 0 | 132 | 254 | 282 | 404 | Deroceras reticulatum 18S ribosomal RNA gene, partial sequence | blastn | 17645 | 222 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Agriolimacidae | Deroceras | Deroceras reticulatum | |
| 5529338 | 5529338 | PRJNA429937_P_NODE_113405_length_265_cov_5.080508_g90782_i0 | PRJNA429937 | 113405 | 265 | 5.080508 | 13.4633462 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.024 | NTclustered | gi|2912996298|dbj|AP039601.1| | 145626 | g90782 | i0 | 100 | 0.105660377358491 | 28 | 0 | 11 | 0 | 49 | 76 | 42889480 | 42889453 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 20, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 5530863 | 5530863 | PRJNA429937_P_NODE_65145_length_423_cov_4.111675_g44423_i0 | PRJNA429937 | 65145 | 423 | 4.111675 | 17.39238525 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 63.9 | 1.88e-5 | NTclustered | gi|2616537603|ref|XM_060709397.1| | 129788 | g44423 | i0 | 91.667 | 0.226950354609929 | 48 | 1 | 11 | 2 | 223 | 270 | 9215 | 9171 | PREDICTED: Ruditapes philippinarum T-cell surface antigen CD2-like (LOC132724530), transcript variant X1, mRNA | blastn | 96 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 18278371 | 18278371 | PRJNA429937_P_NODE_43475_length_543_cov_8.885214_g27786_i0 | PRJNA429937 | 43475 | 543 | 8.885214 | 48.24671202 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 56.5 | 0.004 | NTclustered | gi|1397712978|ref|XM_025247868.1| | 400727 | g27786 | i0 | 100 | 0.718232044198895 | 30 | 0 | 6 | 0 | 346 | 375 | 2316 | 2345 | PREDICTED: Pomacea canaliculata uncharacterized LOC112569844 (LOC112569844), mRNA | blastn | 390 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 19551387 | 19551387 | PRJNA429937_P_NODE_102336_length_295_cov_4.533835_g79722_i0 | PRJNA429937 | 102336 | 295 | 4.533835 | 13.37481325 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 52.8 | 0.027 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g79722 | i0 | 100 | 0.0949152542372881 | 28 | 0 | 9 | 0 | 268 | 295 | 58 | 31 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 22102562 | 22102562 | PRJNA429937_P_NODE_15058_length_947_cov_4.728758_g8886_i0 | PRJNA429937 | 15058 | 947 | 4.728758 | 44.78133826 | Idiosepius paradoxus | 294707 | Mollusca | Mollusca | 54.7 | 0.027 | NTclustered | gi|325504932|dbj|AB586703.1| | 294707 | g8886 | i0 | 100 | 0.030623020063358 | 29 | 0 | 3 | 0 | 919 | 947 | 39 | 11 | Idiosepius paradoxus cenG mRNA for centaurin gamma homolog, complete cds | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Idiosepiidae | Idiosepius | Idiosepius paradoxus | ||
| 22103484 | 22103484 | PRJNA429937_P_NODE_53758_length_479_cov_9.866667_g35539_i0 | PRJNA429937 | 53758 | 479 | 9.866667 | 47.26133493 | Mya arenaria | 6604 | Mollusca | Mollusca | 58.4 | 0.001 | NTclustered | gi|2427444258|ref|XM_052913222.1| | 6604 | g35539 | i0 | 97.059 | 0.407098121085595 | 34 | 1 | 7 | 0 | 428 | 461 | 4208 | 4175 | PREDICTED: Mya arenaria speract receptor-like (LOC128209257), transcript variant X2, mRNA | blastn | 195 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 26617413 | 26617413 | PRJNA429937_P_NODE_104221_length_290_cov_2.659004_g81604_i0 | PRJNA429937 | 104221 | 290 | 2.659004 | 7.7111116 | Metazoa | 33208 | Mollusca | Mollusca | 44.7 | 0.0141 | NR | XP_065932416.1 | 29159 | g81604 | i0 | 50 | 2.30689655172414 | 40 | 20 | 41.4 | 0 | 52 | 171 | 1025 | 1064 | XP_065932416.1 uncharacterized protein [Magallana gigas] | diamond | 669 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 27265447 | 27265447 | PRJNA429937_P_NODE_47143_length_518_cov_26.533742_g30543_i0 | PRJNA429937 | 47143 | 518 | 26.533742 | 137.44478356 | Ylistrum balloti | 509963 | Mollusca | Mollusca | 82 | 1.47e-14 | NR | XP_060074341.1 | 509963 | g30543 | i0 | 39.4 | 3.1042471042471 | 127 | 73 | 71.2 | 2 | 32 | 400 | 754 | 880 | XP_060074341.1 uncharacterized protein LOC132554061, partial [Ylistrum balloti] | diamond | 1608 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti | |
| 28023359 | 28023359 | PRJNA429937_P_NODE_27205_length_701_cov_17.903274_g16365_i0 | PRJNA429937 | 27205 | 701 | 17.903274 | 125.50195074 | Ylistrum balloti | 509963 | Mollusca | Mollusca | 62.4 | 3.75e-7 | NR | XP_060074341.1 | 509963 | g16365 | i0 | 30.6 | 1.06134094151213 | 124 | 82 | 51.4 | 1 | 3 | 362 | 757 | 880 | XP_060074341.1 uncharacterized protein LOC132554061, partial [Ylistrum balloti] | diamond | 744 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti | |
| 29759687 | 29759687 | PRJNA429937_P_NODE_46091_length_526_cov_2.106640_g29740_i0 | PRJNA429937 | 46091 | 526 | 2.10664 | 11.0809264 | Mya arenaria | 6604 | Mollusca | Mollusca | 94 | 1.1e-18 | NR | WAR02957.1 | 6604 | g29740 | i0 | 35 | 3.65589353612167 | 160 | 83 | 79.3 | 3 | 105 | 521 | 492 | 651 | WAR02957.1 MCM8-like protein [Mya arenaria] | diamond | 1923 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 30675893 | 30675893 | PRJNA429937_P_NODE_87433_length_342_cov_1.955272_g64874_i0 | PRJNA429937 | 87433 | 342 | 1.955272 | 6.68703024 | Elysia crispata | 231223 | Mollusca | Mollusca | 45.1 | 0.017 | NR | KAK3778281.1 | 231223 | g64874 | i0 | 50 | 1.07017543859649 | 44 | 19 | 38.6 | 1 | 281 | 150 | 325 | 365 | KAK3778281.1 hypothetical protein RRG08_028232, partial [Elysia crispata] | diamond | 366 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 32225566 | 32225566 | PRJNA429937_P_NODE_60078_length_447_cov_2.409091_g40393_i0 | PRJNA429937 | 60078 | 447 | 2.409091 | 10.76863677 | Mya arenaria | 6604 | Mollusca | Mollusca | 91.7 | 2.97e-18 | NR | WAR02957.1 | 6604 | g40393 | i0 | 35.1 | 3.1006711409396 | 154 | 79 | 89.3 | 3 | 404 | 6 | 498 | 651 | WAR02957.1 MCM8-like protein [Mya arenaria] | diamond | 1386 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 32337106 | 32337106 | PRJNA429937_P_NODE_108599_length_278_cov_2.751004_g85978_i0 | PRJNA429937 | 108599 | 278 | 2.751004 | 7.64779112 | Metazoa | 33208 | Mollusca | Mollusca | 51.2 | 6.08e-5 | NR | CAG2216216.1 | 6550 | g85978 | i0 | 38.6 | 12.3992805755396 | 70 | 34 | 65.8 | 1 | 210 | 28 | 1346 | 1415 | CAG2216216.1 unnamed protein product [Mytilus edulis] | diamond | 3447 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis |
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);;