contig_metadata
5 rows where bioproject = "PRJNA906294" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7265033 | 7265033 | PRJNA906294_P_NODE_169686_length_287_cov_0.934579_g165570_i0 | PRJNA906294 | 169686 | 287 | 0.934579 | 2.68224173 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 52.8 | 0.027 | NTclustered | gi|2794969751|ref|XM_067867037.1| | 2049356 | g165570 | i0 | 100 | 0.0975609756097561 | 28 | 0 | 10 | 0 | 123 | 150 | 3864 | 3837 | Monocercomonoides exilis uncharacterized protein (MONOS_14251), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 8901498 | 8901498 | PRJNA906294_P_NODE_211807_length_248_cov_0.868571_g207691_i0 | PRJNA906294 | 211807 | 248 | 0.868571 | 2.15405608 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 122 | 2.3699999999999998e-32 | NR | KAJ4455763.1 | 342808 | g207691 | i0 | 62 | 9.58064516129032 | 79 | 30 | 95.6 | 0 | 2 | 238 | 170 | 248 | KAJ4455763.1 putative Peptidyl-prolyl cis-trans isomerase CYP22 [Paratrimastix pyriformis] | diamond | 2376 | 122 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 27277317 | 27277317 | PRJNA906294_P_NODE_169243_length_287_cov_1.420561_g165127_i0 | PRJNA906294 | 169243 | 287 | 1.420561 | 4.07701007 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 66.2 | 2.6200000000000003e-10 | NR | KAJ4459671.1 | 342808 | g165127 | i0 | 40.7 | 1.79790940766551 | 86 | 48 | 89.9 | 1 | 259 | 2 | 1 | 83 | KAJ4459671.1 putative Cysteine proteinase 3 [Paratrimastix pyriformis] | diamond | 516 | 66.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 27790139 | 27790139 | PRJNA906294_P_NODE_22784_length_1210_cov_2.934916_g19974_i0 | PRJNA906294 | 22784 | 1210 | 2.934916 | 35.5124836 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 91.3 | 2.87e-16 | NR | KAJ4461760.1 | 342808 | g19974 | i0 | 31.9 | 0.828099173553719 | 160 | 101 | 37.7 | 2 | 919 | 464 | 116 | 275 | KAJ4461760.1 putative RNA binding protein [Paratrimastix pyriformis] | diamond | 1002 | 91.3 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31224876 | 31224876 | PRJNA906294_P_NODE_184035_length_271_cov_1.535354_g179919_i0 | PRJNA906294 | 184035 | 271 | 1.535354 | 4.16080934 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 44.3 | 0.0152 | NR | KAJ4452900.1 | 342808 | g179919 | i0 | 37 | 0.597785977859779 | 54 | 33 | 58.7 | 1 | 175 | 17 | 184 | 237 | KAJ4452900.1 hypothetical protein PAPYR_12781 [Paratrimastix pyriformis] | diamond | 162 | 44.3 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis |
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);;