contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA448207" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1713869 | 1713869 | PRJNA448207_S_NODE_3602_length_247_cov_1.965517_g3591_i0 | PRJNA448207 | 3602 | 247 | 1.965517 | 4.85482699 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 4.8e-4 | NTclustered | gi|2912988862|dbj|AP039593.1| | 145626 | g3591 | i0 | 100 | 0.502024291497976 | 31 | 0 | 13 | 0 | 124 | 154 | 4320819 | 4320849 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence | blastn | 124 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 6816709 | 6816709 | PRJNA448207_P_NODE_8286_length_425_cov_2.823864_g8124_i0 | PRJNA448207 | 8286 | 425 | 2.823864 | 12.001422 | Mollusca environmental sample | 653389 | Mollusca | Mollusca | 296 | 1.71e-75 | NTclustered | gi|156254524|gb|EF528299.1| | 653389 | g8124 | i0 | 80.562 | 52.1717647058824 | 427 | 48 | 100 | 20 | 1 | 425 | 980 | 587 | Uncultured mollusc isolate XenLSU7 28S ribosomal RNA gene, partial sequence | blastn | 22173 | 296 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Mollusca environmental sample | |||||
| 9366915 | 9366915 | PRJNA448207_S_NODE_2248_length_300_cov_1.674009_g2237_i0 | PRJNA448207 | 2248 | 300 | 1.674009 | 5.022027 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 187 | 7.33e-43 | NTclustered | gi|2868678165|ref|XM_070323641.1| | 31220 | g2237 | i0 | 78.425 | 88.9533333333333 | 292 | 60 | 97 | 3 | 3 | 292 | 1344 | 1634 | PREDICTED: Littorina saxatilis spectrin beta chain-like (LOC138952069), transcript variant X1, mRNA | blastn | 26686 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 11917238 | 11917238 | PRJNA448207_P_NODE_11790_length_363_cov_1.327586_g11628_i0 | PRJNA448207 | 11790 | 363 | 1.327586 | 4.81913718 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 7.4e-4 | NTclustered | gi|2912988862|dbj|AP039593.1| | 145626 | g11628 | i0 | 100 | 0.341597796143251 | 31 | 0 | 9 | 0 | 243 | 273 | 4320849 | 4320819 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence | blastn | 124 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 14467162 | 14467162 | PRJNA448207_P_NODE_12392_length_356_cov_1.088339_g12229_i0 | PRJNA448207 | 12392 | 356 | 1.088339 | 3.87448684 | Argopecten purpuratus | 228297 | Mollusca | Mollusca | 658 | 0 | NTclustered | gi|1188496355|gb|KY321561.1| | 228297 | g12229 | i0 | 100 | 71.8370786516854 | 356 | 0 | 100 | 0 | 1 | 356 | 7687 | 7332 | Argopecten purpuratus mitochondrion, complete genome | blastn | 25574 | 658 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten purpuratus | |
| 22115172 | 22115172 | PRJNA448207_P_NODE_18638_length_298_cov_1.128889_g18475_i0 | PRJNA448207 | 18638 | 298 | 1.128889 | 3.36408922 | Argopecten purpuratus | 228297 | Mollusca | Mollusca | 540 | 4.85e-149 | NTclustered | gi|359291823|gb|JN848510.1| | 228297 | g18475 | i0 | 99.331 | 74.0503355704698 | 299 | 1 | 100 | 1 | 1 | 298 | 146 | 444 | Argopecten purpuratus haplotype H10 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 22067 | 540 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten purpuratus | |
| 23390745 | 23390745 | PRJNA448207_P_NODE_15239_length_326_cov_2.430830_g15076_i0 | PRJNA448207 | 15239 | 326 | 2.43083 | 7.9245058 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 198 | 3.72e-46 | NTclustered | gi|2868688207|ref|XM_070347684.1| | 31220 | g15076 | i0 | 84.772 | 45.2085889570552 | 197 | 30 | 60 | 0 | 130 | 326 | 828 | 632 | PREDICTED: Littorina saxatilis protein yippee-like 1 (LOC138975036), transcript variant X1, mRNA | blastn | 14738 | 198 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 25318413 | 25318413 | PRJNA448207_P_NODE_18680_length_298_cov_0.897778_g18517_i0 | PRJNA448207 | 18680 | 298 | 0.897778 | 2.67537844 | Metazoa | 33208 | Mollusca | Mollusca | 54.7 | 0.008 | NTclustered | gi|2868609207|ref|XR_011456361.1| | 31220 | g18517 | i0 | 92.308 | 3.14765100671141 | 39 | 2 | 13 | 1 | 227 | 264 | 1357 | 1395 | PREDICTED: Littorina saxatilis origin recognition complex subunit 6-like (LOC138969046), transcript variant X2, misc_RNA | blastn | 938 | 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);;