contig_metadata
13 rows where bioproject = "PRJNA980585", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12433936 | 12433936 | PRJNA980585_P_NODE_31090_length_277_cov_1.117647_g30836_i0 | PRJNA980585 | 31090 | 277 | 1.117647 | 3.09588219 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 98.2 | 4.149999999999999e-23 | NR | XP_001303658.1 | 412133 | g30836 | i0 | 52.1 | 9.82310469314079 | 96 | 42 | 99.6 | 2 | 277 | 2 | 5 | 100 | XP_001303658.1 small Rab GTPase Rab11b [Trichomonas vaginalis G3] | diamond | 2721 | 98.2 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 12748687 | 12748687 | PRJNA980585_P_NODE_7390_length_479_cov_1.273399_g7136_i0 | PRJNA980585 | 7390 | 479 | 1.273399 | 6.09958121 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 148 | 1.15e-41 | NR | XP_001316606.1 | 412133 | g7136 | i0 | 44.7 | 1.89770354906054 | 152 | 84 | 95.2 | 0 | 24 | 479 | 10 | 161 | XP_001316606.1 regulation of endocytosis [Trichomonas vaginalis G3] | diamond | 909 | 148 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 13708335 | 13708335 | PRJNA980585_P_NODE_30751_length_277_cov_2.774510_g30497_i0 | PRJNA980585 | 30751 | 277 | 2.77451 | 7.6853927 | Trichomonas vaginalis | 5722 | Parabasalia | other_Eukaryota | 65.8 | 3.27e-6 | NTclustered | gi|2319615616|ref|XR_007835995.1| | 412133 | g30497 | i0 | 90.385 | 0.84115523465704 | 52 | 2 | 18 | 3 | 2 | 52 | 2561 | 2610 | Trichomonas vaginalis G3 23S ribosomal RNA (TVAGG3_0034210), rRNA | blastn | 233 | 65.8 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 26899712 | 26899712 | PRJNA980585_P_NODE_50541_length_246_cov_0.890173_g50287_i0 | PRJNA980585 | 50541 | 246 | 0.890173 | 2.18982558 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 40.8 | 0.0352 | NR | XP_068349850.1 | 1144522 | g50287 | i0 | 32.2 | 0.719512195121951 | 59 | 35 | 72 | 1 | 26 | 202 | 3 | 56 | XP_068349850.1 Dynein light chain LC6, flagellar outer arm [Tritrichomonas foetus] | diamond | 177 | 40.8 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 28321041 | 28321041 | PRJNA980585_P_NODE_5406_length_546_cov_3.363636_g5152_i0 | PRJNA980585 | 5406 | 546 | 3.363636 | 18.36545256 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 124 | 6.789999999999999e-31 | NR | XP_001324382.1 | 412133 | g5152 | i0 | 40.2 | 0.928571428571429 | 169 | 95 | 92.9 | 4 | 39 | 545 | 3 | 165 | XP_001324382.1 cysteine-type peptidase protein [Trichomonas vaginalis G3] | diamond | 507 | 124 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 28731596 | 28731596 | PRJNA980585_P_NODE_34267_length_268_cov_1.184615_g34013_i0 | PRJNA980585 | 34267 | 268 | 1.184615 | 3.1747682 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 73.6 | 7.25e-13 | NR | XP_067769137.1 | 135588 | g34013 | i0 | 47.6 | 1.88059701492537 | 84 | 39 | 91.8 | 2 | 21 | 266 | 603 | 683 | XP_067769137.1 C2 domain containing protein [Histomonas meleagridis] | diamond | 504 | 73.6 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 29583715 | 29583715 | PRJNA980585_P_NODE_35710_length_264_cov_1.057592_g35456_i0 | PRJNA980585 | 35710 | 264 | 1.057592 | 2.79204288 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 94.7 | 5.92e-22 | NR | XP_068358606.1 | 1144522 | g35456 | i0 | 51.7 | 2.98863636363636 | 87 | 40 | 98.9 | 1 | 2 | 262 | 44 | 128 | XP_068358606.1 Thymidylate kinase [Tritrichomonas foetus] | diamond | 789 | 94.7 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 30374127 | 30374127 | PRJNA980585_P_NODE_22392_length_309_cov_2.262712_g22138_i0 | PRJNA980585 | 22392 | 309 | 2.262712 | 6.99178008 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 46.2 | 0.00476 | NR | XP_067775289.1 | 135588 | g22138 | i0 | 33 | 1.85436893203884 | 88 | 55 | 84.5 | 2 | 309 | 49 | 279 | 363 | XP_067775289.1 Protein disulfide-isomerase [Histomonas meleagridis] | diamond | 573 | 46.2 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 30468772 | 30468772 | PRJNA980585_P_NODE_32433_length_273_cov_1.255000_g32179_i0 | PRJNA980585 | 32433 | 273 | 1.255 | 3.42615 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 73.2 | 1.36e-13 | NR | XP_001301591.1 | 412133 | g32179 | i0 | 46 | 0.956043956043956 | 87 | 44 | 93.4 | 2 | 8 | 262 | 77 | 162 | XP_001301591.1 GTPase protein [Trichomonas vaginalis G3] | diamond | 261 | 73.2 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 31005628 | 31005628 | PRJNA980585_P_NODE_17934_length_337_cov_0.924242_g17680_i0 | PRJNA980585 | 17934 | 337 | 0.924242 | 3.11469554 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 78.2 | 4.18e-14 | NR | XP_067772736.1 | 135588 | g17680 | i0 | 34.5 | 0.979228486646884 | 110 | 71 | 97 | 1 | 7 | 333 | 258 | 367 | XP_067772736.1 uncharacterized protein GO595_007217 [Histomonas meleagridis] | diamond | 330 | 78.2 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 31833761 | 31833761 | PRJNA980585_P_NODE_59317_length_242_cov_0.911243_g59063_i0 | PRJNA980585 | 59317 | 242 | 0.911243 | 2.20520806 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 76.6 | 3.54e-15 | NR | XP_067773498.1 | 135588 | g59063 | i0 | 49.4 | 2.02066115702479 | 81 | 39 | 99.2 | 2 | 3 | 242 | 84 | 163 | XP_067773498.1 ras-like GTP-binding protein RhoL isoform X2 [Histomonas meleagridis] | diamond | 489 | 76.6 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 32207514 | 32207514 | PRJNA980585_P_NODE_28178_length_285_cov_1.028302_g27924_i0 | PRJNA980585 | 28178 | 285 | 1.028302 | 2.9306607 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 54.7 | 3.91e-6 | NR | XP_001302885.1 | 412133 | g27924 | i0 | 41.8 | 2.50526315789474 | 79 | 45 | 83.2 | 1 | 13 | 249 | 3 | 80 | XP_001302885.1 spectrin binding [Trichomonas vaginalis G3] | diamond | 714 | 54.7 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 32365900 | 32365900 | PRJNA980585_P_NODE_4739_length_578_cov_53.805941_g4485_i0 | PRJNA980585 | 4739 | 578 | 53.805941 | 310.99833898 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 199 | 1.23e-61 | NR | XP_068360038.1 | 1144522 | g4485 | i0 | 57.2 | 6.37889273356401 | 173 | 74 | 89.8 | 0 | 28 | 546 | 5 | 177 | XP_068360038.1 40S ribosomal protein S9-1 [Tritrichomonas foetus] | diamond | 3687 | 199 | 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);;