contig_metadata
12 rows where bioproject = "PRJNA494251" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 475400 | 475400 | PRJNA494251_P_NODE_29801_length_272_cov_3.201005_g29487_i0 | PRJNA494251 | 29801 | 272 | 3.201005 | 8.7067336 | Trichomonas vaginalis | 5722 | Parabasalia | other_Eukaryota | 63.9 | 1.15e-5 | NTclustered | gi|2319615616|ref|XR_007835995.1| | 412133 | g29487 | i0 | 88.462 | 0.6875 | 52 | 6 | 19 | 0 | 106 | 157 | 2605 | 2554 | Trichomonas vaginalis G3 23S ribosomal RNA (TVAGG3_0034210), rRNA | blastn | 187 | 63.9 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 26633698 | 26633698 | PRJNA494251_P_NODE_16861_length_340_cov_3.258427_g16548_i0 | PRJNA494251 | 16861 | 340 | 3.258427 | 11.0786518 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 116 | 4.6199999999999995e-30 | NR | XP_068360038.1 | 1144522 | g16548 | i0 | 52.3 | 4.85294117647059 | 111 | 53 | 97.9 | 0 | 339 | 7 | 63 | 173 | XP_068360038.1 40S ribosomal protein S9-1 [Tritrichomonas foetus] | diamond | 1650 | 116 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 26633722 | 26633722 | PRJNA494251_P_NODE_35301_length_255_cov_1.538462_g34987_i0 | PRJNA494251 | 35301 | 255 | 1.538462 | 3.9230781 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 67 | 2.68e-11 | NR | XP_067770116.1 | 135588 | g34987 | i0 | 45.8 | 0.976470588235294 | 83 | 44 | 96.5 | 1 | 5 | 250 | 90 | 172 | XP_067770116.1 uncharacterized protein GO595_009806 [Histomonas meleagridis] | diamond | 249 | 67 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 27076904 | 27076904 | PRJNA494251_P_NODE_14022_length_367_cov_4.003401_g13714_i0 | PRJNA494251 | 14022 | 367 | 4.003401 | 14.69248167 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 110 | 2.09e-28 | NR | XP_067769820.1 | 135588 | g13714 | i0 | 61 | 0.670299727520436 | 82 | 32 | 67 | 0 | 264 | 19 | 31 | 112 | XP_067769820.1 uncharacterized protein GO595_009871 [Histomonas meleagridis] | diamond | 246 | 110 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 27250514 | 27250514 | PRJNA494251_P_NODE_22723_length_302_cov_1.244541_g22409_i0 | PRJNA494251 | 22723 | 302 | 1.244541 | 3.75851382 | root | 1 | Root_unresolved | Root_unresolved | 50.8 | 7.7e-5 | NR | XP_068361433.1 | 1144522 | g22409 | i0 | 55.6 | 1.2317880794702 | 36 | 16 | 35.8 | 0 | 42 | 149 | 146 | 181 | XP_068361433.1 Alpha-tubulin N-acetyltransferase [Tritrichomonas foetus] | diamond | 372 | 51.2 | 0.9921875 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 29413622 | 29413622 | PRJNA494251_P_NODE_1829_length_878_cov_1.918012_g1603_i0 | PRJNA494251 | 1829 | 878 | 1.918012 | 16.84014536 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 75.1 | 3.48e-12 | NR | XP_001304133.1 | 412133 | g1603 | i0 | 28.4 | 0.57744874715262 | 169 | 115 | 56.4 | 4 | 875 | 381 | 1 | 167 | XP_001304133.1 GTPase protein [Trichomonas vaginalis G3] | diamond | 507 | 75.1 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 29413626 | 29413626 | PRJNA494251_P_NODE_19689_length_319_cov_2.032520_g19375_i0 | PRJNA494251 | 19689 | 319 | 2.03252 | 6.4837388 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 129 | 8.54e-34 | NR | XP_068363371.1 | 1144522 | g19375 | i0 | 67.8 | 3.1128526645768 | 87 | 28 | 81.8 | 0 | 16 | 276 | 1 | 87 | XP_068363371.1 DnaJ subfamily B member 4 [Tritrichomonas foetus] | diamond | 993 | 129 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 30013822 | 30013822 | PRJNA494251_P_NODE_28491_length_277_cov_1.985294_g28177_i0 | PRJNA494251 | 28491 | 277 | 1.985294 | 5.49926438 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 110 | 4.49e-28 | NR | XP_001299092.1 | 412133 | g28177 | i0 | 56.5 | 3.97472924187726 | 92 | 39 | 98.6 | 1 | 274 | 2 | 68 | 159 | XP_001299092.1 peroxiredoxin protein [Trichomonas vaginalis G3] | diamond | 1101 | 110 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 30424910 | 30424910 | PRJNA494251_P_NODE_24133_length_295_cov_1.324324_g23819_i0 | PRJNA494251 | 24133 | 295 | 1.324324 | 3.9067558 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 53.5 | 1e-5 | NR | XP_068368100.1 | 1144522 | g23819 | i0 | 42.3 | 0.528813559322034 | 52 | 30 | 52.9 | 0 | 158 | 3 | 7 | 58 | XP_068368100.1 CMGC family protein kinase [Tritrichomonas foetus] | diamond | 156 | 53.5 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 30440216 | 30440216 | PRJNA494251_P_NODE_24733_length_292_cov_1.406393_g24419_i0 | PRJNA494251 | 24733 | 292 | 1.406393 | 4.10666756 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 74.7 | 4.05e-13 | NR | XP_067773013.1 | 135588 | g24419 | i0 | 40.6 | 3.0513698630137 | 101 | 56 | 99.7 | 3 | 2 | 292 | 947 | 1047 | XP_067773013.1 DNA-directed RNA polymerase II subunit RPB1 [Histomonas meleagridis] | diamond | 891 | 74.7 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 31846837 | 31846837 | PRJNA494251_P_NODE_15377_length_354_cov_1.462633_g15064_i0 | PRJNA494251 | 15377 | 354 | 1.462633 | 5.17772082 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 48.1 | 0.00107 | NR | XP_067777083.1 | 135588 | g15064 | i0 | 35.6 | 1.86440677966102 | 101 | 39 | 64.4 | 3 | 126 | 353 | 1 | 100 | XP_067777083.1 14-3-3 protein [Histomonas meleagridis] | diamond | 660 | 48.1 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 32258650 | 32258650 | PRJNA494251_P_NODE_46178_length_244_cov_0.888889_g45864_i0 | PRJNA494251 | 46178 | 244 | 0.888889 | 2.16888916 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 65.9 | 5.63e-11 | NR | XP_001315246.1 | 412133 | g45864 | i0 | 44.1 | 0.836065573770492 | 68 | 37 | 82.4 | 1 | 243 | 43 | 70 | 137 | XP_001315246.1 calcium ion binding [Trichomonas vaginalis G3] | diamond | 204 | 65.9 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis |
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);;