contig_metadata
12 rows where bioproject = "PRJNA515078" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10690567 | 10690567 | PRJNA515078_P_NODE_16609_length_214_cov_1.322034_g16376_i0 | PRJNA515078 | 16609 | 214 | 1.322034 | 2.82915276 | root | 1 | Root_unresolved | Root_unresolved | 91.3 | 4.860000000000001e-21 | NR | XP_001579633.1 | 412133 | g16376 | i0 | 75 | 8.81775700934579 | 56 | 14 | 78.5 | 0 | 212 | 45 | 129 | 184 | XP_001579633.1 peptidyl-prolyl cis-trans isomerase protein [Trichomonas vaginalis G3] | diamond | 1887 | 91.7 | 0.995637949836423 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 11965595 | 11965595 | PRJNA515078_P_NODE_25710_length_171_cov_1.828358_g25477_i0 | PRJNA515078 | 25710 | 171 | 1.828358 | 3.12649218 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 74.3 | 3.23e-15 | NR | XP_068349968.1 | 1144522 | g25477 | i0 | 70.5 | 2.96491228070175 | 44 | 13 | 77.2 | 0 | 169 | 38 | 67 | 110 | XP_068349968.1 NHP2-like protein 1 [Tritrichomonas foetus] | diamond | 507 | 74.3 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 12589894 | 12589894 | PRJNA515078_P_NODE_23910_length_177_cov_2.228571_g23677_i0 | PRJNA515078 | 23910 | 177 | 2.228571 | 3.94457067 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 126 | 8.69e-25 | NTclustered | gi|2587729139|gb|OR478975.1| | 56777 | g23677 | i0 | 81.29 | 29.5819209039548 | 155 | 29 | 88 | 0 | 16 | 170 | 773 | 619 | Trichomonas gallinae elongation factor 1 alpha (EF1A) mRNA, complete cds | blastn | 5236 | 126 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas gallinae | |||
| 19612831 | 19612831 | PRJNA515078_P_NODE_16256_length_216_cov_1.960894_g16023_i0 | PRJNA515078 | 16256 | 216 | 1.960894 | 4.23553104 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|2806440984|ref|XM_068497330.1| | 1144522 | g16023 | i0 | 100 | 0.138888888888889 | 30 | 0 | 14 | 0 | 177 | 206 | 242 | 213 | Tritrichomonas foetus uncharacterized protein (TRFO_13569), partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 26776238 | 26776238 | PRJNA515078_P_NODE_11401_length_265_cov_1.710526_g11168_i0 | PRJNA515078 | 11401 | 265 | 1.710526 | 4.5328939 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 76.3 | 7.5e-15 | NR | XP_067773256.1 | 135588 | g11168 | i0 | 42.5 | 1.94716981132075 | 87 | 47 | 98.5 | 1 | 3 | 263 | 64 | 147 | XP_067773256.1 Ras-related protein Rab-13 [Histomonas meleagridis] | diamond | 516 | 76.6 | 0.996083550913838 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 26982261 | 26982261 | PRJNA515078_P_NODE_27762_length_165_cov_1.539062_g27529_i0 | PRJNA515078 | 27762 | 165 | 1.539062 | 2.5394523 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 79 | 2.02e-15 | NR | XP_001329670.1 | 412133 | g27529 | i0 | 63 | 0.981818181818182 | 54 | 20 | 98.2 | 0 | 164 | 3 | 256 | 309 | XP_001329670.1 zinc finger protein ZPR1 family [Trichomonas vaginalis G3] | diamond | 162 | 79 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 27108591 | 27108591 | PRJNA515078_P_NODE_33682_length_152_cov_1.017391_g33449_i0 | PRJNA515078 | 33682 | 152 | 1.017391 | 1.54643432 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 52.4 | 4.25e-6 | NR | XP_067773710.1 | 135588 | g33449 | i0 | 51 | 3.86842105263158 | 49 | 24 | 96.7 | 0 | 149 | 3 | 1004 | 1052 | XP_067773710.1 putative alpha-actinin [Histomonas meleagridis] | diamond | 588 | 52.4 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 27408894 | 27408894 | PRJNA515078_P_NODE_24943_length_174_cov_1.138686_g24710_i0 | PRJNA515078 | 24943 | 174 | 1.138686 | 1.98131364 | root | 1 | Root_unresolved | Root_unresolved | 48.5 | 8.88e-5 | NR | XP_001310136.1 | 412133 | g24710 | i0 | 42.1 | 3.25862068965517 | 57 | 33 | 98.3 | 0 | 174 | 4 | 78 | 134 | XP_001310136.1 small Rab GTPase RabA2 [Trichomonas vaginalis G3] | diamond | 567 | 48.5 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 27772374 | 27772374 | PRJNA515078_P_NODE_31304_length_157_cov_0.975000_g31071_i0 | PRJNA515078 | 31304 | 157 | 0.975 | 1.53075 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 46.2 | 4.38e-4 | NR | XP_001310100.1 | 412133 | g31071 | i0 | 61.3 | 6.51592356687898 | 31 | 12 | 59.2 | 0 | 119 | 27 | 30 | 60 | XP_001310100.1 ankyrin repeat protein family [Trichomonas vaginalis G3] | diamond | 1023 | 46.2 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 28671719 | 28671719 | PRJNA515078_P_NODE_29207_length_161_cov_1.887097_g28974_i0 | PRJNA515078 | 29207 | 161 | 1.887097 | 3.03822617 | root | 1 | Root_unresolved | Root_unresolved | 60.5 | 9.69e-10 | NR | XP_001317004.1 | 412133 | g28974 | i0 | 80.6 | 2.36645962732919 | 31 | 6 | 57.8 | 0 | 6 | 98 | 114 | 144 | XP_001317004.1 Chain X 40s Ribosomal Protein S23 [Trichomonas vaginalis G3] | diamond | 381 | 60.8 | 0.995065789473684 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 29824282 | 29824282 | PRJNA515078_P_NODE_19051_length_199_cov_1.203704_g18818_i0 | PRJNA515078 | 19051 | 199 | 1.203704 | 2.39537096 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 79.7 | 1.25e-15 | NR | XP_001327672.1 | 412133 | g18818 | i0 | 53.8 | 1.95979899497487 | 65 | 30 | 98 | 0 | 1 | 195 | 193 | 257 | XP_001327672.1 STKc CK1 domain-containing protein [Trichomonas vaginalis G3] | diamond | 390 | 79.7 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 31973759 | 31973759 | PRJNA515078_P_NODE_27278_length_167_cov_0.900000_g27045_i0 | PRJNA515078 | 27278 | 167 | 0.9 | 1.503 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 44.7 | 0.00281 | NR | XP_068354914.1 | 1144522 | g27045 | i0 | 38.2 | 0.988023952095808 | 55 | 34 | 98.8 | 0 | 166 | 2 | 94 | 148 | XP_068354914.1 Protein SEY1 3 [Tritrichomonas foetus] | diamond | 165 | 44.7 | 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);;