contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA1059246" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26718421 | 26718421 | PRJNA1059246_P_NODE_32561_length_381_cov_1.000000_g31935_i0 | PRJNA1059246 | 32561 | 381 | 1 | 3.81 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 68.6 | 1.36e-10 | NR | KAJ4455308.1 | 342808 | g31935 | i0 | 34.3 | 1.54330708661417 | 137 | 69 | 97.6 | 4 | 376 | 5 | 1 | 129 | KAJ4455308.1 putative ubiquitinconjugating enzyme subfamily protein [Paratrimastix pyriformis] | diamond | 588 | 68.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 27098549 | 27098549 | PRJNA1059246_P_NODE_36482_length_356_cov_1.360424_g35856_i0 | PRJNA1059246 | 36482 | 356 | 1.360424 | 4.84310944 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 52 | 6.04e-5 | NR | KAJ4462876.1 | 342808 | g35856 | i0 | 29.5 | 1.02808988764045 | 122 | 81 | 99.4 | 4 | 354 | 1 | 64 | 184 | KAJ4462876.1 hypothetical protein PAPYR_83 [Paratrimastix pyriformis] | diamond | 366 | 52 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 27762223 | 27762223 | PRJNA1059246_P_NODE_41084_length_331_cov_1.193798_g40458_i0 | PRJNA1059246 | 41084 | 331 | 1.193798 | 3.95147138 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 48.1 | 0.0014 | NR | KAJ4461899.1 | 342808 | g40458 | i0 | 45.2 | 0.561933534743202 | 62 | 23 | 56.2 | 3 | 7 | 192 | 2589 | 2639 | KAJ4461899.1 putative Hydrocephalus-inducing protein [Paratrimastix pyriformis] | diamond | 186 | 48.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 27888210 | 27888210 | PRJNA1059246_P_NODE_8265_length_845_cov_5.215026_g7755_i0 | PRJNA1059246 | 8265 | 845 | 5.215026 | 44.0669697 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 50.1 | 0.00805 | NR | KAJ4454930.1 | 342808 | g7755 | i0 | 25.9 | 0.713609467455621 | 201 | 131 | 69.9 | 8 | 762 | 172 | 424 | 610 | KAJ4454930.1 putative Ectonucleoside triphosphate diphosphohydrolase 3 [Paratrimastix pyriformis] | diamond | 603 | 50.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28898506 | 28898506 | PRJNA1059246_P_NODE_64048_length_249_cov_0.875000_g63422_i0 | PRJNA1059246 | 64048 | 249 | 0.875 | 2.17875 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 93.2 | 4.31e-21 | NR | XP_067728365.1 | 2049356 | g63422 | i0 | 68.4 | 1.36144578313253 | 57 | 18 | 68.7 | 0 | 242 | 72 | 170 | 226 | XP_067728365.1 Uracil phosphoribosyltransferase [Monocercomonoides exilis] | diamond | 339 | 93.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 29025313 | 29025313 | PRJNA1059246_P_NODE_53988_length_277_cov_1.137255_g53362_i0 | PRJNA1059246 | 53988 | 277 | 1.137255 | 3.15019635 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 69.7 | 1.87e-11 | NR | KAK2960140.1 | 2049346 | g53362 | i0 | 38.4 | 1.86281588447653 | 86 | 52 | 92.1 | 1 | 271 | 17 | 94 | 179 | KAK2960140.1 putative Casein kinase I [Blattamonas nauphoetae] | diamond | 516 | 69.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 29340820 | 29340820 | PRJNA1059246_P_NODE_65649_length_247_cov_1.724138_g65023_i0 | PRJNA1059246 | 65649 | 247 | 1.724138 | 4.25862086 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 50.4 | 7.79e-5 | NR | KAA6400535.1 | 222440 | g65023 | i0 | 38.7 | 0.910931174089069 | 75 | 31 | 72.9 | 2 | 237 | 58 | 1467 | 1541 | KAA6400535.1 MAG: putative NEK protein kinase [Streblomastix strix] | diamond | 225 | 50.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 29561574 | 29561574 | PRJNA1059246_P_NODE_68470_length_245_cov_0.895349_g67844_i0 | PRJNA1059246 | 68470 | 245 | 0.895349 | 2.19360505 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 89.4 | 1.04e-18 | NR | KAJ4458641.1 | 342808 | g67844 | i0 | 55.6 | 0.881632653061225 | 72 | 31 | 88.2 | 1 | 9 | 224 | 350 | 420 | KAJ4458641.1 putative histone deacetylase 6 [Paratrimastix pyriformis] | diamond | 216 | 89.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 29655982 | 29655982 | PRJNA1059246_P_NODE_44470_length_314_cov_2.024896_g43844_i0 | PRJNA1059246 | 44470 | 314 | 2.024896 | 6.35817344 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 71.6 | 5.83e-12 | NR | KAJ4459776.1 | 342808 | g43844 | i0 | 68.8 | 0.45859872611465 | 48 | 15 | 45.9 | 0 | 2 | 145 | 422 | 469 | KAJ4459776.1 putative DEAD-box ATP-dependent RNA helicase 6 [Paratrimastix pyriformis] | diamond | 144 | 71.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31046733 | 31046733 | PRJNA1059246_P_NODE_35735_length_360_cov_2.139373_g35109_i0 | PRJNA1059246 | 35735 | 360 | 2.139373 | 7.7017428 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 49.3 | 3.26e-4 | NR | KAK2958767.1 | 2049346 | g35109 | i0 | 33.3 | 1.39166666666667 | 81 | 53 | 67.5 | 1 | 79 | 321 | 15 | 94 | KAK2958767.1 putative transmembrane emp24 domain-containing protein 2 [Blattamonas nauphoetae] | diamond | 501 | 49.3 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 31078184 | 31078184 | PRJNA1059246_P_NODE_25335_length_443_cov_2.410811_g24710_i0 | PRJNA1059246 | 25335 | 443 | 2.410811 | 10.67989273 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 210 | 5.81e-63 | NR | KAJ4456772.1 | 342808 | g24710 | i0 | 62.8 | 1.99097065462754 | 148 | 52 | 98.9 | 2 | 442 | 5 | 222 | 368 | KAJ4456772.1 putative O-Glycosyl hydrolase family 30 [Paratrimastix pyriformis] | diamond | 882 | 210 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31931838 | 31931838 | PRJNA1059246_P_NODE_45057_length_312_cov_0.966527_g44431_i0 | PRJNA1059246 | 45057 | 312 | 0.966527 | 3.01556424 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 130 | 1.19e-35 | NR | KAJ4457859.1 | 342808 | g44431 | i0 | 71.3 | 3.31730769230769 | 87 | 25 | 83.7 | 0 | 310 | 50 | 84 | 170 | KAJ4457859.1 putative Maintenance of ploidy protein mob1 [Paratrimastix pyriformis] | diamond | 1035 | 130 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis |
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);;