contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA669701" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1912715 | 1912715 | PRJNA669701_P_NODE_97682_length_261_cov_2.750000_g97287_i0 | PRJNA669701 | 97682 | 261 | 2.75 | 7.1775 | Haliotis rubra | 36100 | Mollusca | Mollusca | 63.9 | 1.1e-5 | NTclustered | gi|2194114872|ref|XM_046713492.1| | 36100 | g97287 | i0 | 91.667 | 0.919540229885057 | 48 | 1 | 17 | 2 | 189 | 233 | 569 | 616 | PREDICTED: Haliotis rubra ankyrin repeat and SAM domain-containing protein 1A-like (LOC124277762), transcript variant X3, mRNA | blastn | 240 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 7014338 | 7014338 | PRJNA669701_P_NODE_41746_length_367_cov_2.268707_g41351_i0 | PRJNA669701 | 41746 | 367 | 2.268707 | 8.32615469 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.01 | NTclustered | gi|2912991694|dbj|AP039596.1| | 145626 | g41351 | i0 | 100 | 0.0790190735694823 | 29 | 0 | 8 | 0 | 206 | 234 | 12969307 | 12969279 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 8288392 | 8288392 | PRJNA669701_P_NODE_119987_length_247_cov_1.764368_g119592_i0 | PRJNA669701 | 119987 | 247 | 1.764368 | 4.35798896 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 60.2 | 1.33e-4 | NTclustered | gi|2912989933|dbj|AP039594.1| | 145626 | g119592 | i0 | 89.362 | 1.01214574898785 | 47 | 5 | 19 | 0 | 100 | 146 | 27433284 | 27433330 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, sequence | blastn | 250 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 8817486 | 8817486 | PRJNA669701_P_NODE_54087_length_329_cov_1.203125_g53692_i0 | PRJNA669701 | 54087 | 329 | 1.203125 | 3.95828125 | Metazoa | 33208 | Mollusca | Mollusca | 60.2 | 1.85e-4 | NTclustered | gi|2427243980|ref|XM_052968112.1| | 37653 | g53692 | i0 | 94.872 | 7.69604863221884 | 39 | 0 | 12 | 2 | 89 | 126 | 525 | 488 | PREDICTED: Octopus bimaculoides uncharacterized protein DDB_G0271670-like (LOC128247882), partial mRNA | blastn | 2532 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 9564387 | 9564387 | PRJNA669701_P_NODE_52728_length_332_cov_3.980695_g52333_i0 | PRJNA669701 | 52728 | 332 | 3.980695 | 13.2159074 | Mytilus californianus | 6549 | Mollusca | Mollusca | 52.8 | 0.031 | NTclustered | gi|2334767265|ref|XR_007984232.1| | 6549 | g52333 | i0 | 100 | 0.168674698795181 | 28 | 0 | 8 | 0 | 138 | 165 | 259 | 232 | PREDICTED: Mytilus californianus uncharacterized LOC127706118 (LOC127706118), ncRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 14665476 | 14665476 | PRJNA669701_P_NODE_9592_length_779_cov_16.304533_g9226_i0 | PRJNA669701 | 9592 | 779 | 16.304533 | 127.01231207 | Mya arenaria | 6604 | Mollusca | Mollusca | 128 | 1.26e-24 | NTclustered | gi|2427451754|ref|XM_052935182.1| | 6604 | g9226 | i0 | 73.364 | 5.70089858793325 | 428 | 80 | 52 | 24 | 135 | 539 | 1190 | 774 | PREDICTED: Mya arenaria 60S ribosomal protein L3-like (LOC128225141), mRNA | blastn | 4441 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 16467107 | 16467107 | PRJNA669701_P_NODE_30933_length_422_cov_1.750716_g30538_i0 | PRJNA669701 | 30933 | 422 | 1.750716 | 7.38802152 | Metazoa | 33208 | Mollusca | Mollusca | 780 | 0 | NTclustered | gi|1928112764|gb|MT947788.1| | 6523 | g30538 | i0 | 100 | 99.9668246445498 | 422 | 0 | 100 | 0 | 1 | 422 | 505 | 84 | Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds | blastn | 42186 | 780 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 17214198 | 17214198 | PRJNA669701_P_NODE_75594_length_287_cov_1.799065_g75199_i0 | PRJNA669701 | 75594 | 287 | 1.799065 | 5.16331655 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 339 | 1.82e-88 | NTclustered | gi|2868679011|ref|XM_070324062.1| | 31220 | g75199 | i0 | 88.07 | 0.993031358885017 | 285 | 34 | 99 | 0 | 3 | 287 | 1739 | 2023 | PREDICTED: Littorina saxatilis neuroendocrine convertase 2-like (LOC138952393), mRNA | blastn | 285 | 339 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 18487512 | 18487512 | PRJNA669701_P_NODE_119655_length_247_cov_2.810345_g119260_i0 | PRJNA669701 | 119655 | 247 | 2.810345 | 6.94155215 | Haliotis cracherodii | 6455 | Mollusca | Mollusca | 102 | 2.19e-17 | NTclustered | gi|2911889253|ref|XM_071224811.1| | 6455 | g119260 | i0 | 90.123 | 1.91902834008097 | 81 | 5 | 43 | 3 | 49 | 128 | 476 | 398 | PREDICTED: Haliotis cracherodii uncharacterized protein (LOC139443921), transcript variant X2, mRNA | blastn | 474 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis cracherodii | |
| 19761939 | 19761939 | PRJNA669701_P_NODE_115176_length_249_cov_0.875000_g114781_i0 | PRJNA669701 | 115176 | 249 | 0.875 | 2.17875 | Liolophura japonica | 13599 | Mollusca | Mollusca | 97.1 | 1.03e-15 | NTclustered | gi|2724260488|ref|XM_064756177.1| | 13599 | g114781 | i0 | 84 | 2.94377510040161 | 100 | 16 | 40 | 0 | 1 | 100 | 274 | 373 | PREDICTED: Liolophura japonica dynein light chain 2, cytoplasmic-like (LOC135476230), mRNA | blastn | 733 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 19762953 | 19762953 | PRJNA669701_P_NODE_64036_length_308_cov_1.119149_g63641_i0 | PRJNA669701 | 64036 | 308 | 1.119149 | 3.44697892 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 52.8 | 0.029 | NTclustered | gi|2034282758|ref|XM_041515621.1| | 1735272 | g63641 | i0 | 100 | 0.0909090909090909 | 28 | 0 | 9 | 0 | 17 | 44 | 851 | 878 | PREDICTED: Gigantopelta aegis collagen alpha-1(I) chain-like (LOC121385085), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 20290968 | 20290968 | PRJNA669701_P_NODE_68936_length_297_cov_3.401786_g68541_i0 | PRJNA669701 | 68936 | 297 | 3.401786 | 10.10330442 | Opisthokonta | 33154 | Mollusca | Mollusca | 58.4 | 5.93e-4 | NTclustered | gi|2912998015|dbj|AP039603.1| | 145626 | g68541 | i0 | 92.5 | 0.367003367003367 | 40 | 3 | 13 | 0 | 24 | 63 | 19651353 | 19651314 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 22, sequence | blastn | 109 | 58.4 | 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);;