contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA1237347" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2895442 | 2895442 | PRJNA1237347_P_NODE_515543_length_246_cov_0.890173_g508970_i0 | PRJNA1237347 | 515543 | 246 | 0.890173 | 2.18982558 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 65.8 | 2.85e-6 | NTclustered | gi|2794964331|ref|XM_067868456.1| | 2049356 | g508970 | i0 | 87.719 | 4.10569105691057 | 57 | 5 | 23 | 2 | 180 | 235 | 5590 | 5645 | Monocercomonoides exilis uncharacterized protein (MONOS_15570fu15571), partial mRNA | blastn | 1010 | 65.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 2895535 | 2895535 | PRJNA1237347_P_NODE_521143_length_245_cov_0.895349_g514570_i0 | PRJNA1237347 | 521143 | 245 | 0.895349 | 2.19360505 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2794969055|ref|XM_067872794.1| | 2049356 | g514570 | i0 | 96.97 | 0.379591836734694 | 33 | 1 | 13 | 0 | 195 | 227 | 10704 | 10736 | Monocercomonoides exilis uncharacterized protein (MONOS_2840), partial mRNA | blastn | 93 | 56.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 9264898 | 9264898 | PRJNA1237347_P_NODE_125848_length_587_cov_2.175097_g119327_i0 | PRJNA1237347 | 125848 | 587 | 2.175097 | 12.76781939 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 54.7 | 0.016 | NTclustered | gi|2794935562|ref|XM_067863409.1| | 2049356 | g119327 | i0 | 100 | 0.0494037478705281 | 29 | 0 | 5 | 0 | 389 | 417 | 3451 | 3479 | Monocercomonoides exilis putative proteasome activator subunit 4 (MONOS_10921), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 13091294 | 13091294 | PRJNA1237347_P_NODE_159171_length_504_cov_1.250580_g152610_i0 | PRJNA1237347 | 159171 | 504 | 1.25058 | 6.3029232 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 52.8 | 0.049 | NTclustered | gi|2794964924|ref|XM_067874062.1| | 2049356 | g152610 | i0 | 100 | 0.111111111111111 | 28 | 0 | 6 | 0 | 412 | 439 | 6567 | 6540 | Monocercomonoides exilis uncharacterized protein (MONOS_4022), partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 15645321 | 15645321 | PRJNA1237347_P_NODE_396813_length_281_cov_1.221154_g390240_i0 | PRJNA1237347 | 396813 | 281 | 1.221154 | 3.43144274 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 52.8 | 0.026 | NTclustered | gi|2794962693|ref|XM_067866927.1| | 2049356 | g390240 | i0 | 100 | 0.099644128113879 | 28 | 0 | 10 | 0 | 12 | 39 | 2135 | 2108 | Monocercomonoides exilis uncharacterized protein (MONOS_14148), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 16919981 | 16919981 | PRJNA1237347_P_NODE_417154_length_272_cov_2.221106_g410581_i0 | PRJNA1237347 | 417154 | 272 | 2.221106 | 6.04140832 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 52.8 | 0.025 | NTclustered | gi|2794968815|ref|XM_067879122.1| | 2049356 | g410581 | i0 | 100 | 0.102941176470588 | 28 | 0 | 10 | 0 | 236 | 263 | 2707 | 2734 | Monocercomonoides exilis uncharacterized protein (MONOS_8691), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 18193216 | 18193216 | PRJNA1237347_P_NODE_35555_length_1293_cov_5.009836_g31620_i0 | PRJNA1237347 | 35555 | 1293 | 5.009836 | 64.77717948 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 65.8 | 1.7e-5 | NTclustered | gi|2794939762|ref|XM_067864166.1| | 2049356 | g31620 | i0 | 100 | 0.902552204176334 | 35 | 0 | 3 | 0 | 371 | 405 | 4773 | 4739 | Monocercomonoides exilis putative serine/threonine-protein phosphatase 4 regulatory subunit 4 (MONOS_11619), partial mRNA | blastn | 1167 | 65.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 19464425 | 19464425 | PRJNA1237347_P_NODE_194976_length_441_cov_1.361413_g188404_i0 | PRJNA1237347 | 194976 | 441 | 1.361413 | 6.00383133 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 54.7 | 0.012 | NTclustered | gi|2794958897|ref|XM_067862844.1| | 2049356 | g188404 | i0 | 100 | 0.0657596371882086 | 29 | 0 | 7 | 0 | 183 | 211 | 1192 | 1220 | Monocercomonoides exilis aldehyde dehydrogenase (ALDH) (MONOS_10397), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 19470567 | 19470567 | PRJNA1237347_P_NODE_507876_length_247_cov_0.885057_g501303_i0 | PRJNA1237347 | 507876 | 247 | 0.885057 | 2.18609079 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 58.4 | 4.8e-4 | NTclustered | gi|2794941602|ref|XM_067866712.1| | 2049356 | g501303 | i0 | 100 | 2.15789473684211 | 31 | 0 | 13 | 0 | 41 | 71 | 10450 | 10420 | Monocercomonoides exilis putative Translational activator GCN1 (MONOS_13958), partial mRNA | blastn | 533 | 58.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 22018437 | 22018437 | PRJNA1237347_P_NODE_357138_length_299_cov_2.035398_g350565_i0 | PRJNA1237347 | 357138 | 299 | 2.035398 | 6.08584002 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 52.8 | 0.028 | NTclustered | gi|2794945642|ref|XM_067871597.1| | 2049356 | g350565 | i0 | 100 | 0.0936454849498328 | 28 | 0 | 9 | 0 | 272 | 299 | 852 | 825 | Monocercomonoides exilis uncharacterized protein (MONOS_18566), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 24570063 | 24570063 | PRJNA1237347_P_NODE_471300_length_251_cov_1.376404_g464727_i0 | PRJNA1237347 | 471300 | 251 | 1.376404 | 3.45477404 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2794947700|ref|XM_067868657.1| | 2049356 | g464727 | i0 | 100 | 1.36653386454183 | 29 | 0 | 12 | 0 | 133 | 161 | 743 | 715 | Monocercomonoides exilis uncharacterized protein (MONOS_15762), partial mRNA | blastn | 343 | 54.7 | 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);;