contig_metadata
15 rows where bioproject = "PRJNA222400" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2331795 | 2331795 | PRJNA222400_P_NODE_1902_length_367_cov_1.364780_g1869_i0 | PRJNA222400 | 1902 | 367 | 1.36478 | 5.0087426 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 237 | 8.960000000000001e-58 | NTclustered | gi|339759377|dbj|AB600301.1| | 926446 | g1869 | i0 | 82.836 | 70.141689373297 | 268 | 43 | 72 | 3 | 26 | 291 | 1013 | 1279 | Ergobibamus cyprinoides gene for beta-tubulin, partial cds, strain: CL | blastn | 25742 | 237 | 1 | Eukaryota | Metamonada | Fornicata | Ergobibamus | Ergobibamus cyprinoides | |||||
| 18218835 | 18218835 | PRJNA222400_P_NODE_2255_length_330_cov_1.590747_g2222_i0 | PRJNA222400 | 2255 | 330 | 1.590747 | 5.2494651 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 62.4 | 1.27e-8 | NR | KAJ5075220.1 | 1746090 | g2222 | i0 | 34 | 0.963636363636364 | 106 | 68 | 94.5 | 1 | 312 | 1 | 269 | 374 | KAJ5075220.1 bypass of stop codon protein [Anaeramoeba ignava] | diamond | 318 | 62.4 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 26852727 | 26852727 | PRJNA222400_P_NODE_3841_length_228_cov_1.162011_g3808_i0 | PRJNA222400 | 3841 | 228 | 1.162011 | 2.64938508 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 77 | 9.8e-16 | NR | GKT27622.1 | 2918883 | g3808 | i0 | 76.2 | 4.97368421052632 | 42 | 10 | 55.3 | 0 | 228 | 103 | 109 | 150 | GKT27622.1 Ribosomal protein S11 like protein [Aduncisulcus paluster] | diamond | 1134 | 77 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 27281522 | 27281522 | PRJNA222400_P_NODE_8383_length_165_cov_0.896552_g8350_i0 | PRJNA222400 | 8383 | 165 | 0.896552 | 1.4793108 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.8 | 4.68e-7 | NR | KAJ3430788.1 | 1746091 | g8350 | i0 | 55.6 | 3.90909090909091 | 36 | 16 | 65.5 | 0 | 2 | 109 | 69 | 104 | KAJ3430788.1 duf614 family protein-related [Anaeramoeba flamelloides] | diamond | 645 | 52.8 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba flamelloides | |||||
| 28179155 | 28179155 | PRJNA222400_P_NODE_7946_length_166_cov_1.777778_g7913_i0 | PRJNA222400 | 7946 | 166 | 1.777778 | 2.95111148 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 63.9 | 1.82e-10 | NR | KAJ4461374.1 | 342808 | g7913 | i0 | 53.7 | 1.95180722891566 | 54 | 25 | 97.6 | 0 | 5 | 166 | 105 | 158 | KAJ4461374.1 putative tyrosine phosphatase [Paratrimastix pyriformis] | diamond | 324 | 63.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28779186 | 28779186 | PRJNA222400_P_NODE_4667_length_206_cov_1.299363_g4634_i0 | PRJNA222400 | 4667 | 206 | 1.299363 | 2.67668778 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 79.7 | 5.19e-18 | NR | CAK8746335.1 | 28002 | g4634 | i0 | 72 | 1.45631067961165 | 50 | 13 | 72.8 | 1 | 206 | 57 | 5 | 53 | CAK8746335.1 HINF_020184 [Hexamita inflata] | diamond | 300 | 79.7 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 29032135 | 29032135 | PRJNA222400_P_NODE_3848_length_228_cov_1.089385_g3815_i0 | PRJNA222400 | 3848 | 228 | 1.089385 | 2.4837978 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 90.9 | 3.2e-19 | NR | KAJ4461998.1 | 342808 | g3815 | i0 | 54.1 | 0.973684210526316 | 74 | 34 | 97.4 | 0 | 225 | 4 | 270 | 343 | KAJ4461998.1 putative Glycoside hydrolase [Paratrimastix pyriformis] | diamond | 222 | 90.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 29158395 | 29158395 | PRJNA222400_P_NODE_9469_length_162_cov_0.884956_g9436_i0 | PRJNA222400 | 9469 | 162 | 0.884956 | 1.43362872 | Anaeramoeba flamelloides | 1746091 | Root_unresolved | Root_unresolved | 49.3 | 5.99e-5 | NR | KAJ3423664.1 | 1746091 | g9436 | i0 | 43.1 | 4.11111111111111 | 58 | 26 | 94.4 | 2 | 154 | 2 | 1471 | 1528 | KAJ3423664.1 hypothetical protein M0812_30198 [Anaeramoeba flamelloides] | diamond | 666 | 49.3 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba flamelloides | |||||
| 29821016 | 29821016 | PRJNA222400_P_NODE_11_length_2336_cov_7.012243_g10_i0 | PRJNA222400 | 11 | 2336 | 7.012243 | 163.80599648 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 52.4 | 0.0126 | NR | GIQ80334.1 | 797122 | g10 | i0 | 27.3 | 0.263270547945205 | 205 | 129 | 24 | 7 | 660 | 1220 | 719 | 921 | GIQ80334.1 hypothetical protein KIPB_001114, partial [Kipferlia bialata] | diamond | 615 | 52.4 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 30042352 | 30042352 | PRJNA222400_P_NODE_411_length_783_cov_2.935967_g386_i0 | PRJNA222400 | 411 | 783 | 2.935967 | 22.98862161 | Paratrimastix eleionoma | 1709329 | Preaxostyla | other_Eukaryota | 151 | 2.8e-42 | NR | WCZ58434.1 | 1709329 | g386 | i0 | 61.1 | 4.05747126436782 | 126 | 48 | 48.3 | 1 | 24 | 401 | 1 | 125 | WCZ58434.1 translation initiation factor 1A [Paratrimastix eleionoma] | diamond | 3177 | 151 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix eleionoma | ||||
| 30073842 | 30073842 | PRJNA222400_P_NODE_6592_length_175_cov_1.238095_g6559_i0 | PRJNA222400 | 6592 | 175 | 1.238095 | 2.16666625 | Anaeramoeba flamelloides | 1746091 | Root_unresolved | Root_unresolved | 76.6 | 1.6e-14 | NR | KAJ3445196.1 | 1746091 | g6559 | i0 | 54.4 | 1.92 | 57 | 26 | 97.7 | 0 | 173 | 3 | 118 | 174 | KAJ3445196.1 beta-hexosaminidase [Anaeramoeba flamelloides] | diamond | 336 | 76.6 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba flamelloides | |||||
| 30516293 | 30516293 | PRJNA222400_P_NODE_2693_length_292_cov_3.304527_g2660_i0 | PRJNA222400 | 2693 | 292 | 3.304527 | 9.64921884 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 42.7 | 0.0145 | NR | XP_067729760.1 | 2049356 | g2660 | i0 | 40 | 1.4486301369863 | 75 | 44 | 77.1 | 1 | 250 | 26 | 20 | 93 | XP_067729760.1 uncharacterized protein MONOS_12776 [Monocercomonoides exilis] | diamond | 423 | 42.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 30976562 | 30976562 | PRJNA222400_P_NODE_574_length_677_cov_2.957006_g544_i0 | PRJNA222400 | 574 | 677 | 2.957006 | 20.01893062 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 199 | 1.8199999999999998e-60 | NR | GIQ80663.1 | 797122 | g544 | i0 | 52.8 | 1.71491875923191 | 193 | 88 | 84.2 | 2 | 1 | 570 | 33 | 225 | GIQ80663.1 glycoside hydrolase, family 25 [Kipferlia bialata] | diamond | 1161 | 200 | 0.995 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 31337850 | 31337850 | PRJNA222400_P_NODE_5736_length_187_cov_1.666667_g5703_i0 | PRJNA222400 | 5736 | 187 | 1.666667 | 3.11666729 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 42 | 0.0298 | NR | KAA6386700.1 | 222440 | g5703 | i0 | 39.6 | 0.850267379679144 | 53 | 32 | 85 | 0 | 179 | 21 | 162 | 214 | KAA6386700.1 MAG: putative Vesicle-associated membrane protein 7B [Streblomastix strix] | diamond | 159 | 42 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 32886400 | 32886400 | PRJNA222400_P_NODE_8620_length_164_cov_1.356522_g8587_i0 | PRJNA222400 | 8620 | 164 | 1.356522 | 2.22469608 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 57.4 | 8.29e-8 | NR | KAJ5079609.1 | 1746090 | g8587 | i0 | 54.2 | 1.59146341463415 | 48 | 22 | 87.8 | 0 | 8 | 151 | 1 | 48 | KAJ5079609.1 mob kinase activator-like 1 [Anaeramoeba ignava] | diamond | 261 | 57.4 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava |
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);;