contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA966993" and tax_phylum = "Preaxostyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 941945 | 941945 | PRJNA966993_P_NODE_21681_length_451_cov_2.066138_g21234_i0 | PRJNA966993 | 21681 | 451 | 2.066138 | 9.31828238 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 151 | 6.48e-44 | NR | KAJ4458203.1 | 342808 | g21234 | i0 | 70.4 | 50.3148558758315 | 108 | 32 | 71.8 | 0 | 360 | 37 | 28 | 135 | KAJ4458203.1 putative histone H3.3 type 2 [Paratrimastix pyriformis] | diamond | 22692 | 152 | 0.993421052631579 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 13695538 | 13695538 | PRJNA966993_P_NODE_101111_length_229_cov_3.737179_g100659_i0 | PRJNA966993 | 101111 | 229 | 3.737179 | 8.55813991 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 115 | 3.82e-28 | NR | KAJ4458348.1 | 342808 | g100659 | i0 | 74.7 | 8.00436681222707 | 75 | 18 | 98.3 | 1 | 225 | 1 | 349 | 422 | KAJ4458348.1 putative polymerase family [Paratrimastix pyriformis] | diamond | 1833 | 115 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 14970533 | 14970533 | PRJNA966993_P_NODE_90532_length_246_cov_1.352601_g90080_i0 | PRJNA966993 | 90532 | 246 | 1.352601 | 3.32739846 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 108 | 1.05e-25 | NR | KAJ4463156.1 | 342808 | g90080 | i0 | 64.2 | 0.98780487804878 | 81 | 29 | 98.8 | 0 | 2 | 244 | 3 | 83 | KAJ4463156.1 hypothetical protein PAPYR_437 [Paratrimastix pyriformis] | diamond | 243 | 108 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 26772725 | 26772725 | PRJNA966993_P_NODE_75361_length_262_cov_1.306878_g74909_i0 | PRJNA966993 | 75361 | 262 | 1.306878 | 3.42402036 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 84.7 | 7.29e-17 | NR | KAK2952154.1 | 2049346 | g74909 | i0 | 41.9 | 0.984732824427481 | 86 | 48 | 96.2 | 1 | 11 | 262 | 108 | 193 | KAK2952154.1 putative CBL-interacting protein kinase 32 [Blattamonas nauphoetae] | diamond | 258 | 84.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 26842534 | 26842534 | PRJNA966993_P_NODE_56641_length_289_cov_2.111111_g56189_i0 | PRJNA966993 | 56641 | 289 | 2.111111 | 6.10111079 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 45.8 | 0.00145 | NR | KAA6355236.1 | 222440 | g56189 | i0 | 79.2 | 0.508650519031142 | 24 | 5 | 24.9 | 0 | 223 | 152 | 32 | 55 | KAA6355236.1 MAG: putative Serine/Threonine kinase domain protein, partial [Streblomastix strix] | diamond | 147 | 46.2 | 0.991341991341991 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 27183752 | 27183752 | PRJNA966993_P_NODE_32762_length_372_cov_6.618729_g32310_i0 | PRJNA966993 | 32762 | 372 | 6.618729 | 24.62167188 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 80.5 | 3.87e-17 | NR | KAJ4461601.1 | 342808 | g32310 | i0 | 53.2 | 1.23387096774194 | 79 | 36 | 62.9 | 1 | 365 | 132 | 1 | 79 | KAJ4461601.1 hypothetical protein PAPYR_1706 [Paratrimastix pyriformis] | diamond | 459 | 80.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 27310570 | 27310570 | PRJNA966993_P_NODE_40583_length_338_cov_1.452830_g40131_i0 | PRJNA966993 | 40583 | 338 | 1.45283 | 4.9105654 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 71.2 | 1.06e-11 | NR | KAJ4459115.1 | 342808 | g40131 | i0 | 42.6 | 0.834319526627219 | 94 | 53 | 82.5 | 1 | 280 | 2 | 176 | 269 | KAJ4459115.1 putative V-type proton ATPase subunit H [Paratrimastix pyriformis] | diamond | 282 | 71.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 27436978 | 27436978 | PRJNA966993_P_NODE_61303_length_283_cov_1.276190_g60851_i0 | PRJNA966993 | 61303 | 283 | 1.27619 | 3.6116177 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 48.1 | 7.69e-4 | NR | KAK2950415.1 | 2049346 | g60851 | i0 | 39.7 | 0.826855123674912 | 78 | 40 | 81.6 | 3 | 279 | 49 | 261 | 332 | KAK2950415.1 putative UPF0652 like protein [Blattamonas nauphoetae] | diamond | 234 | 48.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 27594712 | 27594712 | PRJNA966993_P_NODE_4944_length_926_cov_9.535756_g4616_i0 | PRJNA966993 | 4944 | 926 | 9.535756 | 88.30110056 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 73.9 | 1.6e-10 | NR | KAJ4454930.1 | 342808 | g4616 | i0 | 31.3 | 0.673866090712743 | 208 | 116 | 64.5 | 11 | 799 | 203 | 429 | 618 | KAJ4454930.1 putative Ectonucleoside triphosphate diphosphohydrolase 3 [Paratrimastix pyriformis] | diamond | 624 | 73.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28131487 | 28131487 | PRJNA966993_P_NODE_18465_length_487_cov_1.946860_g18020_i0 | PRJNA966993 | 18465 | 487 | 1.94686 | 9.4812082 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 131 | 6.759999999999999e-32 | NR | KAJ4462635.1 | 342808 | g18020 | i0 | 44.6 | 1.52772073921971 | 130 | 72 | 80.1 | 0 | 391 | 2 | 39 | 168 | KAJ4462635.1 putative Lysosomal alpha-mannosidase [Paratrimastix pyriformis] | diamond | 744 | 131 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28295453 | 28295453 | PRJNA966993_P_NODE_82686_length_251_cov_0.865169_g82234_i0 | PRJNA966993 | 82686 | 251 | 0.865169 | 2.17157419 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 47.8 | 4.98e-4 | NR | KAJ4459135.1 | 342808 | g82234 | i0 | 33.8 | 1.67330677290837 | 77 | 51 | 92 | 0 | 249 | 19 | 134 | 210 | KAJ4459135.1 hypothetical protein PAPYR_4935 [Paratrimastix pyriformis] | diamond | 420 | 48.1 | 0.993762993762994 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28573309 | 28573309 | PRJNA966993_P_NODE_25867_length_414_cov_17.387097_g25420_i0 | PRJNA966993 | 25867 | 414 | 17.387097 | 71.98258158 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 66.6 | 4.03e-11 | NR | KAJ4453711.1 | 342808 | g25420 | i0 | 51.6 | 1.00724637681159 | 64 | 29 | 46.4 | 1 | 378 | 187 | 4 | 65 | KAJ4453711.1 putative 60S acidic ribosomal protein P1 [Paratrimastix pyriformis] | diamond | 417 | 66.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28832188 | 28832188 | PRJNA966993_P_NODE_16928_length_508_cov_2.990805_g16486_i0 | PRJNA966993 | 16928 | 508 | 2.990805 | 15.1932894 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 219 | 2.47e-65 | NR | KAJ4457250.1 | 342808 | g16486 | i0 | 68.5 | 3.89173228346457 | 165 | 51 | 96.9 | 1 | 13 | 504 | 6 | 170 | KAJ4457250.1 Phosphoglucomutase [Paratrimastix pyriformis] | diamond | 1977 | 219 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28857415 | 28857415 | PRJNA966993_P_NODE_57408_length_288_cov_1.948837_g56956_i0 | PRJNA966993 | 57408 | 288 | 1.948837 | 5.61265056 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 76.3 | 3.33e-14 | NR | KAJ4457846.1 | 342808 | g56956 | i0 | 35.1 | 0.979166666666667 | 94 | 61 | 97.9 | 0 | 6 | 287 | 100 | 193 | KAJ4457846.1 hypothetical protein PAPYR_6522 [Paratrimastix pyriformis] | diamond | 282 | 76.3 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28863788 | 28863788 | PRJNA966993_P_NODE_43668_length_326_cov_25.529644_g43216_i0 | PRJNA966993 | 43668 | 326 | 25.529644 | 83.22663944 | root | 1 | Root_unresolved | Root_unresolved | 111 | 1.66e-29 | NR | KAA6379614.1 | 222440 | g43216 | i0 | 58.2 | 3.30368098159509 | 91 | 38 | 83.7 | 0 | 5 | 277 | 3 | 93 | KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix] | diamond | 1077 | 111 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 28984125 | 28984125 | PRJNA966993_P_NODE_16028_length_522_cov_3.979955_g15586_i0 | PRJNA966993 | 16028 | 522 | 3.979955 | 20.7753651 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 53.5 | 4.56e-5 | NR | KAA6394943.1 | 222440 | g15586 | i0 | 64.1 | 0.413793103448276 | 39 | 14 | 22.4 | 0 | 404 | 520 | 29 | 67 | KAA6394943.1 MAG: hypothetical protein EZS28_009524 [Streblomastix strix] | diamond | 216 | 53.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 29457124 | 29457124 | PRJNA966993_P_NODE_46070_length_318_cov_1.902041_g45618_i0 | PRJNA966993 | 46070 | 318 | 1.902041 | 6.04849038 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 87.4 | 2.01e-17 | NR | KAJ4461413.1 | 342808 | g45618 | i0 | 43 | 1.07547169811321 | 114 | 56 | 100 | 2 | 1 | 318 | 43 | 155 | KAJ4461413.1 putative GPI anchored protein [Paratrimastix pyriformis] | diamond | 342 | 87.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 29931301 | 29931301 | PRJNA966993_P_NODE_51231_length_303_cov_1.260870_g50779_i0 | PRJNA966993 | 51231 | 303 | 1.26087 | 3.8204361 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 49.7 | 4.6e-5 | NR | KAJ4460547.1 | 342808 | g50779 | i0 | 41 | 0.821782178217822 | 83 | 46 | 79.2 | 1 | 35 | 274 | 28 | 110 | KAJ4460547.1 hypothetical protein PAPYR_3173 [Paratrimastix pyriformis] | diamond | 249 | 49.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 30752634 | 30752634 | PRJNA966993_P_NODE_62534_length_281_cov_1.480769_g62082_i0 | PRJNA966993 | 62534 | 281 | 1.480769 | 4.16096089 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 114 | 8.39e-29 | NR | XP_067722289.1 | 2049356 | g62082 | i0 | 59.1 | 4.93238434163701 | 93 | 34 | 99.3 | 1 | 2 | 280 | 48 | 136 | XP_067722289.1 putative E3 ubiquitin-protein ligase RGLG2 [Monocercomonoides exilis] | diamond | 1386 | 114 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 30973917 | 30973917 | PRJNA966993_P_NODE_88374_length_248_cov_0.880000_g87922_i0 | PRJNA966993 | 88374 | 248 | 0.88 | 2.1824 | Paratrimastix eleionoma | 1709329 | Preaxostyla | other_Eukaryota | 81.6 | 1.58e-16 | NR | WCZ58380.1 | 1709329 | g87922 | i0 | 54.8 | 2.03225806451613 | 84 | 35 | 98 | 2 | 6 | 248 | 1 | 84 | WCZ58380.1 60S ribosomal protein L8 [Paratrimastix eleionoma] | diamond | 504 | 81.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix eleionoma | ||||
| 31226436 | 31226436 | PRJNA966993_P_NODE_87295_length_248_cov_1.320000_g86843_i0 | PRJNA966993 | 87295 | 248 | 1.32 | 3.2736 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 70.5 | 6.55e-12 | NR | KAJ4461776.1 | 342808 | g86843 | i0 | 43.5 | 0.834677419354839 | 69 | 31 | 73.8 | 2 | 245 | 63 | 349 | 417 | KAJ4461776.1 hypothetical protein PAPYR_1917 [Paratrimastix pyriformis] | diamond | 207 | 70.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31669297 | 31669297 | PRJNA966993_P_NODE_39297_length_343_cov_1.511111_g38845_i0 | PRJNA966993 | 39297 | 343 | 1.511111 | 5.18311073 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 135 | 3.96e-36 | NR | KAK2949752.1 | 2049346 | g38845 | i0 | 57.4 | 1.06705539358601 | 122 | 44 | 99.7 | 1 | 343 | 2 | 56 | 177 | KAK2949752.1 putative Aldo-keto reductase family 1 member A1 [Blattamonas nauphoetae] | diamond | 366 | 135 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 32302468 | 32302468 | PRJNA966993_P_NODE_53159_length_297_cov_2.062500_g52707_i0 | PRJNA966993 | 53159 | 297 | 2.0625 | 6.125625 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 49.3 | 3.39e-4 | NR | KAA6402557.1 | 222440 | g52707 | i0 | 34.5 | 0.878787878787879 | 87 | 49 | 84.8 | 2 | 29 | 280 | 170 | 251 | KAA6402557.1 MAG: putative rho guanine nucleotide exchange factor 17 [Streblomastix strix] | diamond | 261 | 49.3 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 32719063 | 32719063 | PRJNA966993_P_NODE_88520_length_247_cov_2.500000_g88068_i0 | PRJNA966993 | 88520 | 247 | 2.5 | 6.175 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 70.5 | 5.85e-12 | NR | KAA6398949.1 | 222440 | g88068 | i0 | 60.4 | 1.95546558704453 | 53 | 21 | 64.4 | 0 | 245 | 87 | 259 | 311 | KAA6398949.1 MAG: putative Cyclin-dependent kinase 2 [Streblomastix strix] | diamond | 483 | 70.9 | 0.994358251057828 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix |
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);;