contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA1195374" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 321341 | 321341 | PRJNA1195374_P_NODE_28041_length_428_cov_2.332394_g27697_i0 | PRJNA1195374 | 28041 | 428 | 2.332394 | 9.98264632 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 54.7 | 0.011 | NTclustered | gi|256014578|gb|AC235814.4| | 6526 | g27697 | i0 | 100 | 0.0677570093457944 | 29 | 0 | 7 | 0 | 247 | 275 | 18661 | 18689 | Biomphalaria glabrata BAC clone BG_BBa-11C17 from chromosome unknown, complete sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 322381 | 322381 | PRJNA1195374_P_NODE_80941_length_244_cov_0.900585_g80597_i0 | PRJNA1195374 | 80941 | 244 | 0.900585 | 2.1974274 | Mya arenaria | 6604 | Mollusca | Mollusca | 60.2 | 1.32e-4 | NTclustered | gi|2427503795|ref|XM_052953323.1| | 6604 | g80597 | i0 | 100 | 0.918032786885246 | 32 | 0 | 13 | 0 | 94 | 125 | 650 | 619 | PREDICTED: Mya arenaria bromo and FHA domain-containing protein DDB_G0267958-like (LOC128237740), mRNA | blastn | 224 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 1596610 | 1596610 | PRJNA1195374_P_NODE_60582_length_278_cov_1.473171_g60238_i0 | PRJNA1195374 | 60582 | 278 | 1.473171 | 4.09541538 | Ostrea edulis | 37623 | Mollusca | Mollusca | 52.8 | 0.026 | NTclustered | gi|2507379685|ref|XM_056161599.1| | 37623 | g60238 | i0 | 100 | 0.100719424460432 | 28 | 0 | 10 | 0 | 184 | 211 | 4343 | 4370 | PREDICTED: Ostrea edulis DNA-directed RNA polymerase I subunit RPA1-like (LOC125669856), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 1596756 | 1596756 | PRJNA1195374_P_NODE_68622_length_257_cov_1.135870_g68278_i0 | PRJNA1195374 | 68622 | 257 | 1.13587 | 2.9191859 | Haliotis asinina | 109174 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2793384703|ref|XM_067803577.1| | 109174 | g68278 | i0 | 100 | 0.116731517509728 | 30 | 0 | 12 | 0 | 34 | 63 | 585 | 614 | PREDICTED: Haliotis asinina lateral signaling target protein 2 homolog (LOC137268951), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 2318177 | 2318177 | PRJNA1195374_P_NODE_53462_length_298_cov_1.782222_g53118_i0 | PRJNA1195374 | 53462 | 298 | 1.782222 | 5.31102156 | Cephalopoda | 6605 | Mollusca | Mollusca | 217 | 9.28e-52 | NTclustered | gi|385145409|emb|HE687192.1| | 6610 | g53118 | i0 | 82.857 | 64.2181208053691 | 245 | 39 | 82 | 1 | 54 | 298 | 1501 | 1260 | Sepia officinalis mRNA for alpha tubulin 3 (gene TUBA3) | blastn | 19137 | 219 | 0.990867579908676 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Sepia | Sepia officinalis | |
| 2872149 | 2872149 | PRJNA1195374_P_NODE_28503_length_425_cov_1.019886_g28159_i0 | PRJNA1195374 | 28503 | 425 | 1.019886 | 4.3345155 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 63.9 | 1.89e-5 | NTclustered | gi|2912994531|dbj|AP039599.1| | 145626 | g28159 | i0 | 91.489 | 1.04470588235294 | 47 | 3 | 11 | 1 | 243 | 289 | 15228883 | 15228928 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 18, sequence | blastn | 444 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 2872384 | 2872384 | PRJNA1195374_P_NODE_39363_length_356_cov_1.512367_g39019_i0 | PRJNA1195374 | 39363 | 356 | 1.512367 | 5.38402652 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.034 | NTclustered | gi|2912992646|dbj|AP039597.1| | 145626 | g39019 | i0 | 100 | 0.0786516853932584 | 28 | 0 | 8 | 0 | 158 | 185 | 19361915 | 19361942 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 2872470 | 2872470 | PRJNA1195374_P_NODE_44083_length_334_cov_1.482759_g43739_i0 | PRJNA1195374 | 44083 | 334 | 1.482759 | 4.95241506 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 54.7 | 0.009 | NTclustered | gi|2868616210|ref|XM_070343508.1| | 31220 | g43739 | i0 | 96.97 | 0.0988023952095808 | 33 | 0 | 10 | 1 | 295 | 327 | 1590 | 1559 | PREDICTED: Littorina saxatilis microfibrillar-associated protein 1-like (LOC138970926), mRNA | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 6699096 | 6699096 | PRJNA1195374_P_NODE_23046_length_473_cov_1.797500_g22702_i0 | PRJNA1195374 | 23046 | 473 | 1.7975 | 8.502175 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.013 | NTclustered | gi|2912984370|dbj|AP039589.1| | 145626 | g22702 | i0 | 100 | 0.0613107822410148 | 29 | 0 | 6 | 0 | 434 | 462 | 69661608 | 69661580 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 8, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 6699121 | 6699121 | PRJNA1195374_P_NODE_24206_length_461_cov_3.144330_g23862_i0 | PRJNA1195374 | 24206 | 461 | 3.14433 | 14.4953613 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 60.2 | 2.67e-4 | NTclustered | gi|2912992646|dbj|AP039597.1| | 145626 | g23862 | i0 | 94.737 | 0.0824295010845987 | 38 | 2 | 8 | 0 | 4 | 41 | 49670500 | 49670537 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence | blastn | 38 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 6699633 | 6699633 | PRJNA1195374_P_NODE_50206_length_310_cov_1.400844_g49862_i0 | PRJNA1195374 | 50206 | 310 | 1.400844 | 4.3426164 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 158 | 5.97e-34 | NTclustered | gi|2034324202|ref|XM_041504055.1| | 1735272 | g49862 | i0 | 83.721 | 7.80645161290323 | 172 | 22 | 55 | 6 | 142 | 310 | 579 | 411 | PREDICTED: Gigantopelta aegis caltractin (LOC121376238), mRNA | blastn | 2420 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 6700203 | 6700203 | PRJNA1195374_P_NODE_78706_length_246_cov_0.867052_g78362_i0 | PRJNA1195374 | 78706 | 246 | 0.867052 | 2.13294792 | Pecten maximus | 6579 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|1835525666|ref|XM_033895770.1| | 6579 | g78362 | i0 | 100 | 0.707317073170732 | 29 | 0 | 12 | 0 | 69 | 97 | 4167 | 4139 | PREDICTED: Pecten maximus uncharacterized LOC117335636 (LOC117335636), transcript variant X3, mRNA | blastn | 174 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 8695958 | 8695958 | PRJNA1195374_P_NODE_78507_length_246_cov_0.890173_g78163_i0 | PRJNA1195374 | 78507 | 246 | 0.890173 | 2.18982558 | Opisthokonta | 33154 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2868608971|ref|XM_070340615.1| | 31220 | g78163 | i0 | 100 | 0.796747967479675 | 28 | 0 | 11 | 0 | 213 | 240 | 1436 | 1409 | PREDICTED: Littorina saxatilis putative per-hexamer repeat protein 5 (LOC138968043), transcript variant X2, mRNA | blastn | 196 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 9250092 | 9250092 | PRJNA1195374_P_NODE_72128_length_250_cov_1.276836_g71784_i0 | PRJNA1195374 | 72128 | 250 | 1.276836 | 3.19209 | Argopecten irradians | 31199 | Mollusca | Mollusca | 154 | 6.03e-33 | NTclustered | gi|2835340598|ref|XM_069284179.1| | 31199 | g71784 | i0 | 80.097 | 10.672 | 206 | 41 | 82 | 0 | 45 | 250 | 1091 | 1296 | PREDICTED: Argopecten irradians F-box/WD repeat-containing protein 1A-like (LOC138335197), transcript variant X1, mRNA | blastn | 2668 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 10525247 | 10525247 | PRJNA1195374_P_NODE_37649_length_365_cov_2.664384_g37305_i0 | PRJNA1195374 | 37649 | 365 | 2.664384 | 9.7250016 | Haliotis rubra | 36100 | Mollusca | Mollusca | 110 | 2.03e-19 | NTclustered | gi|2194155548|ref|XM_046690371.1| | 36100 | g37305 | i0 | 83.2 | 3.1041095890411 | 125 | 16 | 33 | 4 | 231 | 352 | 735 | 613 | PREDICTED: Haliotis rubra 60S ribosomal protein L10a-like (LOC124256367), mRNA | blastn | 1133 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 13074650 | 13074650 | PRJNA1195374_P_NODE_14711_length_588_cov_2.345631_g14372_i0 | PRJNA1195374 | 14711 | 588 | 2.345631 | 13.79231028 | Lottia gigantea | 225164 | Mollusca | Mollusca | 113 | 2.63e-20 | NTclustered | gi|676461887|ref|XM_009057841.1| | 225164 | g14372 | i0 | 80.255 | 3.01360544217687 | 157 | 26 | 27 | 4 | 364 | 519 | 1791 | 1639 | Lottia gigantea hypothetical protein mRNA | blastn | 1772 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 13796058 | 13796058 | PRJNA1195374_P_NODE_40831_length_349_cov_1.144928_g40487_i0 | PRJNA1195374 | 40831 | 349 | 1.144928 | 3.99579872 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 58.4 | 7.08e-4 | NTclustered | gi|2751317800|ref|XM_034476922.2| | 29159 | g40487 | i0 | 97.059 | 3.38395415472779 | 34 | 1 | 10 | 0 | 227 | 260 | 3620 | 3587 | PREDICTED: Magallana gigas tyrosine-protein phosphatase 10D (LOC105319642), transcript variant X1, mRNA | blastn | 1181 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 14350833 | 14350833 | PRJNA1195374_P_NODE_50092_length_311_cov_0.920168_g49748_i0 | PRJNA1195374 | 50092 | 311 | 0.920168 | 2.86172248 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 200 | 9.81e-47 | NTclustered | gi|2502109311|ref|XM_013241081.2| | 6526 | g49748 | i0 | 88.889 | 44.427652733119 | 162 | 18 | 52 | 0 | 126 | 287 | 302 | 141 | PREDICTED: Biomphalaria glabrata 60S ribosomal protein L27a-like (LOC106079852), mRNA | blastn | 13817 | 200 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 15625256 | 15625256 | PRJNA1195374_P_NODE_85733_length_235_cov_2.296296_g85389_i0 | PRJNA1195374 | 85733 | 235 | 2.296296 | 5.3962956 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 52.8 | 0.021 | NTclustered | gi|2034332913|ref|XM_041508635.1| | 1735272 | g85389 | i0 | 100 | 0.476595744680851 | 28 | 0 | 12 | 0 | 131 | 158 | 4302 | 4329 | PREDICTED: Gigantopelta aegis uncharacterized LOC121379942 (LOC121379942), transcript variant X4, mRNA | blastn | 112 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 16899376 | 16899376 | PRJNA1195374_P_NODE_75734_length_248_cov_0.880000_g75390_i0 | PRJNA1195374 | 75734 | 248 | 0.88 | 2.1824 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 67.6 | 8.01e-7 | NTclustered | gi|2912987826|dbj|AP039592.1| | 145626 | g75390 | i0 | 93.478 | 0.370967741935484 | 46 | 2 | 18 | 1 | 73 | 117 | 52915180 | 52915135 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence | blastn | 92 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 17620409 | 17620409 | PRJNA1195374_P_NODE_29374_length_418_cov_1.504348_g29030_i0 | PRJNA1195374 | 29374 | 418 | 1.504348 | 6.28817464 | Metazoa | 33208 | Mollusca | Mollusca | 773 | 0 | NTclustered | gi|1928112764|gb|MT947788.1| | 6523 | g29030 | i0 | 100 | 99.9952153110048 | 418 | 0 | 100 | 0 | 1 | 418 | 900 | 1317 | Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds | blastn | 41798 | 773 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 24547200 | 24547200 | PRJNA1195374_P_NODE_18140_length_532_cov_1.346405_g17797_i0 | PRJNA1195374 | 18140 | 532 | 1.346405 | 7.1628746 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 65.8 | 6.71e-6 | NTclustered | gi|2912996298|dbj|AP039601.1| | 145626 | g17797 | i0 | 93.333 | 0.0845864661654135 | 45 | 1 | 8 | 2 | 329 | 372 | 50663405 | 50663448 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 20, sequence | blastn | 45 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 24548239 | 24548239 | PRJNA1195374_P_NODE_67820_length_259_cov_1.241935_g67476_i0 | PRJNA1195374 | 67820 | 259 | 1.241935 | 3.21661165 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.024 | NTclustered | gi|2912981848|dbj|AP039587.1| | 145626 | g67476 | i0 | 100 | 0.108108108108108 | 28 | 0 | 11 | 0 | 55 | 82 | 57494452 | 57494479 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 25268896 | 25268896 | PRJNA1195374_P_NODE_39800_length_354_cov_1.370107_g39456_i0 | PRJNA1195374 | 39800 | 354 | 1.370107 | 4.85017878 | Metazoa | 33208 | Mollusca | Mollusca | 654 | 0 | NTclustered | gi|1928112764|gb|MT947788.1| | 6523 | g39456 | i0 | 100 | 99.9915254237288 | 354 | 0 | 100 | 0 | 1 | 354 | 465 | 112 | Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds | blastn | 35397 | 654 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis |
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);;