contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA980587" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 955987 | 955987 | PRJNA980587_P_NODE_66441_length_278_cov_1.009756_g65648_i0 | PRJNA980587 | 66441 | 278 | 1.009756 | 2.80712168 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 60.2 | 1.53e-4 | NTclustered | gi|2912993551|dbj|AP039598.1| | 145626 | g65648 | i0 | 92.683 | 3.8273381294964 | 41 | 3 | 15 | 0 | 79 | 119 | 15253260 | 15253220 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 17, sequence | blastn | 1064 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 2231657 | 2231657 | PRJNA980587_P_NODE_90102_length_244_cov_0.900585_g89309_i0 | PRJNA980587 | 90102 | 244 | 0.900585 | 2.1974274 | Argopecten irradians | 31199 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2835362634|ref|XM_069255309.1| | 31199 | g89309 | i0 | 94.286 | 0.14344262295082 | 35 | 2 | 14 | 0 | 89 | 123 | 12678 | 12712 | PREDICTED: Argopecten irradians A-kinase anchor protein 9-like (LOC138314777), mRNA | blastn | 35 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 3506051 | 3506051 | PRJNA980587_P_NODE_32003_length_423_cov_2.202857_g31210_i0 | PRJNA980587 | 32003 | 423 | 2.202857 | 9.31808511 | Haliotis asinina | 109174 | Mollusca | Mollusca | 54.7 | 0.011 | NTclustered | gi|2793415233|ref|XM_067820370.1| | 109174 | g31210 | i0 | 96.875 | 0.0756501182033097 | 32 | 1 | 8 | 0 | 120 | 151 | 205 | 174 | PREDICTED: Haliotis asinina putative uncharacterized protein DDB_G0290521 (LOC137288011), mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 4784220 | 4784220 | PRJNA980587_P_NODE_71084_length_267_cov_1.582474_g70291_i0 | PRJNA980587 | 71084 | 267 | 1.582474 | 4.22520558 | Mya arenaria | 6604 | Mollusca | Mollusca | 84.2 | 8.66e-12 | NTclustered | gi|2427390246|ref|XM_052917861.1| | 6604 | g70291 | i0 | 80.531 | 6.50187265917603 | 113 | 19 | 42 | 1 | 118 | 230 | 603 | 712 | PREDICTED: Mya arenaria acanthoscurrin-2-like (LOC128212408), mRNA | blastn | 1736 | 84.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 7333408 | 7333408 | PRJNA980587_P_NODE_42686_length_355_cov_1.074468_g41893_i0 | PRJNA980587 | 42686 | 355 | 1.074468 | 3.8143614 | Mytilus trossulus | 6551 | Mollusca | Mollusca | 272 | 2.37e-68 | NTclustered | gi|2694002732|ref|XM_063566204.1| | 6551 | g41893 | i0 | 82.334 | 90.7098591549296 | 317 | 52 | 89 | 4 | 1 | 315 | 464 | 150 | PREDICTED: Mytilus trossulus tubulin alpha-1A chain (LOC134706872), mRNA | blastn | 32202 | 272 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 17533377 | 17533377 | PRJNA980587_P_NODE_25174_length_493_cov_3.585714_g24383_i0 | PRJNA980587 | 25174 | 493 | 3.585714 | 17.67757002 | Saccostrea cuccullata | 36930 | Mollusca | Mollusca | 291 | 9.37e-74 | NTclustered | gi|2669047405|ref|XM_062755441.1| | 36930 | g24383 | i0 | 80.679 | 21.0223123732252 | 383 | 66 | 77 | 7 | 7 | 385 | 485 | 107 | PREDICTED: Saccostrea cucullata small ribosomal subunit protein uS11 (LOC134273250), mRNA | blastn | 10364 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 20082140 | 20082140 | PRJNA980587_P_NODE_37996_length_381_cov_1.084416_g37203_i0 | PRJNA980587 | 37996 | 381 | 1.084416 | 4.13162496 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 62.1 | 6.04e-5 | NTclustered | gi|2912988862|dbj|AP039593.1| | 145626 | g37203 | i0 | 94.872 | 5.01049868766404 | 39 | 2 | 10 | 0 | 3 | 41 | 43151825 | 43151863 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence | blastn | 1909 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 22633140 | 22633140 | PRJNA980587_P_NODE_73618_length_261_cov_2.090426_g72825_i0 | PRJNA980587 | 73618 | 261 | 2.090426 | 5.45601186 | Mytilus edulis | 6550 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|2912412963|ref|XM_071319418.1| | 6550 | g72825 | i0 | 92.308 | 0.298850574712644 | 39 | 2 | 15 | 1 | 7 | 44 | 2915 | 2953 | PREDICTED: Mytilus edulis protein starmaker-like (LOC139524564), transcript variant X2, mRNA | blastn | 78 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 23908617 | 23908617 | PRJNA980587_P_NODE_79219_length_251_cov_0.865169_g78426_i0 | PRJNA980587 | 79219 | 251 | 0.865169 | 2.17157419 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2868691093|ref|XM_070349060.1| | 31220 | g78426 | i0 | 100 | 0.227091633466135 | 29 | 0 | 12 | 0 | 203 | 231 | 745 | 717 | PREDICTED: Littorina saxatilis ras-related protein Rab-30-like (LOC138976227), mRNA | blastn | 57 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis |
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);;