contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA994052" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2251938 | 2251938 | PRJNA994052_P_NODE_61542_length_223_cov_281.780000_g60286_i0 | PRJNA994052 | 61542 | 223 | 281.78 | 628.3694 | Leptochiton asellus | 211853 | Mollusca | Mollusca | 165 | 2.44e-36 | NTclustered | gi|34369208|gb|AY145414.1| | 211853 | g60286 | i0 | 87.943 | 6.65470852017937 | 141 | 16 | 63 | 1 | 81 | 221 | 2683 | 2544 | Leptochiton asellus 28S ribosomal RNA gene, partial sequence | blastn | 1484 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Lepidopleurida | Lepidopleuridae | Leptochiton | Leptochiton asellus | |
| 2548919 | 2548919 | PRJNA994052_P_NODE_69822_length_212_cov_169.597122_g68566_i0 | PRJNA994052 | 69822 | 212 | 169.597122 | 359.54589864 | Opisthokonta | 33154 | Mollusca | Mollusca | 93.5 | 1.1e-14 | NTclustered | gi|2441993380|ref|XM_053520321.1| | 6596 | g68566 | i0 | 92.308 | 10.0283018867925 | 65 | 5 | 31 | 0 | 1 | 65 | 332 | 396 | PREDICTED: Mercenaria mercenaria histone H4-like (LOC128547447), mRNA | blastn | 2126 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 3526796 | 3526796 | PRJNA994052_P_NODE_20123_length_308_cov_75.055319_g18897_i0 | PRJNA994052 | 20123 | 308 | 75.055319 | 231.17038252 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 86.1 | 2.83e-12 | NTclustered | gi|1242758558|ref|XM_022462631.1| | 6565 | g18897 | i0 | 87.671 | 0.237012987012987 | 73 | 9 | 24 | 0 | 23 | 95 | 952 | 1024 | PREDICTED: Crassostrea virginica guanine nucleotide-binding protein subunit beta-2-like 1 (LOC111121370), mRNA | blastn | 73 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 3527256 | 3527256 | PRJNA994052_P_NODE_59883_length_226_cov_34.895425_g58627_i0 | PRJNA994052 | 59883 | 226 | 34.895425 | 78.8636605 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|1914631023|ref|XM_029788727.2| | 2607531 | g58627 | i0 | 100 | 0.128318584070796 | 29 | 0 | 13 | 0 | 164 | 192 | 2039 | 2067 | PREDICTED: Octopus sinensis zinc finger protein OZF-like (LOC115218793), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 5101402 | 5101402 | PRJNA994052_P_NODE_51124_length_239_cov_52.301205_g49869_i0 | PRJNA994052 | 51124 | 239 | 52.301205 | 124.99987995 | Opisthokonta | 33154 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2912998015|dbj|AP039603.1| | 145626 | g49869 | i0 | 96.875 | 0.414225941422594 | 32 | 1 | 13 | 0 | 15 | 46 | 15926940 | 15926971 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 22, sequence | blastn | 99 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 8629219 | 8629219 | PRJNA994052_P_NODE_20647_length_307_cov_73.880342_g19420_i0 | PRJNA994052 | 20647 | 307 | 73.880342 | 226.81264994 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 86.1 | 2.82e-12 | NTclustered | gi|1242758558|ref|XM_022462631.1| | 6565 | g19420 | i0 | 87.671 | 0.237785016286645 | 73 | 9 | 24 | 0 | 23 | 95 | 952 | 1024 | PREDICTED: Crassostrea virginica guanine nucleotide-binding protein subunit beta-2-like 1 (LOC111121370), mRNA | blastn | 73 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 9904533 | 9904533 | PRJNA994052_P_NODE_31788_length_277_cov_23.127451_g30544_i0 | PRJNA994052 | 31788 | 277 | 23.127451 | 64.06303927 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 58.4 | 5.48e-4 | NTclustered | gi|2034312691|ref|XM_041497935.1| | 1735272 | g30544 | i0 | 100 | 0.212996389891697 | 31 | 0 | 11 | 0 | 127 | 157 | 9085 | 9115 | PREDICTED: Gigantopelta aegis ras-related protein R-Ras2-like (LOC121371789), mRNA | blastn | 59 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 16279618 | 16279618 | PRJNA994052_P_NODE_72593_length_209_cov_35.889706_g71337_i0 | PRJNA994052 | 72593 | 209 | 35.889706 | 75.00948554 | Lottia gigantea | 225164 | Mollusca | Mollusca | 113 | 8.290000000000001e-21 | NTclustered | gi|676463422|ref|XM_009058344.1| | 225164 | g71337 | i0 | 80.405 | 9.55980861244019 | 148 | 29 | 71 | 0 | 32 | 179 | 1043 | 1190 | Lottia gigantea hypothetical protein mRNA | blastn | 1998 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 17554117 | 17554117 | PRJNA994052_P_NODE_23654_length_298_cov_91.462222_g22419_i0 | PRJNA994052 | 23654 | 298 | 91.462222 | 272.55742156 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 86.1 | 2.73e-12 | NTclustered | gi|1242758558|ref|XM_022462631.1| | 6565 | g22419 | i0 | 87.671 | 0.24496644295302 | 73 | 9 | 24 | 0 | 204 | 276 | 1024 | 952 | PREDICTED: Crassostrea virginica guanine nucleotide-binding protein subunit beta-2-like 1 (LOC111121370), mRNA | blastn | 73 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 20103016 | 20103016 | PRJNA994052_P_NODE_47256_length_245_cov_247.302326_g46005_i0 | PRJNA994052 | 47256 | 245 | 247.302326 | 605.8906987 | Leptochiton asellus | 211853 | Mollusca | Mollusca | 165 | 2.72e-36 | NTclustered | gi|34369208|gb|AY145414.1| | 211853 | g46005 | i0 | 85.535 | 0.775510204081633 | 159 | 22 | 65 | 1 | 85 | 243 | 2701 | 2544 | Leptochiton asellus 28S ribosomal RNA gene, partial sequence | blastn | 190 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Lepidopleurida | Lepidopleuridae | Leptochiton | Leptochiton asellus | |
| 21379034 | 21379034 | PRJNA994052_P_NODE_81817_length_198_cov_191.552000_g80560_i0 | PRJNA994052 | 81817 | 198 | 191.552 | 379.27296 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 178 | 2.71e-40 | NTclustered | gi|2913002590|dbj|AP039619.1| | 145626 | g80560 | i0 | 83.59 | 143.348484848485 | 195 | 27 | 96 | 5 | 3 | 193 | 251838 | 252031 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, sequence_id: unanchored10, sequence | blastn | 28383 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 22653283 | 22653283 | PRJNA994052_P_NODE_19658_length_309_cov_73.432203_g18435_i0 | PRJNA994052 | 19658 | 309 | 73.432203 | 226.90550727 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 86.1 | 2.84e-12 | NTclustered | gi|1242758558|ref|XM_022462631.1| | 6565 | g18435 | i0 | 87.671 | 0.236245954692557 | 73 | 9 | 24 | 0 | 215 | 287 | 1024 | 952 | PREDICTED: Crassostrea virginica guanine nucleotide-binding protein subunit beta-2-like 1 (LOC111121370), mRNA | blastn | 73 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 23928747 | 23928747 | PRJNA994052_P_NODE_22779_length_301_cov_75.877193_g21550_i0 | PRJNA994052 | 22779 | 301 | 75.877193 | 228.39035093 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 86.1 | 2.76e-12 | NTclustered | gi|1242758558|ref|XM_022462631.1| | 6565 | g21550 | i0 | 87.671 | 0.242524916943522 | 73 | 9 | 24 | 0 | 23 | 95 | 952 | 1024 | PREDICTED: Crassostrea virginica guanine nucleotide-binding protein subunit beta-2-like 1 (LOC111121370), mRNA | blastn | 73 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 25202802 | 25202802 | PRJNA994052_P_NODE_61540_length_223_cov_282.120000_g60284_i0 | PRJNA994052 | 61540 | 223 | 282.12 | 629.1276 | Leptochiton asellus | 211853 | Mollusca | Mollusca | 165 | 2.44e-36 | NTclustered | gi|34369208|gb|AY145414.1| | 211853 | g60284 | i0 | 85.535 | 5.25112107623318 | 159 | 22 | 71 | 1 | 63 | 221 | 2701 | 2544 | Leptochiton asellus 28S ribosomal RNA gene, partial sequence | blastn | 1171 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Lepidopleurida | Lepidopleuridae | Leptochiton | Leptochiton asellus |
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);;