contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA971676" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3495333 | 3495333 | PRJNA971676_P_NODE_20883_length_244_cov_0.900585_g20794_i0 | PRJNA971676 | 20883 | 244 | 0.900585 | 2.1974274 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 124 | 4.599999999999999e-24 | NTclustered | gi|2616475732|ref|XM_060701816.1| | 129788 | g20794 | i0 | 93.976 | 1.82377049180328 | 83 | 4 | 34 | 1 | 110 | 192 | 3896 | 3977 | PREDICTED: Ruditapes philippinarum extended synaptotagmin-1-like (LOC132718183), mRNA | blastn | 445 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 4773015 | 4773015 | PRJNA971676_P_NODE_21464_length_243_cov_0.905882_g21375_i0 | PRJNA971676 | 21464 | 243 | 0.905882 | 2.20129326 | Mytilus trossulus | 6551 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2693974884|ref|XM_063591476.1| | 6551 | g21375 | i0 | 100 | 0.11522633744856 | 28 | 0 | 12 | 0 | 127 | 154 | 319 | 292 | PREDICTED: Mytilus trossulus baculoviral IAP repeat-containing protein 3-like (LOC134727084), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 9872823 | 9872823 | PRJNA971676_P_NODE_18808_length_246_cov_0.890173_g18719_i0 | PRJNA971676 | 18808 | 246 | 0.890173 | 2.18982558 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 145 | 3.56e-30 | NTclustered | gi|2616555325|ref|XM_060714013.1| | 129788 | g18719 | i0 | 89.916 | 1.55691056910569 | 119 | 2 | 48 | 2 | 22 | 140 | 280 | 388 | PREDICTED: Ruditapes philippinarum uncharacterized LOC132728358 (LOC132728358), transcript variant X3, mRNA | blastn | 383 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 11148110 | 11148110 | PRJNA971676_P_NODE_11809_length_269_cov_1.571429_g11720_i0 | PRJNA971676 | 11809 | 269 | 1.571429 | 4.22714401 | Dosinia biscocta | 870213 | Mollusca | Mollusca | 182 | 3.01e-41 | NTclustered | gi|306022063|gb|HM124625.1| | 870213 | g11720 | i0 | 84.324 | 59.1710037174721 | 185 | 29 | 69 | 0 | 2 | 186 | 185 | 1 | Dosinia biscocta isolate BGJ0323 histone 3 (H3) gene, partial cds | blastn | 15917 | 182 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Dosinia | Dosinia biscocta | |
| 11148329 | 11148329 | PRJNA971676_P_NODE_23669_length_241_cov_0.904762_g23580_i0 | PRJNA971676 | 23669 | 241 | 0.904762 | 2.18047642 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 158 | 4.47e-34 | NTclustered | gi|2616488518|ref|XM_060717555.1| | 129788 | g23580 | i0 | 94.231 | 1.72614107883817 | 104 | 4 | 42 | 1 | 140 | 241 | 2080 | 2183 | PREDICTED: Ruditapes philippinarum cullin-3-like (LOC132731378), transcript variant X1, mRNA | blastn | 416 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 12423852 | 12423852 | PRJNA971676_P_NODE_21170_length_243_cov_0.905882_g21081_i0 | PRJNA971676 | 21170 | 243 | 0.905882 | 2.20129326 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 137 | 5.88e-28 | NTclustered | gi|2616460458|ref|XM_060735367.1| | 129788 | g21081 | i0 | 97.5 | 0.329218106995885 | 80 | 2 | 33 | 0 | 161 | 240 | 9441 | 9520 | PREDICTED: Ruditapes philippinarum uncharacterized LOC132746264 (LOC132746264), mRNA | blastn | 80 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 14972594 | 14972594 | PRJNA971676_P_NODE_21612_length_243_cov_0.905882_g21523_i0 | PRJNA971676 | 21612 | 243 | 0.905882 | 2.20129326 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 122 | 1.6499999999999995e-23 | NTclustered | gi|2616675104|ref|XM_060698123.1| | 129788 | g21523 | i0 | 100 | 0.54320987654321 | 66 | 0 | 27 | 0 | 178 | 243 | 1178 | 1113 | PREDICTED: Ruditapes philippinarum uncharacterized LOC132715149 (LOC132715149), transcript variant X1, mRNA | blastn | 132 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 14972622 | 14972622 | PRJNA971676_P_NODE_23172_length_241_cov_0.916667_g23083_i0 | PRJNA971676 | 23172 | 241 | 0.916667 | 2.20916747 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 121 | 5.86e-23 | NTclustered | gi|2616462782|ref|XM_060747685.1| | 129788 | g23083 | i0 | 100 | 1.05394190871369 | 65 | 0 | 27 | 0 | 1 | 65 | 521 | 457 | PREDICTED: Ruditapes philippinarum invertebrate-type lysozyme-like (LOC132756576), mRNA | blastn | 254 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 16247549 | 16247549 | PRJNA971676_P_NODE_22953_length_241_cov_0.916667_g22864_i0 | PRJNA971676 | 22953 | 241 | 0.916667 | 2.20916747 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 89.8 | 1.65e-13 | NTclustered | gi|2616548057|ref|XM_060712033.1| | 129788 | g22864 | i0 | 92.188 | 0.663900414937759 | 64 | 4 | 26 | 1 | 177 | 239 | 1849 | 1786 | PREDICTED: Ruditapes philippinarum conserved oligomeric Golgi complex subunit 7-like (LOC132726685), transcript variant X2, mRNA | blastn | 160 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 17522611 | 17522611 | PRJNA971676_P_NODE_14014_length_251_cov_0.865169_g13925_i0 | PRJNA971676 | 14014 | 251 | 0.865169 | 2.17157419 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.023 | NTclustered | gi|2913001816|dbj|AP039609.1| | 145626 | g13925 | i0 | 100 | 0.111553784860558 | 28 | 0 | 11 | 0 | 9 | 36 | 15002461 | 15002434 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 28, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 18796353 | 18796353 | PRJNA971676_P_NODE_15195_length_250_cov_0.870056_g15106_i0 | PRJNA971676 | 15195 | 250 | 0.870056 | 2.17514 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 228 | 3.4999999999999995e-55 | NTclustered | gi|2616541827|ref|XM_060710352.1| | 129788 | g15106 | i0 | 97.727 | 3.152 | 132 | 3 | 53 | 0 | 119 | 250 | 2898 | 2767 | PREDICTED: Ruditapes philippinarum heat shock 70 kDa protein 12A-like (LOC132725256), mRNA | blastn | 788 | 228 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 21346667 | 21346667 | PRJNA971676_P_NODE_17117_length_248_cov_0.880000_g17028_i0 | PRJNA971676 | 17117 | 248 | 0.88 | 2.1824 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 209 | 1.26e-49 | NTclustered | gi|2616669690|ref|XM_060695261.1| | 129788 | g17028 | i0 | 96.124 | 2.13306451612903 | 129 | 4 | 52 | 1 | 120 | 248 | 1951 | 1824 | PREDICTED: Ruditapes philippinarum uncharacterized LOC132712826 (LOC132712826), mRNA | blastn | 529 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 21346746 | 21346746 | PRJNA971676_P_NODE_21877_length_243_cov_0.876471_g21788_i0 | PRJNA971676 | 21877 | 243 | 0.876471 | 2.12982453 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 435 | 1.86e-117 | NTclustered | gi|2616507090|ref|XM_060706185.1| | 129788 | g21788 | i0 | 99.17 | 200.592592592593 | 241 | 2 | 99 | 0 | 1 | 241 | 7641 | 7881 | PREDICTED: Ruditapes philippinarum uncharacterized LOC132721814 (LOC132721814), mRNA | blastn | 48744 | 435 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 22621665 | 22621665 | PRJNA971676_P_NODE_13818_length_251_cov_0.865169_g13729_i0 | PRJNA971676 | 13818 | 251 | 0.865169 | 2.17157419 | Mya arenaria | 6604 | Mollusca | Mollusca | 196 | 9.93e-46 | NTclustered | gi|2427495697|ref|XM_052950564.1| | 6604 | g13729 | i0 | 94.574 | 0.51394422310757 | 129 | 3 | 51 | 2 | 3 | 131 | 166 | 290 | PREDICTED: Mya arenaria uncharacterized LOC128235767 (LOC128235767), mRNA | blastn | 129 | 196 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 22621724 | 22621724 | PRJNA971676_P_NODE_16718_length_248_cov_0.880000_g16629_i0 | PRJNA971676 | 16718 | 248 | 0.88 | 2.1824 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 174 | 4.59e-39 | NTclustered | gi|2616639462|ref|XR_009628331.1| | 129788 | g16629 | i0 | 97.115 | 23.0483870967742 | 104 | 2 | 42 | 1 | 1 | 103 | 1959 | 2062 | PREDICTED: Ruditapes philippinarum uncharacterized LOC132748884 (LOC132748884), ncRNA | blastn | 5716 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 22621809 | 22621809 | PRJNA971676_P_NODE_22118_length_242_cov_0.911243_g22029_i0 | PRJNA971676 | 22118 | 242 | 0.911243 | 2.20520806 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 135 | 2.1e-27 | NTclustered | gi|2616642807|ref|XM_060740302.1| | 129788 | g22029 | i0 | 100 | 0.90495867768595 | 73 | 0 | 30 | 0 | 31 | 103 | 675 | 747 | PREDICTED: Ruditapes philippinarum interferon-induced protein 44-like (LOC132750342), mRNA | blastn | 219 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 23897055 | 23897055 | PRJNA971676_P_NODE_15899_length_249_cov_0.875000_g15810_i0 | PRJNA971676 | 15899 | 249 | 0.875 | 2.17875 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 195 | 3.5399999999999996e-45 | NTclustered | gi|2616600654|ref|XR_009626988.1| | 129788 | g15810 | i0 | 99.074 | 62.9518072289157 | 108 | 1 | 43 | 0 | 106 | 213 | 1244 | 1137 | PREDICTED: Ruditapes philippinarum uncharacterized LOC132739363 (LOC132739363), ncRNA | blastn | 15675 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum |
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);;