contig_metadata
9 rows where bioproject = "PRJNA874604", tax_clade = "Metamonada" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19978203 | 19978203 | PRJNA874604_P_NODE_26236_length_362_cov_3.802768_g25884_i0 | PRJNA874604 | 26236 | 362 | 3.802768 | 13.76602016 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 84.7 | 1.94e-18 | NR | KAJ4453711.1 | 342808 | g25884 | i0 | 56.6 | 0.629834254143646 | 76 | 30 | 63 | 1 | 353 | 126 | 2 | 74 | KAJ4453711.1 putative 60S acidic ribosomal protein P1 [Paratrimastix pyriformis] | diamond | 228 | 84.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 19979639 | 19979639 | PRJNA874604_P_NODE_96576_length_242_cov_0.911243_g96224_i0 | PRJNA874604 | 96576 | 242 | 0.911243 | 2.20520806 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2794978514|ref|XM_067879823.1| | 2049356 | g96224 | i0 | 96.875 | 0.132231404958678 | 32 | 1 | 13 | 0 | 84 | 115 | 3868 | 3899 | Monocercomonoides exilis uncharacterized protein (MONOS_9333p1), partial mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 24189906 | 24189906 | PRJNA874604_P_NODE_93819_length_243_cov_0.905882_g93467_i0 | PRJNA874604 | 93819 | 243 | 0.905882 | 2.20129326 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 88.2 | 2.68e-18 | NR | KAK2963220.1 | 2049346 | g93467 | i0 | 54.5 | 1.83950617283951 | 77 | 30 | 88.9 | 1 | 218 | 3 | 17 | 93 | KAK2963220.1 putative ATP-dependent RNA helicase SUB2 [Blattamonas nauphoetae] | diamond | 447 | 88.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 27466206 | 27466206 | PRJNA874604_P_NODE_89083_length_244_cov_1.771930_g88731_i0 | PRJNA874604 | 89083 | 244 | 1.77193 | 4.3235092 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 79.7 | 2.67e-16 | NR | KAJ4458781.1 | 342808 | g88731 | i0 | 55.6 | 0.774590163934426 | 63 | 28 | 77.5 | 0 | 16 | 204 | 65 | 127 | KAJ4458781.1 putative LOG family protein YvdD [Paratrimastix pyriformis] | diamond | 189 | 79.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 27560586 | 27560586 | PRJNA874604_P_NODE_80644_length_247_cov_0.885057_g80292_i0 | PRJNA874604 | 80644 | 247 | 0.885057 | 2.18609079 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 69.3 | 1.7e-11 | NR | KAK2947955.1 | 2049346 | g80292 | i0 | 50.8 | 3.09716599190283 | 63 | 31 | 76.5 | 0 | 2 | 190 | 554 | 616 | KAK2947955.1 putative Protein phosphatase 2C [Blattamonas nauphoetae] | diamond | 765 | 69.3 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 28097449 | 28097449 | PRJNA874604_P_NODE_57065_length_271_cov_1.535354_g56713_i0 | PRJNA874604 | 57065 | 271 | 1.535354 | 4.16080934 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 43.5 | 0.00662 | NR | KAA6401863.1 | 222440 | g56713 | i0 | 41.2 | 0.752767527675277 | 68 | 38 | 73.1 | 1 | 213 | 16 | 5 | 72 | KAA6401863.1 MAG: hypothetical protein EZS28_002610 [Streblomastix strix] | diamond | 204 | 43.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 28160839 | 28160839 | PRJNA874604_P_NODE_26925_length_359_cov_1.076923_g26573_i0 | PRJNA874604 | 26925 | 359 | 1.076923 | 3.86615357 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 79 | 2.72e-14 | NR | KAJ4461985.1 | 342808 | g26573 | i0 | 43.8 | 5.12256267409471 | 96 | 53 | 79.4 | 1 | 343 | 59 | 107 | 202 | KAJ4461985.1 putative RNA-binding protein BRN1 [Paratrimastix pyriformis] | diamond | 1839 | 79 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 29589218 | 29589218 | PRJNA874604_P_NODE_79730_length_248_cov_0.880000_g79378_i0 | PRJNA874604 | 79730 | 248 | 0.88 | 2.1824 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 46.2 | 0.00244 | NR | KAJ4455491.1 | 342808 | g79378 | i0 | 41.5 | 1.24596774193548 | 53 | 31 | 64.1 | 0 | 202 | 44 | 1527 | 1579 | KAJ4455491.1 hypothetical protein PAPYR_9573 [Paratrimastix pyriformis] | diamond | 309 | 46.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 29897368 | 29897368 | PRJNA874604_P_NODE_82931_length_246_cov_1.780347_g82579_i0 | PRJNA874604 | 82931 | 246 | 1.780347 | 4.37965362 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 83.6 | 1.3e-18 | NR | KAJ4453711.1 | 342808 | g82579 | i0 | 56.8 | 0.902439024390244 | 74 | 29 | 90.2 | 1 | 17 | 238 | 2 | 72 | KAJ4453711.1 putative 60S acidic ribosomal protein P1 [Paratrimastix pyriformis] | diamond | 222 | 83.6 | 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);;