contig_metadata
18 rows where bioproject = "PRJNA438111", tax_clade = "Apusozoa" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1708788 | 1708788 | PRJNA438111_P_NODE_21282_length_233_cov_4.799020_g20657_i0 | PRJNA438111 | 21282 | 233 | 4.79902 | 11.1817166 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 97.8 | 1.36e-21 | NR | XP_013757471.1 | 461836 | g20657 | i0 | 62.2 | 4.76394849785408 | 74 | 28 | 95.3 | 0 | 12 | 233 | 344 | 417 | XP_013757471.1 26S proteasome non-ATPase regulatory subunit 2 [Thecamonas trahens ATCC 50062] | diamond | 1110 | 97.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 6812121 | 6812121 | PRJNA438111_P_NODE_5526_length_420_cov_4.851662_g4945_i0 | PRJNA438111 | 5526 | 420 | 4.851662 | 20.3769804 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 151 | 1.82e-41 | NR | XP_013760194.1 | 461836 | g4945 | i0 | 54.3 | 1 | 140 | 63 | 100 | 1 | 420 | 1 | 189 | 327 | XP_013760194.1 G2/mitotic-specific cyclin-B [Thecamonas trahens ATCC 50062] | diamond | 420 | 151 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 11912612 | 11912612 | PRJNA438111_P_NODE_19030_length_245_cov_2.069444_g18405_i0 | PRJNA438111 | 19030 | 245 | 2.069444 | 5.0701378 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 117 | 2.38e-28 | NR | XP_013760135.1 | 461836 | g18405 | i0 | 70.4 | 0.991836734693878 | 81 | 24 | 99.2 | 0 | 1 | 243 | 365 | 445 | XP_013760135.1 ABC transporter A family member 10 [Thecamonas trahens ATCC 50062] | diamond | 243 | 117 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 24042712 | 24042712 | PRJNA438111_P_NODE_8759_length_342_cov_1.769968_g8140_i0 | PRJNA438111 | 8759 | 342 | 1.769968 | 6.05329056 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 134 | 4.0899999999999995e-35 | NR | XP_013760194.1 | 461836 | g8140 | i0 | 55.4 | 2.95614035087719 | 112 | 50 | 98.2 | 0 | 341 | 6 | 184 | 295 | XP_013760194.1 G2/mitotic-specific cyclin-B [Thecamonas trahens ATCC 50062] | diamond | 1011 | 134 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 26791212 | 26791212 | PRJNA438111_P_NODE_61261_length_170_cov_4.397163_g60636_i0 | PRJNA438111 | 61261 | 170 | 4.397163 | 7.4751771 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 98.2 | 1.98e-22 | NR | XP_013761379.1 | 461836 | g60636 | i0 | 75 | 0.988235294117647 | 56 | 14 | 98.8 | 0 | 2 | 169 | 98 | 153 | XP_013761379.1 aspartate aminotransferase [Thecamonas trahens ATCC 50062] | diamond | 168 | 98.2 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27107364 | 27107364 | PRJNA438111_P_NODE_47962_length_184_cov_2.251613_g47337_i0 | PRJNA438111 | 47962 | 184 | 2.251613 | 4.14296792 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 62 | 1.55e-10 | NR | XP_013758367.1 | 461836 | g47337 | i0 | 65.8 | 0.619565217391304 | 38 | 13 | 62 | 0 | 3 | 116 | 72 | 109 | XP_013758367.1 ubiquitin-conjugating enzyme E2 D/E [Thecamonas trahens ATCC 50062] | diamond | 114 | 62 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27739649 | 27739649 | PRJNA438111_P_NODE_13224_length_286_cov_1.832685_g12599_i0 | PRJNA438111 | 13224 | 286 | 1.832685 | 5.2414791 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 55.1 | 2.74e-6 | NR | XP_013756368.1 | 461836 | g12599 | i0 | 36.5 | 1.00699300699301 | 96 | 59 | 98.6 | 2 | 282 | 1 | 230 | 325 | XP_013756368.1 solute carrier family 38 member 5 [Thecamonas trahens ATCC 50062] | diamond | 288 | 55.1 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27833965 | 27833965 | PRJNA438111_P_NODE_4484_length_466_cov_5.739130_g3935_i0 | PRJNA438111 | 4484 | 466 | 5.73913 | 26.7443458 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 75.9 | 4.14e-14 | NR | XP_013760554.1 | 461836 | g3935 | i0 | 37.5 | 0.824034334763948 | 128 | 72 | 77.9 | 3 | 445 | 83 | 16 | 142 | XP_013760554.1 calmodulin [Thecamonas trahens ATCC 50062] | diamond | 384 | 75.9 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28560411 | 28560411 | PRJNA438111_P_NODE_8427_length_347_cov_8.037736_g7810_i0 | PRJNA438111 | 8427 | 347 | 8.037736 | 27.89094392 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 55.5 | 3.98e-6 | NR | XP_013756838.1 | 461836 | g7810 | i0 | 35.3 | 1.0028818443804 | 116 | 66 | 96.8 | 3 | 11 | 346 | 257 | 367 | XP_013756838.1 bax inhibitor 1 [Thecamonas trahens ATCC 50062] | diamond | 348 | 55.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28671415 | 28671415 | PRJNA438111_P_NODE_12367_length_294_cov_3.992453_g11742_i0 | PRJNA438111 | 12367 | 294 | 3.992453 | 11.73781182 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.9 | 4.97e-4 | NR | XP_013754709.1 | 461836 | g11742 | i0 | 51.2 | 1.59183673469388 | 41 | 18 | 39.8 | 1 | 166 | 282 | 2053 | 2093 | XP_013754709.1 uncharacterized protein AMSG_09323 [Thecamonas trahens ATCC 50062] | diamond | 468 | 48.9 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29065581 | 29065581 | PRJNA438111_P_NODE_73428_length_162_cov_3.097744_g72803_i0 | PRJNA438111 | 73428 | 162 | 3.097744 | 5.01834528 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 85.1 | 1.48e-17 | NR | XP_013760135.1 | 461836 | g72803 | i0 | 67.9 | 3.98148148148148 | 53 | 17 | 98.1 | 0 | 162 | 4 | 288 | 340 | XP_013760135.1 ABC transporter A family member 10 [Thecamonas trahens ATCC 50062] | diamond | 645 | 85.1 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29791493 | 29791493 | PRJNA438111_P_NODE_6451_length_391_cov_7.635359_g5854_i0 | PRJNA438111 | 6451 | 391 | 7.635359 | 29.85425369 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 55.5 | 6.05e-6 | NR | XP_013761927.1 | 461836 | g5854 | i0 | 27.9 | 0.989769820971867 | 129 | 91 | 97.4 | 2 | 389 | 9 | 184 | 312 | XP_013761927.1 delta-5 desaturase [Thecamonas trahens ATCC 50062] | diamond | 387 | 55.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29807886 | 29807886 | PRJNA438111_P_NODE_50771_length_181_cov_1.684211_g50146_i0 | PRJNA438111 | 50771 | 181 | 1.684211 | 3.04842191 | Bangiophyceae | 2797 | Root_unresolved | Root_unresolved | 63.5 | 7.56e-10 | NR | XP_013757117.1 | 461836 | g50146 | i0 | 62 | 2.80110497237569 | 50 | 19 | 82.9 | 0 | 13 | 162 | 1554 | 1603 | XP_013757117.1 uncharacterized protein AMSG_11960 [Thecamonas trahens ATCC 50062] | diamond | 507 | 63.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30075826 | 30075826 | PRJNA438111_P_NODE_51392_length_180_cov_2.728477_g50767_i0 | PRJNA438111 | 51392 | 180 | 2.728477 | 4.9112586 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 57 | 1.35e-7 | NR | XP_013756156.1 | 461836 | g50767 | i0 | 44.2 | 0.866666666666667 | 52 | 29 | 86.7 | 0 | 21 | 176 | 234 | 285 | XP_013756156.1 metal tolerance protein [Thecamonas trahens ATCC 50062] | diamond | 156 | 57 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31972512 | 31972512 | PRJNA438111_P_NODE_57178_length_174_cov_2.806897_g56553_i0 | PRJNA438111 | 57178 | 174 | 2.806897 | 4.88400078 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 52.8 | 4.2e-6 | NR | XP_013762797.1 | 461836 | g56553 | i0 | 37.5 | 0.827586206896552 | 48 | 30 | 82.8 | 0 | 146 | 3 | 277 | 324 | XP_013762797.1 syntaxin-binding protein 1 [Thecamonas trahens ATCC 50062] | diamond | 144 | 52.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32083775 | 32083775 | PRJNA438111_P_NODE_458_length_1301_cov_8.518868_g312_i0 | PRJNA438111 | 458 | 1301 | 8.518868 | 110.83047268 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 278 | 2.82e-84 | NR | XP_013753091.1 | 461836 | g312 | i0 | 38.1 | 2.00845503458878 | 433 | 260 | 99.2 | 6 | 1297 | 8 | 94 | 521 | XP_013753091.1 pyruvate kinase [Thecamonas trahens ATCC 50062] | diamond | 2613 | 280 | 0.992857142857143 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32337159 | 32337159 | PRJNA438111_P_NODE_3459_length_526_cov_5.358149_g2952_i0 | PRJNA438111 | 3459 | 526 | 5.358149 | 28.18386374 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 129 | 2.3899999999999995e-32 | NR | XP_013760274.1 | 461836 | g2952 | i0 | 41.8 | 2.81178707224335 | 165 | 87 | 91.8 | 3 | 506 | 24 | 104 | 263 | XP_013760274.1 deoxyribonuclease II family protein [Thecamonas trahens ATCC 50062] | diamond | 1479 | 129 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32573948 | 32573948 | PRJNA438111_P_NODE_44559_length_188_cov_2.679245_g43934_i0 | PRJNA438111 | 44559 | 188 | 2.679245 | 5.0369806 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 77 | 1.46e-14 | NR | XP_013760961.1 | 461836 | g43934 | i0 | 60.7 | 1.91489361702128 | 61 | 24 | 97.3 | 0 | 2 | 184 | 336 | 396 | XP_013760961.1 peroxisomal acyl-coenzyme A oxidase 1 [Thecamonas trahens ATCC 50062] | diamond | 360 | 77 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens |
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);;