contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA453567" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1716807 | 1716807 | PRJNA453567_P_NODE_8662_length_327_cov_1.696552_g8425_i0 | PRJNA453567 | 8662 | 327 | 1.696552 | 5.54772504 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2912987826|dbj|AP039592.1| | 145626 | g8425 | i0 | 97.059 | 0.103975535168196 | 34 | 0 | 10 | 1 | 81 | 113 | 10695165 | 10695198 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence | blastn | 34 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 2368824 | 2368824 | PRJNA453567_P_NODE_8042_length_344_cov_1.938111_g7805_i0 | PRJNA453567 | 8042 | 344 | 1.938111 | 6.66710184 | Metazoa | 33208 | Mollusca | Mollusca | 54.7 | 0.009 | NTclustered | gi|2912989933|dbj|AP039594.1| | 145626 | g7805 | i0 | 96.875 | 0.186046511627907 | 32 | 1 | 9 | 0 | 91 | 122 | 26792261 | 26792292 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, sequence | blastn | 64 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 4268863 | 4268863 | PRJNA453567_P_NODE_18364_length_207_cov_2.547059_g18127_i0 | PRJNA453567 | 18364 | 207 | 2.547059 | 5.27241213 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.005 | NTclustered | gi|2912984370|dbj|AP039589.1| | 145626 | g18127 | i0 | 100 | 0.816425120772947 | 29 | 0 | 14 | 0 | 169 | 197 | 55333058 | 55333086 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 8, sequence | blastn | 169 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 4268989 | 4268989 | PRJNA453567_P_NODE_8304_length_336_cov_4.103679_g8067_i0 | PRJNA453567 | 8304 | 336 | 4.103679 | 13.78836144 | Lottia gigantea | 225164 | Mollusca | Mollusca | 207 | 6.39e-49 | NTclustered | gi|676476808|ref|XM_009062665.1| | 225164 | g8067 | i0 | 83.186 | 60.2886904761905 | 226 | 38 | 67 | 0 | 111 | 336 | 1368 | 1143 | Lottia gigantea hypothetical protein partial mRNA | blastn | 20257 | 207 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 6819461 | 6819461 | PRJNA453567_P_NODE_15126_length_232_cov_1.923077_g14889_i0 | PRJNA453567 | 15126 | 232 | 1.923077 | 4.46153864 | Bathyspinula hilleri | 1069099 | Mollusca | Mollusca | 307 | 4.0100000000000005e-79 | NTclustered | gi|343952719|gb|JF410975.1| | 1069099 | g14889 | i0 | 90.517 | 99.6379310344828 | 232 | 22 | 100 | 0 | 1 | 232 | 391 | 160 | Bathyspinula hilleri beta tubulin (BTUB) gene, partial cds | blastn | 23116 | 307 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Nuculanida sp. | Bathyspinulidae | Bathyspinula | Bathyspinula hilleri | |
| 6819600 | 6819600 | PRJNA453567_P_NODE_4286_length_510_cov_2.319239_g4053_i0 | PRJNA453567 | 4286 | 510 | 2.319239 | 11.8281189 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 0.001 | NTclustered | gi|2912990805|dbj|AP039595.1| | 145626 | g4053 | i0 | 100 | 0.0607843137254902 | 31 | 0 | 6 | 0 | 392 | 422 | 61821283 | 61821253 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 8095058 | 8095058 | PRJNA453567_P_NODE_8967_length_320_cov_1.501767_g8730_i0 | PRJNA453567 | 8967 | 320 | 1.501767 | 4.8056544 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 58.4 | 6.45e-4 | NTclustered | gi|2034332010|ref|XM_041508131.1| | 1735272 | g8730 | i0 | 100 | 1.10625 | 31 | 0 | 10 | 0 | 201 | 231 | 3165 | 3135 | PREDICTED: Gigantopelta aegis cadherin-23-like (LOC121379486), mRNA | blastn | 354 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 10645820 | 10645820 | PRJNA453567_P_NODE_9969_length_299_cov_2.263359_g9732_i0 | PRJNA453567 | 9969 | 299 | 2.263359 | 6.76744341 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.028 | NTclustered | gi|2912998575|dbj|AP039604.1| | 145626 | g9732 | i0 | 100 | 0.280936454849498 | 28 | 0 | 9 | 0 | 144 | 171 | 11012767 | 11012740 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 23, sequence | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 11920595 | 11920595 | PRJNA453567_P_NODE_16730_length_219_cov_1.439560_g16493_i0 | PRJNA453567 | 16730 | 219 | 1.43956 | 3.1526364 | Haliotis rubra | 36100 | Mollusca | Mollusca | 52.8 | 0.019 | NTclustered | gi|2194177079|ref|XM_046700483.1| | 36100 | g16493 | i0 | 100 | 0.127853881278539 | 28 | 0 | 13 | 0 | 113 | 140 | 1426 | 1399 | PREDICTED: Haliotis rubra peroxidase-like protein (LOC124265683), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 11920620 | 11920620 | PRJNA453567_P_NODE_21890_length_188_cov_1.291391_g21653_i0 | PRJNA453567 | 21890 | 188 | 1.291391 | 2.42781508 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 3.46e-4 | NTclustered | gi|2912988862|dbj|AP039593.1| | 145626 | g21653 | i0 | 97.143 | 2.29255319148936 | 35 | 0 | 18 | 1 | 6 | 39 | 57836967 | 57836933 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence | blastn | 431 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 12572231 | 12572231 | PRJNA453567_P_NODE_16450_length_221_cov_1.695652_g16213_i0 | PRJNA453567 | 16450 | 221 | 1.695652 | 3.74739092 | Opisthokonta | 33154 | Mollusca | Mollusca | 52.8 | 0.02 | NTclustered | gi|2868608971|ref|XM_070340615.1| | 31220 | g16213 | i0 | 100 | 0.886877828054299 | 28 | 0 | 13 | 0 | 82 | 109 | 1409 | 1436 | 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 | |
| 14470554 | 14470554 | PRJNA453567_P_NODE_34272_length_150_cov_1.026549_g34035_i0 | PRJNA453567 | 34272 | 150 | 1.026549 | 1.5398235 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 52.8 | 0.012 | NTclustered | gi|1397684868|ref|XM_025236088.1| | 400727 | g34035 | i0 | 100 | 0.186666666666667 | 28 | 0 | 19 | 0 | 3 | 30 | 1049 | 1076 | PREDICTED: Pomacea canaliculata uncharacterized LOC112562686 (LOC112562686), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 15121248 | 15121248 | PRJNA453567_P_NODE_8772_length_324_cov_1.961672_g8535_i0 | PRJNA453567 | 8772 | 324 | 1.961672 | 6.35581728 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2913001038|dbj|AP039608.1| | 145626 | g8535 | i0 | 90.698 | 0.638888888888889 | 43 | 3 | 13 | 1 | 247 | 288 | 6002403 | 6002361 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 27, sequence | blastn | 207 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 18293456 | 18293456 | PRJNA453567_P_NODE_20375_length_196_cov_1.226415_g20138_i0 | PRJNA453567 | 20375 | 196 | 1.226415 | 2.4037734 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 52.8 | 0.017 | NTclustered | gi|2034290918|ref|XM_041519906.1| | 1735272 | g20138 | i0 | 96.774 | 0.316326530612245 | 31 | 1 | 16 | 0 | 164 | 194 | 695 | 725 | PREDICTED: Gigantopelta aegis lysophosphatidylcholine acyltransferase 2-like (LOC121388534), transcript variant X1, mRNA | blastn | 62 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 18293478 | 18293478 | PRJNA453567_P_NODE_22995_length_183_cov_1.856164_g22758_i0 | PRJNA453567 | 22995 | 183 | 1.856164 | 3.39678012 | Liolophura japonica | 13599 | Mollusca | Mollusca | 110 | 9.12e-20 | NTclustered | gi|2724248345|ref|XM_064749720.1| | 13599 | g22758 | i0 | 81.618 | 6.21311475409836 | 136 | 21 | 73 | 3 | 49 | 182 | 684 | 551 | PREDICTED: Liolophura japonica elongator complex protein 3-like (LOC135470685), mRNA | blastn | 1137 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 21495251 | 21495251 | PRJNA453567_P_NODE_8177_length_340_cov_2.468647_g7940_i0 | PRJNA453567 | 8177 | 340 | 2.468647 | 8.3933998 | Metazoa | 33208 | Mollusca | Mollusca | 52.8 | 0.032 | NTclustered | gi|2912998015|dbj|AP039603.1| | 145626 | g7940 | i0 | 100 | 0.164705882352941 | 28 | 0 | 8 | 0 | 99 | 126 | 12156235 | 12156262 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 22, sequence | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 22770379 | 22770379 | PRJNA453567_P_NODE_5578_length_430_cov_1.582697_g5342_i0 | PRJNA453567 | 5578 | 430 | 1.582697 | 6.8055971 | Metazoa | 33208 | Mollusca | Mollusca | 56.5 | 0.003 | NTclustered | gi|2912993551|dbj|AP039598.1| | 145626 | g5342 | i0 | 96.97 | 0.21860465116279101 | 33 | 1 | 8 | 0 | 309 | 341 | 57769356 | 57769324 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 17, sequence | blastn | 94 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 25319652 | 25319652 | PRJNA453567_P_NODE_7820_length_350_cov_1.367412_g7583_i0 | PRJNA453567 | 7820 | 350 | 1.367412 | 4.785942 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|2912992646|dbj|AP039597.1| | 145626 | g7583 | i0 | 96.97 | 2.19142857142857 | 33 | 1 | 9 | 0 | 68 | 100 | 14840033 | 14840065 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence | blastn | 767 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris |
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);;