contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax_phylum = "Preaxostyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7529223 | 7529223 | PRJNA630162_P_NODE_24486_length_370_cov_9.464174_g22966_i0 | PRJNA630162 | 24486 | 370 | 9.464174 | 35.0174438 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 165 | 4.33e-36 | NTclustered | gi|14348578|gb|AF244905.1|AF244905 | 137419 | g22966 | i0 | 79.668 | 65.7135135135135 | 241 | 40 | 64 | 8 | 1 | 235 | 1692 | 1455 | Trimastix marina small subunit ribosomal RNA gene, complete sequence | blastn | 24314 | 165 | 1 | Eukaryota | Metamonada | Preaxostyla | Trimastigidae | Trimastix | Trimastix marina | ||||
| 8254826 | 8254826 | PRJNA630162_P_NODE_139987_length_167_cov_0.881356_g138464_i0 | PRJNA630162 | 139987 | 167 | 0.881356 | 1.47186452 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 52.8 | 0.014 | NTclustered | gi|2794962998|ref|XM_067865981.1| | 2049356 | g138464 | i0 | 100 | 0.167664670658683 | 28 | 0 | 17 | 0 | 26 | 53 | 1883 | 1910 | Monocercomonoides exilis uncharacterized protein (MONOS_1329), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 10806797 | 10806797 | PRJNA630162_P_NODE_71369_length_212_cov_2.349693_g69846_i0 | PRJNA630162 | 71369 | 212 | 2.349693 | 4.98134916 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|2794952733|ref|XM_067873948.1| | 2049356 | g69846 | i0 | 100 | 0.136792452830189 | 29 | 0 | 14 | 0 | 17 | 45 | 3515 | 3487 | Monocercomonoides exilis putative CMGC/DYRK/DYRK2 protein kinase (MONOS_3918), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 10807027 | 10807027 | PRJNA630162_P_NODE_95949_length_188_cov_1.460432_g94426_i0 | PRJNA630162 | 95949 | 188 | 1.460432 | 2.74561216 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 52.8 | 0.016 | NTclustered | gi|2794956966|ref|XM_067878719.1| | 2049356 | g94426 | i0 | 96.875 | 0.170212765957447 | 32 | 0 | 17 | 1 | 40 | 71 | 397 | 367 | Monocercomonoides exilis uncharacterized protein (MONOS_8316), partial mRNA | blastn | 32 | 52.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 15905119 | 15905119 | PRJNA630162_P_NODE_36493_length_296_cov_2.020243_g34970_i0 | PRJNA630162 | 36493 | 296 | 2.020243 | 5.97991928 | Monocercomonoides sp. | 2049352 | Preaxostyla | other_Eukaryota | 117 | 9.61e-22 | NTclustered | gi|1270119086|gb|MG264560.1| | 2049352 | g34970 | i0 | 91.667 | 29.1554054054054 | 84 | 7 | 28 | 0 | 55 | 138 | 2410 | 2493 | Monocercomonoides sp. strain ERYM1 small subunit ribosomal RNA gene, partial sequence | blastn | 8630 | 117 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides sp. | |||
| 18453548 | 18453548 | PRJNA630162_P_NODE_125895_length_171_cov_2.311475_g124372_i0 | PRJNA630162 | 125895 | 171 | 2.311475 | 3.95262225 | uncultured Oxymonadida sp. | 413579 | Preaxostyla | other_Eukaryota | 121 | 3.87e-23 | NTclustered | gi|119117110|gb|DQ925196.1| | 413579 | g124372 | i0 | 85.841 | 4.58479532163743 | 113 | 16 | 66 | 0 | 35 | 147 | 345 | 233 | Unidentified Oxymonadida clone R3 alpha-tubulin (Atub) mRNA, partial cds | blastn | 784 | 121 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | uncultured Oxymonadida sp. | |||||
| 19728743 | 19728743 | PRJNA630162_P_NODE_30816_length_325_cov_3.376812_g29294_i0 | PRJNA630162 | 30816 | 325 | 3.376812 | 10.974639 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 63.9 | 1.41e-5 | NTclustered | gi|2794955540|ref|XM_067878360.1| | 2049356 | g29294 | i0 | 93.023 | 5.93538461538462 | 43 | 3 | 13 | 0 | 6 | 48 | 1978 | 2020 | Monocercomonoides exilis putative serine/threonine-protein kinase ATG1t (MONOS_7991), partial mRNA | blastn | 1929 | 63.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 22279135 | 22279135 | PRJNA630162_P_NODE_172258_length_152_cov_2.650485_g170735_i0 | PRJNA630162 | 172258 | 152 | 2.650485 | 4.0287372 | Saccinobaculus environmental sample | 413587 | Preaxostyla | other_Eukaryota | 121 | 3.36e-23 | NTclustered | gi|119116966|gb|DQ925019.1| | 413587 | g170735 | i0 | 81.333 | 22.3552631578947 | 150 | 26 | 99 | 2 | 3 | 152 | 516 | 663 | Uncultured Saccinobaculus sp. clone 42 alpha-tubulin (Atub) mRNA, partial cds | blastn | 3398 | 121 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Saccinobaculidae | Saccinobaculus | Saccinobaculus environmental sample |
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);;