contig_metadata
8 rows where bioproject = "PRJNA577580" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9492394 | 9492394 | PRJNA577580_P_NODE_12228_length_265_cov_1.307292_g12150_i0 | PRJNA577580 | 12228 | 265 | 1.307292 | 3.4643238 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 62.1 | 4.02e-5 | NTclustered | gi|2806452230|ref|XM_068501058.1| | 1144522 | g12150 | i0 | 89.583 | 0.520754716981132 | 48 | 5 | 18 | 0 | 217 | 264 | 544 | 591 | Tritrichomonas foetus uncharacterized protein (TRFO_19864), partial mRNA | blastn | 138 | 62.1 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 22241189 | 22241189 | PRJNA577580_P_NODE_8938_length_304_cov_1.718615_g8860_i0 | PRJNA577580 | 8938 | 304 | 1.718615 | 5.2245896 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 147 | 8.68e-40 | NR | AIL82371.1 | 43352 | g8860 | i0 | 65 | 71.0526315789474 | 100 | 35 | 98.7 | 0 | 302 | 3 | 212 | 311 | AIL82371.1 beta-tubulin 2, partial [Dientamoeba fragilis] | diamond | 21600 | 148 | 0.993243243243243 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Dientamoeba | Dientamoeba fragilis | |||
| 26681553 | 26681553 | PRJNA577580_P_NODE_14021_length_251_cov_0.876404_g13943_i0 | PRJNA577580 | 14021 | 251 | 0.876404 | 2.19977404 | root | 1 | Root_unresolved | Root_unresolved | 108 | 3.43e-26 | NR | XP_068360430.1 | 1144522 | g13943 | i0 | 61.7 | 2.85657370517928 | 81 | 31 | 96.8 | 0 | 246 | 4 | 184 | 264 | XP_068360430.1 serine-pyruvate aminotransferase/archaeal aspartate aminotransferase [Tritrichomonas foetus] | diamond | 717 | 109 | 0.990825688073395 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 26890054 | 26890054 | PRJNA577580_P_NODE_5561_length_379_cov_2.215686_g5483_i0 | PRJNA577580 | 5561 | 379 | 2.215686 | 8.39744994 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 60.8 | 7.61e-8 | NR | XP_068358926.1 | 1144522 | g5483 | i0 | 52 | 0.395778364116095 | 50 | 22 | 39.6 | 1 | 356 | 207 | 248 | 295 | XP_068358926.1 uncharacterized protein TRFO_26388 [Tritrichomonas foetus] | diamond | 150 | 60.8 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 27680210 | 27680210 | PRJNA577580_P_NODE_13204_length_255_cov_2.186813_g13126_i0 | PRJNA577580 | 13204 | 255 | 2.186813 | 5.57637315 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 71.6 | 1.66e-12 | NR | XP_067777127.1 | 135588 | g13126 | i0 | 45.8 | 0.976470588235294 | 83 | 43 | 95.3 | 2 | 1 | 243 | 49 | 131 | XP_067777127.1 Calreticulin family protein [Histomonas meleagridis] | diamond | 249 | 71.6 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 27743330 | 27743330 | PRJNA577580_P_NODE_3644_length_472_cov_1.323308_g3566_i0 | PRJNA577580 | 3644 | 472 | 1.323308 | 6.24601376 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 63.5 | 1.62e-9 | NR | XP_067771982.1 | 135588 | g3566 | i0 | 45.9 | 4.91313559322034 | 74 | 38 | 45.8 | 1 | 1 | 216 | 10 | 83 | XP_067771982.1 C2 domain containing protein [Histomonas meleagridis] | diamond | 2319 | 63.9 | 0.993740219092332 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 31659733 | 31659733 | PRJNA577580_P_NODE_12957_length_258_cov_1.448649_g12879_i0 | PRJNA577580 | 12957 | 258 | 1.448649 | 3.73751442 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 44.3 | 0.00961 | NR | XP_001313314.1 | 412133 | g12879 | i0 | 48.5 | 0.383720930232558 | 33 | 17 | 38.4 | 0 | 258 | 160 | 69 | 101 | XP_001313314.1 RNA polymerase II transcription regulator recruiting protein [Trichomonas vaginalis G3] | diamond | 99 | 44.3 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 32811203 | 32811203 | PRJNA577580_P_NODE_7800_length_323_cov_1.608000_g7722_i0 | PRJNA577580 | 7800 | 323 | 1.608 | 5.19384 | root | 1 | Root_unresolved | Root_unresolved | 71.2 | 9.05e-12 | NR | XP_068355675.1 | 1144522 | g7722 | i0 | 39.2 | 4.82043343653251 | 102 | 57 | 94.7 | 3 | 307 | 2 | 143 | 239 | XP_068355675.1 uncharacterized protein TRFO_30261 [Tritrichomonas foetus] | diamond | 1557 | 71.2 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus |
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);;