contig_metadata
10 rows where bioproject = "PRJNA980587", tax_clade = "Metamonada" and tax_phylum = "Parabasalia"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26962736 | 26962736 | PRJNA980587_P_NODE_10582_length_851_cov_9.611825_g9896_i0 | PRJNA980587 | 10582 | 851 | 9.611825 | 81.79663075 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 182 | 2.299999999999999e-53 | NR | XP_001299092.1 | 412133 | g9896 | i0 | 46.2 | 0.694477085781434 | 197 | 101 | 69.1 | 3 | 793 | 206 | 3 | 195 | XP_001299092.1 peroxiredoxin protein [Trichomonas vaginalis G3] | diamond | 591 | 182 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 28068489 | 28068489 | PRJNA980587_P_NODE_24065_length_507_cov_2.032258_g23274_i0 | PRJNA980587 | 24065 | 507 | 2.032258 | 10.30354806 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 75.5 | 1.05e-12 | NR | XP_067777444.1 | 135588 | g23274 | i0 | 71.9 | 2.63905325443787 | 57 | 16 | 33.7 | 0 | 451 | 281 | 5 | 61 | XP_067777444.1 LysM peptidoglycan-binding domain-containing protein [Histomonas meleagridis] | diamond | 1338 | 75.5 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 29741699 | 29741699 | PRJNA980587_P_NODE_94090_length_241_cov_1.809524_g93297_i0 | PRJNA980587 | 94090 | 241 | 1.809524 | 4.36095284 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 47.8 | 6.01e-4 | NR | XP_001322334.1 | 412133 | g93297 | i0 | 32.5 | 0.995850622406639 | 80 | 53 | 98.3 | 1 | 5 | 241 | 268 | 347 | XP_001322334.1 G-protein beta/gamma-subunit complex binding [Trichomonas vaginalis G3] | diamond | 240 | 47.8 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 30689590 | 30689590 | PRJNA980587_P_NODE_57133_length_302_cov_1.344978_g56340_i0 | PRJNA980587 | 57133 | 302 | 1.344978 | 4.06183356 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 68.6 | 5.81e-11 | NR | XP_067774855.1 | 135588 | g56340 | i0 | 49.3 | 2.66225165562914 | 67 | 34 | 66.6 | 0 | 101 | 301 | 170 | 236 | XP_067774855.1 Guanine nucleotide-binding protein alpha-1 subunit [Histomonas meleagridis] | diamond | 804 | 68.6 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 30879233 | 30879233 | PRJNA980587_P_NODE_87634_length_245_cov_1.598837_g86841_i0 | PRJNA980587 | 87634 | 245 | 1.598837 | 3.91715065 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 54.3 | 3.24e-6 | NR | XP_067775293.1 | 135588 | g86841 | i0 | 34.3 | 1.55510204081633 | 70 | 46 | 85.7 | 0 | 31 | 240 | 2 | 71 | XP_067775293.1 calcium-translocating P-type ATPase, PMCA-type family protein [Histomonas meleagridis] | diamond | 381 | 54.3 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 30911047 | 30911047 | PRJNA980587_P_NODE_95514_length_241_cov_0.916667_g94721_i0 | PRJNA980587 | 95514 | 241 | 0.916667 | 2.20916747 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 41.6 | 0.0242 | NR | XP_067772483.1 | 135588 | g94721 | i0 | 32.7 | 0.684647302904564 | 55 | 37 | 68.5 | 0 | 220 | 56 | 1 | 55 | XP_067772483.1 MORN repeat-containing protein 5 isoform X1 [Histomonas meleagridis] | diamond | 165 | 41.6 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 30974189 | 30974189 | PRJNA980587_P_NODE_25114_length_494_cov_2.116390_g24323_i0 | PRJNA980587 | 25114 | 494 | 2.11639 | 10.4549666 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 189 | 7.59e-58 | NR | XP_068360038.1 | 1144522 | g24323 | i0 | 58.8 | 8.81174089068826 | 160 | 66 | 97.2 | 0 | 482 | 3 | 5 | 164 | XP_068360038.1 40S ribosomal protein S9-1 [Tritrichomonas foetus] | diamond | 4353 | 189 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 31232783 | 31232783 | PRJNA980587_P_NODE_94955_length_241_cov_0.916667_g94162_i0 | PRJNA980587 | 94955 | 241 | 0.916667 | 2.20916747 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 58.5 | 9.67e-8 | NR | XP_068350514.1 | 1144522 | g94162 | i0 | 43.3 | 3.78423236514523 | 67 | 35 | 83.4 | 2 | 234 | 34 | 104 | 167 | XP_068350514.1 uncharacterized protein TRFO_36378 [Tritrichomonas foetus] | diamond | 912 | 58.9 | 0.99320882852292 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 31359634 | 31359634 | PRJNA980587_P_NODE_6536_length_1117_cov_9.611111_g6000_i0 | PRJNA980587 | 6536 | 1117 | 9.611111 | 107.35610987 | root | 1 | Root_unresolved | Root_unresolved | 151 | 2.5499999999999998e-40 | NR | XP_001299092.1 | 412133 | g6000 | i0 | 43.5 | 12.8084153983885 | 193 | 100 | 50.2 | 5 | 918 | 358 | 3 | 192 | XP_001299092.1 peroxiredoxin protein [Trichomonas vaginalis G3] | diamond | 14307 | 151 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 31416660 | 31416660 | PRJNA980587_P_NODE_75136_length_258_cov_1.367568_g74343_i0 | PRJNA980587 | 75136 | 258 | 1.367568 | 3.52832544 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 62.8 | 3.99e-9 | NR | XP_001309937.1 | 412133 | g74343 | i0 | 47.1 | 1.86046511627907 | 70 | 36 | 81.4 | 1 | 47 | 256 | 875 | 943 | XP_001309937.1 C2 domain-containing protein family [Trichomonas vaginalis G3] | diamond | 480 | 62.8 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis |
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);;