contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA379145" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1675628 | 1675628 | PRJNA379145_P_NODE_44822_length_265_cov_2.060345_g42670_i0 | PRJNA379145 | 44822 | 265 | 2.060345 | 5.45991425 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 60.8 | 1.91e-8 | NR | XP_067775339.1 | 135588 | g42670 | i0 | 41 | 7.07547169811321 | 83 | 42 | 94 | 1 | 263 | 15 | 229 | 304 | XP_067775339.1 TKL family protein kinase [Histomonas meleagridis] | diamond | 1875 | 61.2 | 0.993464052287582 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 26726326 | 26726326 | PRJNA379145_P_NODE_14961_length_737_cov_2.393466_g13354_i0 | PRJNA379145 | 14961 | 737 | 2.393466 | 17.63984442 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 48.1 | 0.00113 | NR | XP_001579255.1 | 412133 | g13354 | i0 | 50 | 0.187245590230665 | 46 | 20 | 18.7 | 1 | 221 | 358 | 4 | 46 | XP_001579255.1 associate of C-MYC AMY-1 family [Trichomonas vaginalis G3] | diamond | 138 | 48.1 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 27517392 | 27517392 | PRJNA379145_P_NODE_73963_length_150_cov_2.752137_g71808_i0 | PRJNA379145 | 73963 | 150 | 2.752137 | 4.1282055 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 70.5 | 1.68e-12 | NR | XP_067775916.1 | 135588 | g71808 | i0 | 57.1 | 1.96 | 49 | 21 | 98 | 0 | 2 | 148 | 1064 | 1112 | XP_067775916.1 Coatomer, alpha subunit [Histomonas meleagridis] | diamond | 294 | 70.5 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 27864501 | 27864501 | PRJNA379145_P_NODE_25725_length_483_cov_3.051111_g23678_i0 | PRJNA379145 | 25725 | 483 | 3.051111 | 14.73686613 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 58.9 | 9.79e-7 | NR | XP_001324945.1 | 412133 | g23678 | i0 | 31.5 | 0.68944099378882 | 111 | 75 | 68.9 | 1 | 90 | 422 | 97 | 206 | XP_001324945.1 uncharacterized protein TVAGG3_0507240 [Trichomonas vaginalis G3] | diamond | 333 | 58.9 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 28685747 | 28685747 | PRJNA379145_P_NODE_29747_length_420_cov_1.589147_g27632_i0 | PRJNA379145 | 29747 | 420 | 1.589147 | 6.6744174 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 50.1 | 7.3e-4 | NR | XP_068362867.1 | 1144522 | g27632 | i0 | 45 | 0.428571428571429 | 60 | 20 | 40.7 | 4 | 227 | 57 | 2953 | 3002 | XP_068362867.1 uncharacterized protein TRFO_21244 [Tritrichomonas foetus] | diamond | 180 | 50.1 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 28717186 | 28717186 | PRJNA379145_P_NODE_21787_length_556_cov_2.321224_g19853_i0 | PRJNA379145 | 21787 | 556 | 2.321224 | 12.90600544 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 93.2 | 2.21e-18 | NR | XP_067777754.1 | 135588 | g19853 | i0 | 50 | 0.453237410071942 | 84 | 41 | 45.3 | 1 | 228 | 479 | 429 | 511 | XP_067777754.1 FYVE-type zinc finger-containing protein [Histomonas meleagridis] | diamond | 252 | 93.2 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 28843222 | 28843222 | PRJNA379145_P_NODE_15348_length_724_cov_1.800289_g13715_i0 | PRJNA379145 | 15348 | 724 | 1.800289 | 13.03409236 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 61.2 | 1.44e-7 | NR | XP_001582059.1 | 412133 | g13715 | i0 | 46.6 | 0.302486187845304 | 73 | 39 | 30.2 | 0 | 246 | 28 | 62 | 134 | XP_001582059.1 RNA polymerase II transcription regulator recruiting protein [Trichomonas vaginalis G3] | diamond | 219 | 61.2 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 30738347 | 30738347 | PRJNA379145_P_NODE_40174_length_301_cov_3.638060_g38023_i0 | PRJNA379145 | 40174 | 301 | 3.63806 | 10.9505606 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 80.5 | 3.44e-17 | NR | XP_001580982.1 | 412133 | g38023 | i0 | 60.3 | 1.18604651162791 | 58 | 23 | 57.8 | 0 | 253 | 80 | 4 | 61 | XP_001580982.1 translational elongation [Trichomonas vaginalis G3] | diamond | 357 | 80.5 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 30850256 | 30850256 | PRJNA379145_P_NODE_50454_length_231_cov_1.636364_g48300_i0 | PRJNA379145 | 50454 | 231 | 1.636364 | 3.78000084 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 73.9 | 2.64e-13 | NR | XP_067773532.1 | 135588 | g48300 | i0 | 48.5 | 16.8181818181818 | 68 | 26 | 88.3 | 1 | 10 | 213 | 171 | 229 | XP_067773532.1 CAMK family protein kinase [Histomonas meleagridis] | diamond | 3885 | 73.9 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 31022888 | 31022888 | PRJNA379145_P_NODE_51755_length_224_cov_1.696335_g49601_i0 | PRJNA379145 | 51755 | 224 | 1.696335 | 3.7997904 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 73.9 | 3.73e-14 | NR | XP_001323614.1 | 412133 | g49601 | i0 | 51.9 | 2.0625 | 77 | 34 | 99.1 | 1 | 223 | 2 | 75 | 151 | XP_001323614.1 GTPase protein [Trichomonas vaginalis G3] | diamond | 462 | 73.9 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 31275572 | 31275572 | PRJNA379145_P_NODE_21715_length_557_cov_6.026718_g19783_i0 | PRJNA379145 | 21715 | 557 | 6.026718 | 33.56881926 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 199 | 1.34e-61 | NR | XP_068360038.1 | 1144522 | g19783 | i0 | 57.2 | 7.49730700179533 | 173 | 74 | 93.2 | 0 | 25 | 543 | 5 | 177 | XP_068360038.1 40S ribosomal protein S9-1 [Tritrichomonas foetus] | diamond | 4176 | 199 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 32129914 | 32129914 | PRJNA379145_P_NODE_21358_length_565_cov_2.112782_g19449_i0 | PRJNA379145 | 21358 | 565 | 2.112782 | 11.9372183 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 94 | 1.71e-18 | NR | XP_001304482.1 | 412133 | g19449 | i0 | 32.6 | 0.961061946902655 | 181 | 115 | 92.4 | 4 | 553 | 32 | 352 | 532 | XP_001304482.1 ubiquitinyl hydrolase protein [Trichomonas vaginalis G3] | diamond | 543 | 94 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 32446412 | 32446412 | PRJNA379145_P_NODE_54559_length_211_cov_1.213483_g52405_i0 | PRJNA379145 | 54559 | 211 | 1.213483 | 2.56044913 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 58.2 | 2.47e-8 | NR | XP_001307659.1 | 412133 | g52405 | i0 | 43.5 | 0.981042654028436 | 69 | 38 | 96.7 | 1 | 209 | 6 | 71 | 139 | XP_001307659.1 RNA polymerase II transcription regulator recruiting protein [Trichomonas vaginalis G3] | diamond | 207 | 58.2 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 32541308 | 32541308 | PRJNA379145_P_NODE_28079_length_445_cov_1.781553_g25988_i0 | PRJNA379145 | 28079 | 445 | 1.781553 | 7.92791085 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 51.6 | 2.36e-4 | NR | XP_001317072.1 | 412133 | g25988 | i0 | 47.5 | 0.41123595505618 | 61 | 27 | 38.4 | 2 | 255 | 425 | 528 | 587 | XP_001317072.1 protein ubiquitination [Trichomonas vaginalis G3] | diamond | 183 | 51.6 | 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);;