contig_metadata
5 rows where bioproject = "PRJNA721440" and tax_clade = "Metamonada"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4538551 | 4538551 | PRJNA721440_S_NODE_4504_length_277_cov_5.043860_g4378_i0 | PRJNA721440 | 4504 | 277 | 5.04386 | 13.9714922 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2794968545|ref|XM_067872155.1| | 2049356 | g4378 | i0 | 94.444 | 0.635379061371841 | 36 | 2 | 13 | 0 | 75 | 110 | 409 | 444 | Monocercomonoides exilis uncharacterized protein (MONOS_2245), partial mRNA | blastn | 176 | 56.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 27305032 | 27305032 | PRJNA721440_S_NODE_22003_length_152_cov_2.631068_g21877_i0 | PRJNA721440 | 22003 | 152 | 2.631068 | 3.99922336 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 50.8 | 1.49e-5 | NR | XP_067720969.1 | 2049356 | g21877 | i0 | 44.9 | 0.967105263157895 | 49 | 27 | 96.7 | 0 | 2 | 148 | 210 | 258 | XP_067720969.1 putative 60S ribosomal export protein [Monocercomonoides exilis] | diamond | 147 | 50.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 27368475 | 27368475 | PRJNA721440_S_NODE_11723_length_193_cov_2.847222_g11597_i0 | PRJNA721440 | 11723 | 193 | 2.847222 | 5.49513846 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 90.5 | 2.78e-19 | NR | KAK2946567.1 | 2049346 | g11597 | i0 | 65.6 | 0.948186528497409 | 61 | 21 | 94.8 | 0 | 191 | 9 | 537 | 597 | KAK2946567.1 putative Pancreatic alpha-amylase [Blattamonas nauphoetae] | diamond | 183 | 90.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 28947104 | 28947104 | PRJNA721440_S_NODE_19528_length_163_cov_0.894737_g19402_i0 | PRJNA721440 | 19528 | 163 | 0.894737 | 1.45842131 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 53.9 | 1.45e-6 | NR | KAK2962323.1 | 2049346 | g19402 | i0 | 56.3 | 0.883435582822086 | 48 | 21 | 88.3 | 0 | 145 | 2 | 611 | 658 | KAK2962323.1 putative TATA-binding protein-associated factor 172 [Blattamonas nauphoetae] | diamond | 144 | 53.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 31442506 | 31442506 | PRJNA721440_S_NODE_19776_length_162_cov_1.380531_g19650_i0 | PRJNA721440 | 19776 | 162 | 1.380531 | 2.23646022 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 50.4 | 2.09e-5 | NR | XP_067732620.1 | 2049356 | g19650 | i0 | 50 | 0.888888888888889 | 48 | 23 | 87 | 1 | 21 | 161 | 121 | 168 | XP_067732620.1 putative Glycosyltransferase family 25 (LPS biosynthesis protein) [Monocercomonoides exilis] | diamond | 144 | 50.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis |
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);;