contig_metadata
12 rows where bioproject = "PRJNA928559", tax_clade = "Metamonada" and tax_phylum = "Fornicata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27600864 | 27600864 | PRJNA928559_P_NODE_125904_length_317_cov_1.278689_g124335_i0 | PRJNA928559 | 125904 | 317 | 1.278689 | 4.05344413 | root | 1 | Root_unresolved | Root_unresolved | 61.2 | 2.88e-8 | NR | TNJ26324.1 | 5742 | g124335 | i0 | 46.6 | 5.62145110410095 | 58 | 31 | 54.9 | 0 | 246 | 73 | 83 | 140 | TNJ26324.1 Glycogen phosphorylase [Giardia muris] | diamond | 1782 | 61.6 | 0.993506493506494 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 28548131 | 28548131 | PRJNA928559_P_NODE_140647_length_298_cov_2.000000_g139078_i0 | PRJNA928559 | 140647 | 298 | 2 | 5.96 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 46.6 | 0.00315 | NR | XP_001708419.2 | 5741 | g139078 | i0 | 45.3 | 4.42953020134228 | 75 | 33 | 68.5 | 3 | 5 | 208 | 407 | 480 | XP_001708419.2 High cysteine membrane protein Group 6 [Giardia intestinalis] | diamond | 1320 | 46.6 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 28919428 | 28919428 | PRJNA928559_P_NODE_144488_length_294_cov_1.058824_g142919_i0 | PRJNA928559 | 144488 | 294 | 1.058824 | 3.11294256 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 53.5 | 1.1e-5 | NR | ESU42289.1 | 5741 | g142919 | i0 | 39.8 | 3.22448979591837 | 108 | 51 | 96.9 | 5 | 290 | 6 | 77 | 183 | ESU42289.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 948 | 53.5 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 29495128 | 29495128 | PRJNA928559_P_NODE_180570_length_258_cov_3.643243_g179001_i0 | PRJNA928559 | 180570 | 258 | 3.643243 | 9.39956694 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 110 | 6.29e-26 | NR | TNJ28992.1 | 5742 | g179001 | i0 | 64 | 14.546511627907 | 75 | 27 | 87.2 | 0 | 241 | 17 | 8 | 82 | TNJ28992.1 RNase L inhibitor [Giardia muris] | diamond | 3753 | 111 | 0.990990990990991 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 29582366 | 29582366 | PRJNA928559_P_NODE_206610_length_245_cov_1.162791_g205041_i0 | PRJNA928559 | 206610 | 245 | 1.162791 | 2.84883795 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 62.8 | 3.36e-9 | NR | KAG9394971.1 | 201153 | g205041 | i0 | 56.5 | 0.563265306122449 | 46 | 20 | 56.3 | 0 | 138 | 1 | 99 | 144 | KAG9394971.1 DNA topoisomerase 3 beta [Carpediemonas membranifera] | diamond | 138 | 62.8 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 30719818 | 30719818 | PRJNA928559_P_NODE_134754_length_305_cov_2.525862_g133185_i0 | PRJNA928559 | 134754 | 305 | 2.525862 | 7.7038791 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 90.5 | 1.34e-18 | NR | GKT35572.1 | 2918883 | g133185 | i0 | 58.8 | 5.80327868852459 | 68 | 27 | 65.9 | 1 | 104 | 304 | 386 | 453 | GKT35572.1 Isoleucine--tRNA ligase, cytoplasmic [Aduncisulcus paluster] | diamond | 1770 | 90.5 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 30751557 | 30751557 | PRJNA928559_P_NODE_128054_length_314_cov_1.489627_g126485_i0 | PRJNA928559 | 128054 | 314 | 1.489627 | 4.67742878 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 66.6 | 3.65e-10 | NR | GIQ80742.1 | 797122 | g126485 | i0 | 41 | 0.745222929936306 | 78 | 46 | 74.5 | 0 | 65 | 298 | 938 | 1015 | GIQ80742.1 dynein heavy chain [Kipferlia bialata] | diamond | 234 | 66.6 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 30814677 | 30814677 | PRJNA928559_P_NODE_192054_length_251_cov_1.494382_g190485_i0 | PRJNA928559 | 192054 | 251 | 1.494382 | 3.75089882 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 44.3 | 0.00806 | NR | ESU37843.1 | 5741 | g190485 | i0 | 37 | 2.199203187251 | 46 | 26 | 55 | 1 | 217 | 80 | 68 | 110 | ESU37843.1 Variant-specific surface protein, partial [Giardia intestinalis] | diamond | 552 | 44.3 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 30853438 | 30853438 | PRJNA928559_P_NODE_204054_length_246_cov_1.381503_g202485_i0 | PRJNA928559 | 204054 | 246 | 1.381503 | 3.39849738 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 132 | 6.23e-34 | NR | KAG9389646.1 | 201153 | g202485 | i0 | 71.8 | 2.8780487804878 | 78 | 22 | 95.1 | 0 | 244 | 11 | 427 | 504 | KAG9389646.1 Phenylalanyl-tRNA synthetase, class IIc, alpha subunit [Carpediemonas membranifera] | diamond | 708 | 133 | 0.992481203007519 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 31707050 | 31707050 | PRJNA928559_P_NODE_115477_length_332_cov_0.980695_g113908_i0 | PRJNA928559 | 115477 | 332 | 0.980695 | 3.2559074 | root | 1 | Root_unresolved | Root_unresolved | 113 | 2.49e-27 | NR | CAK8773861.1 | 28002 | g113908 | i0 | 50.5 | 14.9548192771084 | 109 | 53 | 97.6 | 1 | 1 | 324 | 191 | 299 | CAK8773861.1 HINF_055388 [Hexamita inflata] | diamond | 4965 | 114 | 0.991228070175439 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 31763102 | 31763102 | PRJNA928559_P_NODE_129857_length_311_cov_5.252101_g128288_i0 | PRJNA928559 | 129857 | 311 | 5.252101 | 16.33403411 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 81.3 | 1.66e-15 | NR | CAK8746233.1 | 28002 | g128288 | i0 | 41.1 | 1.83279742765273 | 95 | 56 | 91.6 | 0 | 286 | 2 | 1 | 95 | CAK8746233.1 HINF_020048 [Hexamita inflata] | diamond | 570 | 81.3 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 31833400 | 31833400 | PRJNA928559_P_NODE_149377_length_288_cov_2.213953_g147808_i0 | PRJNA928559 | 149377 | 288 | 2.213953 | 6.37618464 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 45.1 | 0.00955 | NR | XP_001708033.1 | 5741 | g147808 | i0 | 34.7 | 1.80208333333333 | 95 | 44 | 87.5 | 2 | 260 | 9 | 303 | 390 | XP_001708033.1 VSP [Giardia intestinalis] | diamond | 519 | 45.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis |
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);;