contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA473201" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 444738 | 444738 | PRJNA473201_P_NODE_87281_length_225_cov_17.427632_g86539_i0 | PRJNA473201 | 87281 | 225 | 17.427632 | 39.212172 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.02 | NTclustered | gi|2912998575|dbj|AP039604.1| | 145626 | g86539 | i0 | 100 | 0.124444444444444 | 28 | 0 | 12 | 0 | 105 | 132 | 21708674 | 21708647 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 23, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 3646039 | 3646039 | PRJNA473201_P_NODE_48023_length_296_cov_4.291480_g47281_i0 | PRJNA473201 | 48023 | 296 | 4.29148 | 12.7027808 | Opisthokonta | 33154 | Mollusca | Mollusca | 102 | 2.69e-17 | NTclustered | gi|7677509|gb|AF252331.1| | 80833 | g47281 | i0 | 94.03 | 21.2060810810811 | 67 | 4 | 23 | 0 | 225 | 291 | 206 | 140 | Tridacna crocea isolate treef5 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 6277 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Cardiida | Cardiidae | Tridacna | Tridacna crocea | |
| 4271700 | 4271700 | PRJNA473201_P_NODE_8604_length_691_cov_4.665049_g7895_i0 | PRJNA473201 | 8604 | 691 | 4.665049 | 32.23548859 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 58.4 | 0.001 | NTclustered | gi|2034304614|ref|XM_041493588.1| | 1735272 | g7895 | i0 | 94.595 | 0.114327062228654 | 37 | 2 | 5 | 0 | 178 | 214 | 2 | 38 | PREDICTED: Gigantopelta aegis protein kintoun-like (LOC121368840), mRNA | blastn | 79 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 5547570 | 5547570 | PRJNA473201_P_NODE_47065_length_298_cov_11.964444_g46323_i0 | PRJNA473201 | 47065 | 298 | 11.964444 | 35.65404312 | Octopus bimaculoides | 37653 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2427239284|ref|XM_052967297.1| | 37653 | g46323 | i0 | 96.97 | 0.929530201342282 | 33 | 1 | 11 | 0 | 250 | 282 | 1320 | 1288 | PREDICTED: Octopus bimaculoides uncharacterized LOC106882728 (LOC106882728), transcript variant X1, mRNA | blastn | 277 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 6822028 | 6822028 | PRJNA473201_P_NODE_70266_length_249_cov_0.875000_g69524_i0 | PRJNA473201 | 70266 | 249 | 0.875 | 2.17875 | Mytilus edulis | 6550 | Mollusca | Mollusca | 422 | 1.49e-113 | NTclustered | gi|2912367598|ref|XM_071296461.1| | 6550 | g69524 | i0 | 97.211 | 69.5301204819277 | 251 | 4 | 100 | 2 | 1 | 249 | 1312 | 1561 | PREDICTED: Mytilus edulis tubulin alpha chain, testis-specific (LOC139510141), mRNA | blastn | 17313 | 422 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 8097789 | 8097789 | PRJNA473201_P_NODE_84927_length_241_cov_0.916667_g84185_i0 | PRJNA473201 | 84927 | 241 | 0.916667 | 2.20916747 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 65.8 | 2.79e-6 | NTclustered | gi|2912991694|dbj|AP039596.1| | 145626 | g84185 | i0 | 97.368 | 11.2199170124481 | 38 | 1 | 16 | 0 | 65 | 102 | 52995677 | 52995640 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence | blastn | 2704 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 12574393 | 12574393 | PRJNA473201_P_NODE_87430_length_221_cov_47.189189_g86688_i0 | PRJNA473201 | 87430 | 221 | 47.189189 | 104.28810769 | Metazoa | 33208 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2912988862|dbj|AP039593.1| | 145626 | g86688 | i0 | 100 | 0.719457013574661 | 30 | 0 | 14 | 0 | 188 | 217 | 47721518 | 47721547 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence | blastn | 159 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 13197793 | 13197793 | PRJNA473201_P_NODE_61051_length_263_cov_1.621053_g60309_i0 | PRJNA473201 | 61051 | 263 | 1.621053 | 4.26336939 | Mytilus trossulus | 6551 | Mollusca | Mollusca | 58.4 | 5.16e-4 | NTclustered | gi|2693895979|ref|XM_063549768.1| | 6551 | g60309 | i0 | 97.143 | 0.133079847908745 | 35 | 0 | 13 | 1 | 19 | 52 | 236 | 202 | PREDICTED: Mytilus trossulus putative uncharacterized protein DDB_G0288537 (LOC134689799), mRNA | blastn | 35 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 15122523 | 15122523 | PRJNA473201_P_NODE_34012_length_340_cov_1.573034_g33270_i0 | PRJNA473201 | 34012 | 340 | 1.573034 | 5.3483156 | Magallana | 147004 | Mollusca | Mollusca | 65.8 | 4.13e-6 | NTclustered | gi|2751293263|ref|XM_011438944.4| | 29159 | g33270 | i0 | 97.368 | 1.22941176470588 | 38 | 1 | 11 | 0 | 284 | 321 | 728 | 691 | PREDICTED: Magallana gigas probable ATP-dependent RNA helicase DDX4 (LOC105335166), transcript variant X1, mRNA | blastn | 418 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 17021500 | 17021500 | PRJNA473201_P_NODE_59114_length_268_cov_17.394872_g58372_i0 | PRJNA473201 | 59114 | 268 | 17.394872 | 46.61825696 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 5.27e-4 | NTclustered | gi|2912991694|dbj|AP039596.1| | 145626 | g58372 | i0 | 97.059 | 0.126865671641791 | 34 | 1 | 13 | 0 | 194 | 227 | 57756139 | 57756106 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence | blastn | 34 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 18295507 | 18295507 | PRJNA473201_P_NODE_44875_length_304_cov_8.831169_g44133_i0 | PRJNA473201 | 44875 | 304 | 8.831169 | 26.84675376 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 54.7 | 0.008 | NTclustered | gi|2868683459|ref|XR_011454898.1| | 31220 | g44133 | i0 | 100 | 0.0953947368421053 | 29 | 0 | 10 | 0 | 189 | 217 | 849 | 877 | PREDICTED: Littorina saxatilis uncharacterized lncRNA (LOC138963771), ncRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 20845296 | 20845296 | PRJNA473201_P_NODE_30377_length_358_cov_23.673684_g29635_i0 | PRJNA473201 | 30377 | 358 | 23.673684 | 84.75178872 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.009 | NTclustered | gi|2912986657|dbj|AP039591.1| | 145626 | g29635 | i0 | 96.875 | 0.0893854748603352 | 32 | 1 | 9 | 0 | 250 | 281 | 28891651 | 28891620 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 10, sequence | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 20845714 | 20845714 | PRJNA473201_P_NODE_55717_length_277_cov_21.794118_g54975_i0 | PRJNA473201 | 55717 | 277 | 21.794118 | 60.36970686 | Mytilus trossulus | 6551 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2693972998|ref|XM_063588363.1| | 6551 | g54975 | i0 | 96.97 | 0.11913357400722 | 33 | 1 | 12 | 0 | 55 | 87 | 1567 | 1535 | PREDICTED: Mytilus trossulus uncharacterized LOC134724949 (LOC134724949), mRNA | blastn | 33 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 20846323 | 20846323 | PRJNA473201_P_NODE_86717_length_233_cov_5.212500_g85975_i0 | PRJNA473201 | 86717 | 233 | 5.2125 | 12.145125 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 52.8 | 0.021 | NTclustered | gi|2442048292|ref|XM_053539395.1| | 6596 | g85975 | i0 | 100 | 0.120171673819742 | 28 | 0 | 12 | 0 | 40 | 67 | 3125 | 3098 | PREDICTED: Mercenaria mercenaria mucin-like protein (LOC123523944), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 22119930 | 22119930 | PRJNA473201_P_NODE_18978_length_454_cov_2.094488_g18236_i0 | PRJNA473201 | 18978 | 454 | 2.094488 | 9.50897552 | Mytilus edulis | 6550 | Mollusca | Mollusca | 63.9 | 2.03e-5 | NTclustered | gi|2912343764|ref|XM_071284956.1| | 6550 | g18236 | i0 | 91.304 | 0.220264317180617 | 46 | 4 | 10 | 0 | 369 | 414 | 519 | 474 | PREDICTED: Mytilus edulis fibroin heavy chain-like (LOC139496382), mRNA | blastn | 100 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis |
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);;