contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA914897" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26676031 | 26676031 | PRJNA914897_P_NODE_28981_length_295_cov_1.261261_g28557_i0 | PRJNA914897 | 28981 | 295 | 1.261261 | 3.72071995 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 82 | 1.15e-15 | NR | KAK2947271.1 | 2049346 | g28557 | i0 | 51.4 | 1.50508474576271 | 74 | 35 | 74.2 | 1 | 43 | 261 | 2474 | 2547 | KAK2947271.1 putative Dynein-1-alpha heavy chain, flagellar inner arm I1 complex [Blattamonas nauphoetae] | diamond | 444 | 82 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 26992673 | 26992673 | PRJNA914897_P_NODE_9002_length_637_cov_1.430851_g8589_i0 | PRJNA914897 | 9002 | 637 | 1.430851 | 9.11452087 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 73.2 | 4.63e-11 | NR | KAK2942827.1 | 2049346 | g8589 | i0 | 54.2 | 0.555729984301413 | 59 | 27 | 27.8 | 0 | 460 | 636 | 259 | 317 | KAK2942827.1 putative DYRK-family kinase pom1 [Blattamonas nauphoetae] | diamond | 354 | 73.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 27150542 | 27150542 | PRJNA914897_P_NODE_9562_length_615_cov_2.138376_g9147_i0 | PRJNA914897 | 9562 | 615 | 2.138376 | 13.1510124 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 60.1 | 1.15e-6 | NR | KAJ4455163.1 | 342808 | g9147 | i0 | 52 | 0.478048780487805 | 50 | 23 | 24.4 | 1 | 353 | 502 | 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 | ||||
| 27245758 | 27245758 | PRJNA914897_P_NODE_41223_length_243_cov_1.088235_g40799_i0 | PRJNA914897 | 41223 | 243 | 1.088235 | 2.64441105 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 51.2 | 2.9e-5 | NR | KAA6386968.1 | 222440 | g40799 | i0 | 34.6 | 1 | 81 | 51 | 97.5 | 1 | 5 | 241 | 110 | 190 | KAA6386968.1 MAG: putative vesicle-associated membrane protein [Streblomastix strix] | diamond | 243 | 51.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 27309212 | 27309212 | PRJNA914897_P_NODE_5483_length_849_cov_20.189433_g5130_i0 | PRJNA914897 | 5483 | 849 | 20.189433 | 171.40828617 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 177 | 2.01e-50 | NR | KAA6375409.1 | 222440 | g5130 | i0 | 39.1 | 5.07773851590106 | 266 | 149 | 92.9 | 7 | 818 | 30 | 5 | 260 | KAA6375409.1 MAG: putative autophagy protein 3 [Streblomastix strix] | diamond | 4311 | 177 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 27758789 | 27758789 | PRJNA914897_P_NODE_18344_length_402_cov_1.331307_g17922_i0 | PRJNA914897 | 18344 | 402 | 1.331307 | 5.35185414 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 90.5 | 4.32e-18 | NR | WCZ58285.1 | 1709329 | g17922 | i0 | 37.3 | 10.4402985074627 | 126 | 79 | 94 | 0 | 6 | 383 | 312 | 437 | WCZ58285.1 ATP-dependent RNA helicase, partial [Paratrimastix eleionoma] | diamond | 4197 | 90.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix eleionoma | ||||
| 28098369 | 28098369 | PRJNA914897_P_NODE_32165_length_276_cov_1.137931_g31741_i0 | PRJNA914897 | 32165 | 276 | 1.137931 | 3.14068956 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 43.5 | 0.0291 | NR | KAJ4453710.1 | 342808 | g31741 | i0 | 37.3 | 0.902173913043478 | 83 | 48 | 90.2 | 1 | 259 | 11 | 21 | 99 | KAJ4453710.1 hypothetical protein PAPYR_11747 [Paratrimastix pyriformis] | diamond | 249 | 43.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28445903 | 28445903 | PRJNA914897_P_NODE_41426_length_243_cov_0.905882_g41002_i0 | PRJNA914897 | 41426 | 243 | 0.905882 | 2.20129326 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 74.7 | 1.97e-13 | NR | KAK2948450.1 | 2049346 | g41002 | i0 | 38.8 | 5.92592592592593 | 80 | 49 | 98.8 | 0 | 241 | 2 | 51 | 130 | KAK2948450.1 putative G2-specific protein kinase nimA [Blattamonas nauphoetae] | diamond | 1440 | 74.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 28635441 | 28635441 | PRJNA914897_P_NODE_20767_length_369_cov_141.564189_g20344_i0 | PRJNA914897 | 20767 | 369 | 141.564189 | 522.37185741 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 114 | 3.44e-30 | NR | KAA6379614.1 | 222440 | g20344 | i0 | 58.1 | 2.97560975609756 | 93 | 39 | 75.6 | 0 | 364 | 86 | 1 | 93 | KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix] | diamond | 1098 | 114 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 29645165 | 29645165 | PRJNA914897_P_NODE_4950_length_900_cov_7.307134_g4614_i0 | PRJNA914897 | 4950 | 900 | 7.307134 | 65.764206 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 66.2 | 4e-8 | NR | KAK2954447.1 | 2049346 | g4614 | i0 | 27.7 | 1.15333333333333 | 177 | 118 | 57 | 4 | 184 | 696 | 202 | 374 | KAK2954447.1 putative TMEM151 family protein [Blattamonas nauphoetae] | diamond | 1038 | 66.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 29740006 | 29740006 | PRJNA914897_P_NODE_13210_length_499_cov_2.276995_g12788_i0 | PRJNA914897 | 13210 | 499 | 2.276995 | 11.36220505 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 48.5 | 0.0029 | NR | KAJ4462045.1 | 342808 | g12788 | i0 | 29.5 | 0.673346693386774 | 112 | 74 | 64.9 | 3 | 55 | 378 | 12 | 122 | KAJ4462045.1 hypothetical protein PAPYR_1210 [Paratrimastix pyriformis] | diamond | 336 | 48.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 29740020 | 29740020 | PRJNA914897_P_NODE_24870_length_328_cov_1.474510_g24446_i0 | PRJNA914897 | 24870 | 328 | 1.47451 | 4.8363928 | Symbiotic protist of Reticulitermes speratus | 356864 | Preaxostyla | other_Eukaryota | 48.5 | 5.16e-4 | NR | BAF36690.1 | 356864 | g24446 | i0 | 29.9 | 0.795731707317073 | 87 | 58 | 79.6 | 1 | 276 | 16 | 38 | 121 | BAF36690.1 Small G Protein RAB, partial [Symbiotic protist of Reticulitermes speratus] | diamond | 261 | 48.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Symbiotic protist of Reticulitermes speratus | |||||
| 30909367 | 30909367 | PRJNA914897_P_NODE_7174_length_729_cov_1.960366_g6788_i0 | PRJNA914897 | 7174 | 729 | 1.960366 | 14.29106814 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 98.2 | 3.04e-19 | NR | KAJ4461503.1 | 342808 | g6788 | i0 | 40.2 | 0.522633744855967 | 127 | 76 | 52.3 | 0 | 715 | 335 | 2247 | 2373 | KAJ4461503.1 putative DExH-box ATP-dependent RNA helicase DExH5 [Paratrimastix pyriformis] | diamond | 381 | 98.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 30940992 | 30940992 | PRJNA914897_P_NODE_19754_length_382_cov_1.495146_g19332_i0 | PRJNA914897 | 19754 | 382 | 1.495146 | 5.71145772 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 67.4 | 1.45e-10 | NR | KAJ4454042.1 | 342808 | g19332 | i0 | 42 | 1.6413612565445 | 69 | 38 | 54.2 | 1 | 304 | 98 | 86 | 152 | KAJ4454042.1 putative GTP-binding protein YPTM1 [Paratrimastix pyriformis] | diamond | 627 | 67.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31043308 | 31043308 | PRJNA914897_P_NODE_16315_length_433_cov_3.500000_g15893_i0 | PRJNA914897 | 16315 | 433 | 3.5 | 15.155 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 135 | 1.24e-37 | NR | KAA6395870.1 | 222440 | g15893 | i0 | 46.9 | 4.95381062355658 | 143 | 75 | 99.1 | 1 | 431 | 3 | 1 | 142 | KAA6395870.1 MAG: putative Ubiquitin-conjugating enzyme [Streblomastix strix] | diamond | 2145 | 135 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 31225066 | 31225066 | PRJNA914897_P_NODE_37175_length_250_cov_0.870056_g36751_i0 | PRJNA914897 | 37175 | 250 | 0.870056 | 2.17514 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 48.1 | 5.34e-4 | NR | KAK2958534.1 | 2049346 | g36751 | i0 | 28.9 | 0.996 | 83 | 49 | 87.6 | 2 | 2 | 220 | 1741 | 1823 | KAK2958534.1 hypothetical protein BLNAU_6568 [Blattamonas nauphoetae] | diamond | 249 | 48.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 31256812 | 31256812 | PRJNA914897_P_NODE_40895_length_244_cov_0.900585_g40471_i0 | PRJNA914897 | 40895 | 244 | 0.900585 | 2.1974274 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 49.3 | 1.82e-4 | NR | KAK2953709.1 | 2049346 | g40471 | i0 | 34.6 | 0.995901639344262 | 81 | 45 | 98.4 | 2 | 4 | 243 | 31 | 104 | KAK2953709.1 putative Transcriptional adapter ADA2 [Blattamonas nauphoetae] | diamond | 243 | 49.3 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 31573351 | 31573351 | PRJNA914897_P_NODE_38176_length_248_cov_1.542857_g37752_i0 | PRJNA914897 | 38176 | 248 | 1.542857 | 3.82628536 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 68.2 | 2.93e-11 | NR | KAJ4453685.1 | 342808 | g37752 | i0 | 43.2 | 1.95967741935484 | 81 | 44 | 98 | 1 | 5 | 247 | 76 | 154 | KAJ4453685.1 putative permease family protein [Paratrimastix pyriformis] | diamond | 486 | 68.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 32269346 | 32269346 | PRJNA914897_P_NODE_5958_length_812_cov_2.422192_g5599_i0 | PRJNA914897 | 5958 | 812 | 2.422192 | 19.66819904 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 53.5 | 4.34e-4 | NR | KAJ4463130.1 | 342808 | g5599 | i0 | 26 | 0.753694581280788 | 204 | 134 | 73.5 | 7 | 709 | 113 | 243 | 434 | KAJ4463130.1 putative Polypyrimidine tract-binding protein 3 [Paratrimastix pyriformis] | diamond | 612 | 53.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);;