contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA1195374" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26723760 | 26723760 | PRJNA1195374_P_NODE_44021_length_334_cov_3.203065_g43677_i0 | PRJNA1195374 | 44021 | 334 | 3.203065 | 10.6982371 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 68.6 | 1.06e-11 | NR | XP_067772561.1 | 135588 | g43677 | i0 | 44.3 | 0.709580838323353 | 79 | 43 | 70.1 | 1 | 276 | 43 | 31 | 109 | XP_067772561.1 transposable element tc3 transposase [Histomonas meleagridis] | diamond | 237 | 68.6 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 27420357 | 27420357 | PRJNA1195374_P_NODE_67103_length_261_cov_1.223404_g66759_i0 | PRJNA1195374 | 67103 | 261 | 1.223404 | 3.19308444 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 48.9 | 3.14e-4 | NR | XP_001318044.1 | 412133 | g66759 | i0 | 45.5 | 0.505747126436782 | 44 | 24 | 50.6 | 0 | 258 | 127 | 197 | 240 | XP_001318044.1 structural constituent of cell wall [Trichomonas vaginalis G3] | diamond | 132 | 48.9 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 27641271 | 27641271 | PRJNA1195374_P_NODE_39784_length_354_cov_1.516014_g39440_i0 | PRJNA1195374 | 39784 | 354 | 1.516014 | 5.36668956 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 47.8 | 0.00207 | NR | XP_068346703.1 | 1144522 | g39440 | i0 | 34.1 | 1.40677966101695 | 91 | 47 | 70.3 | 3 | 3 | 251 | 260 | 345 | XP_068346703.1 uncharacterized protein TRFO_40176 [Tritrichomonas foetus] | diamond | 498 | 47.8 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 28272358 | 28272358 | PRJNA1195374_P_NODE_34266_length_385_cov_1.208333_g33922_i0 | PRJNA1195374 | 34266 | 385 | 1.208333 | 4.65208205 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 72.4 | 7.54e-12 | NR | XP_068361143.1 | 1144522 | g33922 | i0 | 36.5 | 0.981818181818182 | 126 | 75 | 98.2 | 4 | 3 | 380 | 646 | 766 | XP_068361143.1 uncharacterized protein TRFO_23625 [Tritrichomonas foetus] | diamond | 378 | 72.4 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 28777619 | 28777619 | PRJNA1195374_P_NODE_35787_length_376_cov_1.267327_g35443_i0 | PRJNA1195374 | 35787 | 376 | 1.267327 | 4.76514952 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 118 | 3.8000000000000005e-28 | NR | XP_068363021.1 | 1144522 | g35443 | i0 | 61.5 | 2.29787234042553 | 96 | 37 | 76.6 | 0 | 376 | 89 | 446 | 541 | XP_068363021.1 Copine family protein [Tritrichomonas foetus] | diamond | 864 | 118 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 30059685 | 30059685 | PRJNA1195374_P_NODE_52471_length_302_cov_1.008734_g52127_i0 | PRJNA1195374 | 52471 | 302 | 1.008734 | 3.04637668 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 60.5 | 4.19e-8 | NR | XP_068362900.1 | 1144522 | g52127 | i0 | 42 | 3.35761589403974 | 81 | 35 | 80.5 | 2 | 302 | 60 | 193 | 261 | XP_068362900.1 CAMK family protein kinase [Tritrichomonas foetus] | diamond | 1014 | 60.5 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 30091218 | 30091218 | PRJNA1195374_P_NODE_67032_length_261_cov_1.250000_g66688_i0 | PRJNA1195374 | 67032 | 261 | 1.25 | 3.2625 | root | 1 | Root_unresolved | Root_unresolved | 62.8 | 3.65e-9 | NR | XP_001313899.1 | 412133 | g66688 | i0 | 38.1 | 4.44827586206897 | 84 | 44 | 87.4 | 1 | 251 | 24 | 31 | 114 | XP_001313899.1 spectrin binding [Trichomonas vaginalis G3] | diamond | 1161 | 62.8 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 30483237 | 30483237 | PRJNA1195374_P_NODE_83573_length_242_cov_0.911243_g83229_i0 | PRJNA1195374 | 83573 | 242 | 0.911243 | 2.20520806 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 45.8 | 0.00293 | NR | XP_001310870.1 | 412133 | g83229 | i0 | 34.7 | 0.892561983471074 | 72 | 45 | 88 | 2 | 3 | 215 | 27 | 97 | XP_001310870.1 ribosomal protein S6 kinase family [Trichomonas vaginalis G3] | diamond | 216 | 45.8 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 30596814 | 30596814 | PRJNA1195374_P_NODE_80653_length_244_cov_0.900585_g80309_i0 | PRJNA1195374 | 80653 | 244 | 0.900585 | 2.1974274 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 83.6 | 2.12e-17 | NR | XP_067772684.1 | 135588 | g80309 | i0 | 47.9 | 9.47950819672131 | 71 | 37 | 87.3 | 0 | 243 | 31 | 164 | 234 | XP_067772684.1 Ubiquitin-conjugating enzyme family protein [Histomonas meleagridis] | diamond | 2313 | 84.3 | 0.991696322657177 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 30735839 | 30735839 | PRJNA1195374_P_NODE_45614_length_328_cov_1.043137_g45270_i0 | PRJNA1195374 | 45614 | 328 | 1.043137 | 3.42148936 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 52.8 | 2.91e-5 | NR | XP_068362378.1 | 1144522 | g45270 | i0 | 37.5 | 0.658536585365854 | 72 | 36 | 57.6 | 2 | 324 | 136 | 210 | 281 | XP_068362378.1 CAMK family protein kinase [Tritrichomonas foetus] | diamond | 216 | 52.8 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 31842315 | 31842315 | PRJNA1195374_P_NODE_84877_length_241_cov_0.916667_g84533_i0 | PRJNA1195374 | 84877 | 241 | 0.916667 | 2.20916747 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 49.3 | 1.73e-4 | NR | XP_068362240.1 | 1144522 | g84533 | i0 | 45.9 | 1.7551867219917 | 74 | 38 | 92.1 | 2 | 224 | 3 | 173 | 244 | XP_068362240.1 Kinesin motor domain containing protein [Tritrichomonas foetus] | diamond | 423 | 49.3 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 31937258 | 31937258 | PRJNA1195374_P_NODE_69957_length_253_cov_1.283333_g69613_i0 | PRJNA1195374 | 69957 | 253 | 1.283333 | 3.24683249 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 57 | 3.65e-7 | NR | XP_067778417.1 | 135588 | g69613 | i0 | 36.6 | 0.841897233201581 | 71 | 45 | 84.2 | 0 | 242 | 30 | 164 | 234 | XP_067778417.1 LRR-containing protein [Histomonas meleagridis] | diamond | 213 | 57 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 31968949 | 31968949 | PRJNA1195374_P_NODE_85178_length_241_cov_0.916667_g84834_i0 | PRJNA1195374 | 85178 | 241 | 0.916667 | 2.20916747 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 53.1 | 7.92e-6 | NR | XP_001310018.1 | 412133 | g84834 | i0 | 44.1 | 0.734439834024896 | 59 | 32 | 73.4 | 1 | 13 | 189 | 81 | 138 | XP_001310018.1 surface antigen family [Trichomonas vaginalis G3] | diamond | 177 | 53.1 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 32158981 | 32158981 | PRJNA1195374_P_NODE_35298_length_379_cov_1.238562_g34954_i0 | PRJNA1195374 | 35298 | 379 | 1.238562 | 4.69414998 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 102 | 2.3000000000000003e-22 | NR | XP_001320325.1 | 412133 | g34954 | i0 | 42.4 | 1.93931398416887 | 125 | 71 | 98.9 | 1 | 3 | 377 | 4283 | 4406 | XP_001320325.1 dynein light chain binding [Trichomonas vaginalis G3] | diamond | 735 | 102 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 32380429 | 32380429 | PRJNA1195374_P_NODE_24799_length_456_cov_1.216710_g24455_i0 | PRJNA1195374 | 24799 | 456 | 1.21671 | 5.5481976 | Trichomonas vaginalis G3 | 412133 | Parabasalia | other_Eukaryota | 45.4 | 0.0382 | NR | XP_001319517.1 | 412133 | g24455 | i0 | 48.9 | 0.309210526315789 | 47 | 23 | 30.9 | 1 | 356 | 216 | 455 | 500 | XP_001319517.1 antigen BSP-related family [Trichomonas vaginalis G3] | diamond | 141 | 45.4 | 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);;