contig_metadata
13 rows where bioproject = "PRJNA914897" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3445861 | 3445861 | PRJNA914897_P_NODE_40763_length_244_cov_0.900585_g40339_i0 | PRJNA914897 | 40763 | 244 | 0.900585 | 2.1974274 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2794864682|ref|XM_067915492.1| | 135588 | g40339 | i0 | 96.875 | 0.131147540983607 | 32 | 1 | 13 | 0 | 81 | 112 | 1228 | 1197 | Histomonas meleagridis uncharacterized protein (GO595_002568), partial mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 21296923 | 21296923 | PRJNA914897_P_NODE_3537_length_1059_cov_17.332657_g3264_i0 | PRJNA914897 | 3537 | 1059 | 17.332657 | 183.55283763 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 62.1 | 1.79e-4 | NTclustered | gi|2806442743|ref|XM_068514405.1| | 1144522 | g3264 | i0 | 88.462 | 0.0840415486307838 | 52 | 5 | 5 | 1 | 885 | 935 | 839 | 890 | Tritrichomonas foetus Digestive cysteine proteinase 1 (LCP1), partial mRNA | blastn | 89 | 62.1 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 26842239 | 26842239 | PRJNA914897_P_NODE_40641_length_244_cov_1.169591_g40217_i0 | PRJNA914897 | 40641 | 244 | 1.169591 | 2.85380204 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 73.9 | 4.89e-14 | NR | BEJ44982.1 | 63628 | g40217 | i0 | 49.2 | 5.55737704918033 | 61 | 31 | 75 | 0 | 9 | 191 | 136 | 196 | BEJ44982.1 CAMK family protein kinase, partial [Trichonympha agilis] | diamond | 1356 | 73.9 | 1 | Eukaryota | Metamonada | Parabasalia | Trichonymphida | Trichonymphidae | Trichonympha | Trichonympha agilis | |||
| 27056216 | 27056216 | PRJNA914897_P_NODE_18382_length_401_cov_2.579268_g17960_i0 | PRJNA914897 | 18382 | 401 | 2.579268 | 10.34286468 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 71.2 | 7.98e-12 | NR | XP_067769155.1 | 135588 | g17960 | i0 | 49.3 | 0.531172069825436 | 71 | 35 | 53.1 | 1 | 48 | 260 | 2 | 71 | XP_067769155.1 autophagocytosis associated protein [Histomonas meleagridis] | diamond | 213 | 71.2 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 27561425 | 27561425 | PRJNA914897_P_NODE_17984_length_407_cov_1.137725_g17562_i0 | PRJNA914897 | 17984 | 407 | 1.137725 | 4.63054075 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 48.5 | 0.00206 | NR | XP_068366651.1 | 1144522 | g17562 | i0 | 29 | 0.737100737100737 | 100 | 56 | 62.7 | 2 | 151 | 405 | 207 | 306 | XP_068366651.1 uncharacterized protein TRFO_16275 [Tritrichomonas foetus] | diamond | 300 | 48.5 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 29235161 | 29235161 | PRJNA914897_P_NODE_19289_length_388_cov_1.457143_g18867_i0 | PRJNA914897 | 19289 | 388 | 1.457143 | 5.65371484 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 55.8 | 3.94e-6 | NR | XP_001306733.1 | 412133 | g18867 | i0 | 34 | 0.819587628865979 | 106 | 66 | 82 | 2 | 2 | 319 | 195 | 296 | XP_001306733.1 Ankyrin repeat family [Trichomonas vaginalis G3] | diamond | 318 | 55.8 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 30404130 | 30404130 | PRJNA914897_P_NODE_11413_length_548_cov_2.033684_g10993_i0 | PRJNA914897 | 11413 | 548 | 2.033684 | 11.14458832 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 59.7 | 2.35e-7 | NR | XP_001301812.1 | 412133 | g10993 | i0 | 31.8 | 0.81021897810219 | 148 | 96 | 79.4 | 5 | 111 | 545 | 4 | 149 | XP_001301812.1 small Rab GTPase Rab6b [Trichomonas vaginalis G3] | diamond | 444 | 59.7 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 30498503 | 30498503 | PRJNA914897_P_NODE_10653_length_573_cov_1.544000_g10234_i0 | PRJNA914897 | 10653 | 573 | 1.544 | 8.84712 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 63.9 | 4.81e-8 | NR | XP_068362867.1 | 1144522 | g10234 | i0 | 30.6 | 0.649214659685864 | 124 | 76 | 61.8 | 4 | 166 | 519 | 2560 | 2679 | XP_068362867.1 uncharacterized protein TRFO_21244 [Tritrichomonas foetus] | diamond | 372 | 63.9 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 30758650 | 30758650 | PRJNA914897_P_NODE_23354_length_342_cov_0.855019_g22930_i0 | PRJNA914897 | 23354 | 342 | 0.855019 | 2.92416498 | root | 1 | Root_unresolved | Root_unresolved | 45.4 | 0.0125 | NR | XP_068366899.1 | 1144522 | g22930 | i0 | 51.2 | 1.7280701754386 | 41 | 19 | 35.1 | 1 | 154 | 273 | 11 | 51 | XP_068366899.1 CAMK family protein kinase [Tritrichomonas foetus] | diamond | 591 | 45.4 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 32332760 | 32332760 | PRJNA914897_P_NODE_29239_length_293_cov_1.400000_g28815_i0 | PRJNA914897 | 29239 | 293 | 1.4 | 4.102 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 111 | 2.38e-26 | NR | XP_067778970.1 | 135588 | g28815 | i0 | 50.5 | 0.993174061433447 | 97 | 46 | 99.3 | 1 | 292 | 2 | 293 | 387 | XP_067778970.1 AGC family protein kinase [Histomonas meleagridis] | diamond | 291 | 111 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 32554209 | 32554209 | PRJNA914897_P_NODE_34299_length_263_cov_1.589474_g33875_i0 | PRJNA914897 | 34299 | 263 | 1.589474 | 4.18031662 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 68.9 | 1.64e-11 | NR | XP_001320953.1 | 412133 | g33875 | i0 | 38.4 | 3.87832699619772 | 86 | 52 | 98.1 | 1 | 261 | 4 | 70 | 154 | XP_001320953.1 protein serine/threonine kinase protein [Trichomonas vaginalis G3] | diamond | 1020 | 68.9 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 32750210 | 32750210 | PRJNA914897_P_NODE_32420_length_274_cov_1.532338_g31996_i0 | PRJNA914897 | 32420 | 274 | 1.532338 | 4.19860612 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 43.9 | 0.0196 | NR | XP_001307110.1 | 412133 | g31996 | i0 | 30.3 | 1.42335766423358 | 76 | 53 | 83.2 | 0 | 230 | 3 | 53 | 128 | XP_001307110.1 protein kinase protein [Trichomonas vaginalis G3] | diamond | 390 | 44.3 | 0.99097065462754 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 32805773 | 32805773 | PRJNA914897_P_NODE_22060_length_355_cov_1.329787_g21636_i0 | PRJNA914897 | 22060 | 355 | 1.329787 | 4.72074385 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 68.9 | 9.18e-11 | NR | XP_068349620.1 | 1144522 | g21636 | i0 | 32.5 | 2.76338028169014 | 117 | 70 | 91.3 | 4 | 31 | 354 | 630 | 746 | XP_068349620.1 uncharacterized protein TRFO_37341 [Tritrichomonas foetus] | diamond | 981 | 68.9 | 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);;