contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA700095" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 683188 | 683188 | PRJNA700095_P_NODE_29261_length_314_cov_2.058091_g27997_i0 | PRJNA700095 | 29261 | 314 | 2.058091 | 6.46240574 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.029 | NTclustered | gi|2912996298|dbj|AP039601.1| | 145626 | g27997 | i0 | 100 | 0.089171974522293 | 28 | 0 | 9 | 0 | 218 | 245 | 15301092 | 15301065 | 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 | |
| 8336366 | 8336366 | PRJNA700095_P_NODE_35107_length_289_cov_1.152778_g33843_i0 | PRJNA700095 | 35107 | 289 | 1.152778 | 3.33152842 | Doryteuthis pealeii | 1051067 | Mollusca | Mollusca | 202 | 2.51e-47 | NTclustered | gi|1884643889|gb|MT648678.1| | 1051067 | g33843 | i0 | 87.931 | 0.84083044982699 | 174 | 17 | 60 | 4 | 118 | 289 | 126210 | 126381 | Doryteuthis pealeii tryptophan 2,3 dioxygenase (TDO) gene, complete cds | blastn | 243 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Myopsida | Loliginidae | Doryteuthis | Doryteuthis pealeii | |
| 9611711 | 9611711 | PRJNA700095_P_NODE_42708_length_269_cov_1.556122_g41444_i0 | PRJNA700095 | 42708 | 269 | 1.556122 | 4.18596818 | Argopecten irradians | 31199 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|2835376721|ref|XM_069262798.1| | 31199 | g41444 | i0 | 92.105 | 0.141263940520446 | 38 | 3 | 14 | 0 | 123 | 160 | 989 | 952 | PREDICTED: Argopecten irradians dentin sialophosphoprotein-like (LOC138319649), mRNA | blastn | 38 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 13436850 | 13436850 | PRJNA700095_P_NODE_12511_length_538_cov_6.617204_g11260_i0 | PRJNA700095 | 12511 | 538 | 6.617204 | 35.60055752 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 315 | 6.11e-81 | NTclustered | gi|2442058763|ref|XM_045347307.2| | 6596 | g11260 | i0 | 79.634 | 74.457249070632 | 437 | 89 | 81 | 0 | 16 | 452 | 635 | 199 | PREDICTED: Mercenaria mercenaria uncharacterized LOC123556531 (LOC123556531), mRNA | blastn | 40058 | 315 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 15985814 | 15985814 | PRJNA700095_P_NODE_37193_length_283_cov_1.452381_g35929_i0 | PRJNA700095 | 37193 | 283 | 1.452381 | 4.11023823 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|1242844968|ref|XM_022448100.1| | 6565 | g35929 | i0 | 94.595 | 0.392226148409894 | 37 | 1 | 13 | 1 | 33 | 69 | 1419 | 1384 | PREDICTED: Crassostrea virginica synaptosomal-associated protein 47-like (LOC111111243), transcript variant X1, mRNA | blastn | 111 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 17762042 | 17762042 | PRJNA700095_P_NODE_47994_length_257_cov_2.657609_g46730_i0 | PRJNA700095 | 47994 | 257 | 2.657609 | 6.83005513 | Haliotis | 6452 | Mollusca | Mollusca | 52.8 | 0.023 | NTclustered | gi|2245727990|ref|XM_048390035.1| | 6454 | g46730 | i0 | 100 | 9.91439688715953 | 28 | 0 | 11 | 0 | 220 | 247 | 26011 | 25984 | PREDICTED: Haliotis rufescens titin-like (LOC124137436), transcript variant X11, mRNA | blastn | 2548 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 18535081 | 18535081 | PRJNA700095_P_NODE_49775_length_254_cov_0.988950_g48511_i0 | PRJNA700095 | 49775 | 254 | 0.98895 | 2.511933 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2912998575|dbj|AP039604.1| | 145626 | g48511 | i0 | 100 | 0.118110236220472 | 30 | 0 | 12 | 0 | 176 | 205 | 16630422 | 16630451 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 23, sequence | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 21085518 | 21085518 | PRJNA700095_P_NODE_21337_length_380_cov_1.003257_g20073_i0 | PRJNA700095 | 21337 | 380 | 1.003257 | 3.8123766 | Pecten maximus | 6579 | Mollusca | Mollusca | 65.8 | 4.65e-6 | NTclustered | gi|1835485072|ref|XM_033899972.1| | 6579 | g20073 | i0 | 90.385 | 2.13947368421053 | 52 | 1 | 13 | 3 | 166 | 214 | 516 | 566 | PREDICTED: Pecten maximus coiled-coil domain-containing protein 1-like (LOC117338614), mRNA | blastn | 813 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 21085719 | 21085719 | PRJNA700095_P_NODE_60717_length_244_cov_0.900585_g59453_i0 | PRJNA700095 | 60717 | 244 | 0.900585 | 2.1974274 | Mytilus edulis | 6550 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2912383285|ref|XM_071304020.1| | 6550 | g59453 | i0 | 96.875 | 0.131147540983607 | 32 | 0 | 13 | 1 | 53 | 83 | 1601 | 1570 | PREDICTED: Mytilus edulis cytosolic phospholipase A2-like (LOC139514604), mRNA | blastn | 32 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 21586456 | 21586456 | PRJNA700095_P_NODE_36457_length_285_cov_1.419811_g35193_i0 | PRJNA700095 | 36457 | 285 | 1.419811 | 4.04646135 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.8 | 0.026 | NTclustered | gi|2912981848|dbj|AP039587.1| | 145626 | g35193 | i0 | 100 | 0.294736842105263 | 28 | 0 | 10 | 0 | 122 | 149 | 37686465 | 37686438 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 22861649 | 22861649 | PRJNA700095_P_NODE_17118_length_437_cov_2.997253_g15855_i0 | PRJNA700095 | 17118 | 437 | 2.997253 | 13.09799561 | Mollusca | 6447 | Mollusca | Mollusca | 52.8 | 0.042 | NTclustered | gi|1897923866|ref|XM_005098055.3| | 6500 | g15855 | i0 | 100 | 0.128146453089245 | 28 | 0 | 6 | 0 | 227 | 254 | 456 | 483 | PREDICTED: Aplysia californica alpha- and gamma-adaptin-binding protein p34 (LOC101849691), mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 24135888 | 24135888 | PRJNA700095_P_NODE_21899_length_373_cov_2.556667_g20635_i0 | PRJNA700095 | 21899 | 373 | 2.556667 | 9.53636791 | Gemmula | 394107 | Mollusca | Mollusca | 54.7 | 0.01 | NTclustered | gi|211838488|gb|EU820736.1| | 571837 | g20635 | i0 | 100 | 0.85254691689008 | 29 | 0 | 8 | 0 | 296 | 324 | 268 | 296 | Gemmula sp. 06 NP-2008 voucher 40940 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 318 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neogastropoda | Turridae | Gemmula | Gemmula sp. 06 NP-2008 |
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);;