contig_metadata
8 rows where bioproject = "PRJNA1118794", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18082591 | 18082591 | PRJNA1118794_P_NODE_57755_length_247_cov_1.327586_g57005_i0 | PRJNA1118794 | 57755 | 247 | 1.327586 | 3.27913742 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 60.2 | 1.33e-4 | NTclustered | gi|2806485738|ref|XM_068512807.1| | 1144522 | g57005 | i0 | 97.143 | 0.1417004048583 | 35 | 1 | 14 | 0 | 174 | 208 | 565 | 599 | Tritrichomonas foetus uncharacterized protein (TRFO_39733), partial mRNA | blastn | 35 | 60.2 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 20631411 | 20631411 | PRJNA1118794_P_NODE_12057_length_412_cov_1.752212_g11308_i0 | PRJNA1118794 | 12057 | 412 | 1.752212 | 7.21911344 | Tritrichomonadida | 740972 | Parabasalia | other_Eukaryota | 107 | 4.6899999999999996e-24 | NR | XP_068366445.1 | 1144522 | g11308 | i0 | 54.7 | 4.04126213592233 | 106 | 47 | 77.2 | 1 | 94 | 411 | 11 | 115 | XP_068366445.1 enolase family protein [Tritrichomonas foetus] | diamond | 1665 | 108 | 0.990740740740741 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 26656287 | 26656287 | PRJNA1118794_P_NODE_19781_length_340_cov_1.153558_g19031_i0 | PRJNA1118794 | 19781 | 340 | 1.153558 | 3.9220972 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 111 | 1.09e-25 | NR | XP_067779618.1 | 135588 | g19031 | i0 | 53.6 | 4.94117647058824 | 112 | 46 | 98.8 | 2 | 1 | 336 | 688 | 793 | XP_067779618.1 glycogen phosphorylase [Histomonas meleagridis] | diamond | 1680 | 111 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 26751164 | 26751164 | PRJNA1118794_P_NODE_10121_length_444_cov_1.539084_g9373_i0 | PRJNA1118794 | 10121 | 444 | 1.539084 | 6.83353296 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 106 | 4.51e-26 | NR | XP_067768974.1 | 135588 | g9373 | i0 | 46.5 | 4.37162162162162 | 127 | 52 | 85.8 | 2 | 440 | 60 | 35 | 145 | XP_067768974.1 ribosomal protein S19e [Histomonas meleagridis] | diamond | 1941 | 106 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 27605348 | 27605348 | PRJNA1118794_P_NODE_67164_length_243_cov_1.647059_g66414_i0 | PRJNA1118794 | 67164 | 243 | 1.647059 | 4.00235337 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 43.5 | 0.0134 | NR | XP_067774273.1 | 135588 | g66414 | i0 | 38.5 | 0.802469135802469 | 65 | 34 | 79 | 2 | 21 | 212 | 5 | 64 | XP_067774273.1 40S ribosomal protein S7 [Histomonas meleagridis] | diamond | 195 | 43.5 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 31015899 | 31015899 | PRJNA1118794_P_NODE_50815_length_250_cov_1.192090_g50065_i0 | PRJNA1118794 | 50815 | 250 | 1.19209 | 2.980225 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 65.1 | 3.9e-11 | NR | XP_001325625.1 | 412133 | g50065 | i0 | 38.6 | 0.996 | 83 | 51 | 99.6 | 0 | 1 | 249 | 45 | 127 | XP_001325625.1 Rho GDP-dissociation inhibitor protein [Trichomonas vaginalis G3] | diamond | 249 | 65.1 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 31079233 | 31079233 | PRJNA1118794_P_NODE_27095_length_304_cov_1.662338_g26345_i0 | PRJNA1118794 | 27095 | 304 | 1.662338 | 5.05350752 | Devescovina sp. Nk9 | 336692 | Parabasalia | other_Eukaryota | 121 | 5.91e-31 | NR | BAF48680.1 | 336692 | g26345 | i0 | 54 | 1.98355263157895 | 100 | 43 | 98.7 | 1 | 2 | 301 | 228 | 324 | BAF48680.1 enolase, partial [Devescovina sp. Nk9] | diamond | 603 | 121 | 1 | Eukaryota | Metamonada | Parabasalia | Cristamonadida | Devescovina | Devescovina sp. Nk9 | ||||
| 32059542 | 32059542 | PRJNA1118794_P_NODE_67818_length_243_cov_0.905882_g67068_i0 | PRJNA1118794 | 67818 | 243 | 0.905882 | 2.20129326 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 81.3 | 6.5e-17 | NR | XP_068360805.1 | 1144522 | g67068 | i0 | 44.3 | 6.82716049382716 | 79 | 43 | 96.3 | 1 | 235 | 2 | 73 | 151 | XP_068360805.1 Ras-related protein Rab-4B [Tritrichomonas foetus] | diamond | 1659 | 81.3 | 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);;