contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA493827" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3023752 | 3023752 | PRJNA493827_P_NODE_40043_length_576_cov_3.431412_g37864_i0 | PRJNA493827 | 40043 | 576 | 3.431412 | 19.76493312 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 80.5 | 7.74e-14 | NR | KAA6394278.1 | 222440 | g37864 | i0 | 34.4 | 3.61458333333333 | 128 | 84 | 66.7 | 0 | 430 | 47 | 195 | 322 | KAA6394278.1 MAG: hypothetical protein EZS28_010197, partial [Streblomastix strix] | diamond | 2082 | 80.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 9401689 | 9401689 | PRJNA493827_P_NODE_70468_length_413_cov_11.944118_g68271_i0 | PRJNA493827 | 70468 | 413 | 11.944118 | 49.32920734 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 85.5 | 1.72e-18 | NR | KAJ4453711.1 | 342808 | g68271 | i0 | 58.9 | 1.04600484261501 | 73 | 26 | 53 | 2 | 385 | 167 | 2 | 70 | KAJ4453711.1 putative 60S acidic ribosomal protein P1 [Paratrimastix pyriformis] | diamond | 432 | 85.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 13226736 | 13226736 | PRJNA493827_P_NODE_40171_length_575_cov_2.195219_g37991_i0 | PRJNA493827 | 40171 | 575 | 2.195219 | 12.62250925 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 216 | 3.8e-65 | NR | ABI49151.1 | 342808 | g37991 | i0 | 65.9 | 4.23130434782609 | 164 | 54 | 84.5 | 1 | 573 | 88 | 269 | 432 | ABI49151.1 enolase [Paratrimastix pyriformis] | diamond | 2433 | 218 | 0.990825688073395 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 27139650 | 27139650 | PRJNA493827_P_NODE_205622_length_247_cov_0.885057_g203424_i0 | PRJNA493827 | 205622 | 247 | 0.885057 | 2.18609079 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 97.4 | 2.29e-21 | NR | KAK2964576.1 | 2049346 | g203424 | i0 | 64.3 | 1.67611336032389 | 70 | 25 | 85 | 0 | 1 | 210 | 824 | 893 | KAK2964576.1 putative ABC transporter F family member 1 [Blattamonas nauphoetae] | diamond | 414 | 97.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 27677380 | 27677380 | PRJNA493827_P_NODE_42384_length_557_cov_2.084711_g40198_i0 | PRJNA493827 | 42384 | 557 | 2.084711 | 11.61184027 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 66.2 | 6.35e-9 | NR | KAK2947739.1 | 2049346 | g40198 | i0 | 60 | 0.242369838420108 | 45 | 18 | 24.2 | 0 | 1 | 135 | 371 | 415 | KAK2947739.1 putative Tubulin glycylase 3C [Blattamonas nauphoetae] | diamond | 135 | 66.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 27709056 | 27709056 | PRJNA493827_P_NODE_184144_length_251_cov_1.157303_g181946_i0 | PRJNA493827 | 184144 | 251 | 1.157303 | 2.90483053 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 76.6 | 4.85e-14 | NR | KAJ4454715.1 | 342808 | g181946 | i0 | 51.8 | 0.99203187250996006 | 83 | 38 | 99.2 | 1 | 249 | 1 | 134 | 214 | KAJ4454715.1 putative protein kinase [Paratrimastix pyriformis] | diamond | 249 | 76.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28276767 | 28276767 | PRJNA493827_P_NODE_157646_length_273_cov_1.175000_g155448_i0 | PRJNA493827 | 157646 | 273 | 1.175 | 3.20775 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 79 | 6.23e-16 | NR | KAJ4452380.1 | 342808 | g155448 | i0 | 46.6 | 0.967032967032967 | 88 | 46 | 96.7 | 1 | 9 | 272 | 50 | 136 | KAJ4452380.1 putative intraflagellar transport particle protein [Paratrimastix pyriformis] | diamond | 264 | 79 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28308623 | 28308623 | PRJNA493827_P_NODE_229986_length_242_cov_0.911243_g227788_i0 | PRJNA493827 | 229986 | 242 | 0.911243 | 2.20520806 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 50.8 | 5.15e-5 | NR | XP_067725874.1 | 2049356 | g227788 | i0 | 37.2 | 1.93388429752066 | 78 | 47 | 96.7 | 1 | 238 | 5 | 621 | 696 | XP_067725874.1 Replication protein A 70 kDa DNA-binding subunit [Monocercomonoides exilis] | diamond | 468 | 50.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 28324081 | 28324081 | PRJNA493827_P_NODE_119706_length_312_cov_1.707113_g117508_i0 | PRJNA493827 | 119706 | 312 | 1.707113 | 5.32619256 | Polymastigidae | 302780 | Preaxostyla | other_Eukaryota | 150 | 9.68e-45 | NR | KAK2957131.1 | 2049346 | g117508 | i0 | 78 | 5.28846153846154 | 91 | 19 | 86.5 | 1 | 3 | 272 | 19 | 109 | KAK2957131.1 putative Peptidyl-prolyl cis-trans isomerase FKBP12 [Blattamonas nauphoetae] | diamond | 1650 | 150 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 28750527 | 28750527 | PRJNA493827_P_NODE_20047_length_873_cov_4.700000_g18278_i0 | PRJNA493827 | 20047 | 873 | 4.7 | 41.031 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 60.1 | 4.7e-6 | NR | KAJ4455163.1 | 342808 | g18278 | i0 | 52 | 0.336769759450172 | 50 | 23 | 17.2 | 1 | 293 | 144 | 601 | 649 | KAJ4455163.1 putative CCR4-NOT transcription complex subunit 3 [Paratrimastix pyriformis] | diamond | 294 | 60.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28750547 | 28750547 | PRJNA493827_P_NODE_216287_length_244_cov_1.438596_g214089_i0 | PRJNA493827 | 216287 | 244 | 1.438596 | 3.51017424 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 57.4 | 1.68e-7 | NR | KAJ4459958.1 | 342808 | g214089 | i0 | 52.8 | 2.44672131147541 | 53 | 25 | 65.2 | 0 | 160 | 2 | 22 | 74 | KAJ4459958.1 hypothetical protein PAPYR_4032 [Paratrimastix pyriformis] | diamond | 597 | 57.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28813443 | 28813443 | PRJNA493827_P_NODE_226528_length_242_cov_1.230769_g224330_i0 | PRJNA493827 | 226528 | 242 | 1.230769 | 2.97846098 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 55.1 | 1.51e-6 | NR | KAJ4459671.1 | 342808 | g224330 | i0 | 37.8 | 1.01652892561983 | 82 | 47 | 96.7 | 2 | 237 | 4 | 1 | 82 | KAJ4459671.1 putative Cysteine proteinase 3 [Paratrimastix pyriformis] | diamond | 246 | 55.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 29003580 | 29003580 | PRJNA493827_P_NODE_188128_length_250_cov_1.683616_g185930_i0 | PRJNA493827 | 188128 | 250 | 1.683616 | 4.20904 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 50.1 | 1.01e-4 | NR | KAK2952075.1 | 2049346 | g185930 | i0 | 35.3 | 0.816 | 68 | 43 | 80.4 | 1 | 203 | 3 | 171 | 238 | KAK2952075.1 putative b-box zinc finger family protein [Blattamonas nauphoetae] | diamond | 204 | 50.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 29665852 | 29665852 | PRJNA493827_P_NODE_230590_length_241_cov_2.321429_g228392_i0 | PRJNA493827 | 230590 | 241 | 2.321429 | 5.59464389 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 52.8 | 1.03e-5 | NR | KAA6384518.1 | 222440 | g228392 | i0 | 40.8 | 1.10788381742739 | 49 | 29 | 61 | 0 | 45 | 191 | 192 | 240 | KAA6384518.1 MAG: putative Casein kinase 1 [Streblomastix strix] | diamond | 267 | 52.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 30013661 | 30013661 | PRJNA493827_P_NODE_138531_length_290_cov_1.414747_g136333_i0 | PRJNA493827 | 138531 | 290 | 1.414747 | 4.1027663 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 49.3 | 3.29e-4 | NR | KAK2957205.1 | 2049346 | g136333 | i0 | 32.9 | 5.28620689655172 | 85 | 49 | 79.7 | 3 | 237 | 7 | 289 | 373 | KAK2957205.1 putative Endosome/lysosome-associated apoptosis and autophagy regulator 1 [Blattamonas nauphoetae] | diamond | 1533 | 49.7 | 0.991951710261569 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 30202919 | 30202919 | PRJNA493827_P_NODE_192872_length_249_cov_1.465909_g190674_i0 | PRJNA493827 | 192872 | 249 | 1.465909 | 3.65011341 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 112 | 9.04e-27 | NR | KAJ4458602.1 | 342808 | g190674 | i0 | 63 | 0.975903614457831 | 81 | 29 | 97.6 | 1 | 5 | 247 | 252 | 331 | KAJ4458602.1 putative Cytosolic carboxypeptidase Nna1 [Paratrimastix pyriformis] | diamond | 243 | 112 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 30993126 | 30993126 | PRJNA493827_P_NODE_201494_length_247_cov_2.212644_g199296_i0 | PRJNA493827 | 201494 | 247 | 2.212644 | 5.46523068 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 66.2 | 2e-10 | NR | KAJ4459864.1 | 342808 | g199296 | i0 | 45.7 | 0.850202429149798 | 70 | 34 | 80.2 | 1 | 242 | 45 | 660 | 729 | KAJ4459864.1 putative Arginine--tRNA ligase [Paratrimastix pyriformis] | diamond | 210 | 66.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31245817 | 31245817 | PRJNA493827_P_NODE_180495_length_254_cov_0.861878_g178297_i0 | PRJNA493827 | 180495 | 254 | 0.861878 | 2.18917012 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 42.7 | 0.0412 | NR | KAK2964222.1 | 2049346 | g178297 | i0 | 61.1 | 0.425196850393701 | 36 | 12 | 42.5 | 1 | 253 | 146 | 375 | 408 | KAK2964222.1 putative Eukaryotic initiation factor 4A [Blattamonas nauphoetae] | diamond | 108 | 42.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 31973317 | 31973317 | PRJNA493827_P_NODE_111598_length_323_cov_22.060000_g109400_i0 | PRJNA493827 | 111598 | 323 | 22.06 | 71.2538 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 111 | 2.26e-29 | NR | KAA6379614.1 | 222440 | g109400 | i0 | 54.9 | 4.24458204334365 | 91 | 41 | 84.5 | 0 | 4 | 276 | 3 | 93 | KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix] | diamond | 1371 | 111 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 32826424 | 32826424 | PRJNA493827_P_NODE_104760_length_334_cov_2.026820_g102562_i0 | PRJNA493827 | 104760 | 334 | 2.02682 | 6.7695788 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 85.5 | 7.03e-19 | NR | KAJ4453711.1 | 342808 | g102562 | i0 | 56.6 | 0.682634730538922 | 76 | 30 | 68.3 | 1 | 10 | 237 | 2 | 74 | KAJ4453711.1 putative 60S acidic ribosomal protein P1 [Paratrimastix pyriformis] | diamond | 228 | 85.5 | 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);;