contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1008624" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 154411 | 154411 | PRJNA1008624_P_NODE_29281_length_167_cov_1.720339_g29093_i0 | PRJNA1008624 | 29281 | 167 | 1.720339 | 2.87296613 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.014 | NTclustered | gi|2912981848|dbj|AP039587.1| | 145626 | g29093 | i0 | 100 | 0.167664670658683 | 28 | 0 | 17 | 0 | 74 | 101 | 41261334 | 41261361 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 3980324 | 3980324 | PRJNA1008624_P_NODE_11984_length_241_cov_1.895833_g11796_i0 | PRJNA1008624 | 11984 | 241 | 1.895833 | 4.56895753 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2912991694|dbj|AP039596.1| | 145626 | g11796 | i0 | 100 | 0.116182572614108 | 28 | 0 | 12 | 0 | 29 | 56 | 45548946 | 45548919 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 6532585 | 6532585 | PRJNA1008624_P_NODE_29946_length_167_cov_0.881356_g29758_i0 | PRJNA1008624 | 29946 | 167 | 0.881356 | 1.47186452 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 3.01e-4 | NTclustered | gi|2912997258|dbj|AP039602.1| | 145626 | g29758 | i0 | 100 | 0.532934131736527 | 31 | 0 | 19 | 0 | 8 | 38 | 61320452 | 61320422 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence | blastn | 89 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 6532945 | 6532945 | PRJNA1008624_P_NODE_9486_length_272_cov_1.058296_g9298_i0 | PRJNA1008624 | 9486 | 272 | 1.058296 | 2.87856512 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|2912989933|dbj|AP039594.1| | 145626 | g9298 | i0 | 92.308 | 0.143382352941176 | 39 | 2 | 14 | 1 | 7 | 45 | 19188236 | 19188199 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, sequence | blastn | 39 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 7806913 | 7806913 | PRJNA1008624_P_NODE_27087_length_169_cov_0.866667_g26899_i0 | PRJNA1008624 | 27087 | 169 | 0.866667 | 1.46466723 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.004 | NTclustered | gi|2912995509|dbj|AP039600.1| | 145626 | g26899 | i0 | 96.97 | 0.390532544378698 | 33 | 0 | 19 | 1 | 65 | 96 | 16606729 | 16606697 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence | blastn | 66 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 9081636 | 9081636 | PRJNA1008624_P_NODE_19648_length_193_cov_1.430556_g19460_i0 | PRJNA1008624 | 19648 | 193 | 1.430556 | 2.76097308 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 52.8 | 0.017 | NTclustered | gi|1207925758|ref|XM_021496308.1| | 6573 | g19460 | i0 | 96.774 | 0.642487046632124 | 31 | 1 | 16 | 0 | 51 | 81 | 6938 | 6908 | PREDICTED: Mizuhopecten yessoensis kinesin-like protein KIN-14E (LOC110449436), transcript variant X1, mRNA | blastn | 124 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 15456584 | 15456584 | PRJNA1008624_P_NODE_14193_length_223_cov_1.729885_g14005_i0 | PRJNA1008624 | 14193 | 223 | 1.729885 | 3.85764355 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 4.26e-4 | NTclustered | gi|2912995509|dbj|AP039600.1| | 145626 | g14005 | i0 | 97.059 | 15.1031390134529 | 34 | 1 | 17 | 0 | 41 | 74 | 22237722 | 22237689 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence | blastn | 3368 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 15457082 | 15457082 | PRJNA1008624_P_NODE_33493_length_164_cov_0.904348_g33305_i0 | PRJNA1008624 | 33493 | 164 | 0.904348 | 1.48313072 | Helix thessalica | 1729722 | Mollusca | Mollusca | 52.8 | 0.014 | NTclustered | gi|2250085263|gb|ON706402.1| | 1729722 | g33305 | i0 | 100 | 0.170731707317073 | 28 | 0 | 17 | 0 | 33 | 60 | 515 | 542 | Helix thessalica isolate 6267 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Helicidae | Helix | Helix thessalica | |
| 20555421 | 20555421 | PRJNA1008624_P_NODE_22937_length_182_cov_1.150376_g22749_i0 | PRJNA1008624 | 22937 | 182 | 1.150376 | 2.09368432 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2913002619|dbj|AP039638.1| | 145626 | g22749 | i0 | 96.97 | 0.181318681318681 | 33 | 1 | 18 | 0 | 47 | 79 | 28031 | 27999 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, sequence_id: unanchored29, sequence | blastn | 33 | 56.5 | 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);;