contig_metadata
20 rows where bioproject = "PRJNA453567", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17019102 | 17019102 | PRJNA453567_P_NODE_14_length_4628_cov_16.037247_g12_i0 | PRJNA453567 | 14 | 4628 | 16.037247 | 742.20379116 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 99.8 | 6.38e-17 | NR | XP_013762274.1 | 461836 | g12 | i0 | 46.6 | 0.245678478824546 | 131 | 43 | 8.5 | 3 | 1775 | 1383 | 522 | 625 | XP_013762274.1 uncharacterized protein AMSG_01102 [Thecamonas trahens ATCC 50062] | diamond | 1137 | 99.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 19567729 | 19567729 | PRJNA453567_P_NODE_6436_length_393_cov_1.421348_g6200_i0 | PRJNA453567 | 6436 | 393 | 1.421348 | 5.58589764 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 228 | 5.8199999999999984e-55 | NTclustered | gi|923129133|ref|XM_013902579.1| | 461836 | g6200 | i0 | 82.264 | 31.7557251908397 | 265 | 45 | 67 | 2 | 124 | 387 | 1119 | 856 | Thecamonas trahens ATCC 50062 RuvB-like 1 (AMSG_05323), partial mRNA | blastn | 12480 | 228 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 23394002 | 23394002 | PRJNA453567_P_NODE_1819_length_858_cov_27.779537_g1676_i0 | PRJNA453567 | 1819 | 858 | 27.779537 | 238.34842746 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 163 | 3.83e-35 | NTclustered | gi|923132316|ref|XM_013904170.1| | 461836 | g1676 | i0 | 85 | 1.47552447552448 | 160 | 24 | 19 | 0 | 655 | 814 | 190 | 31 | Thecamonas trahens ATCC 50062 50S ribosomal protein L37a (AMSG_03714), partial mRNA | blastn | 1266 | 163 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 26981156 | 26981156 | PRJNA453567_P_NODE_9342_length_312_cov_1.560000_g9105_i0 | PRJNA453567 | 9342 | 312 | 1.56 | 4.8672 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 58.2 | 3.38e-7 | NR | XP_013757908.1 | 461836 | g9105 | i0 | 46.3 | 1.26923076923077 | 67 | 36 | 64.4 | 0 | 202 | 2 | 3741 | 3807 | XP_013757908.1 HECT domain containing 3 [Thecamonas trahens ATCC 50062] | diamond | 396 | 58.2 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27138936 | 27138936 | PRJNA453567_P_NODE_2222_length_768_cov_2.366621_g2055_i0 | PRJNA453567 | 2222 | 768 | 2.366621 | 18.17564928 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 257 | 3.96e-81 | NR | XP_013759620.1 | 461836 | g2055 | i0 | 47.8 | 0.98046875 | 251 | 127 | 96.9 | 2 | 760 | 17 | 32 | 281 | XP_013759620.1 uncharacterized protein AMSG_03707 [Thecamonas trahens ATCC 50062] | diamond | 753 | 257 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27581587 | 27581587 | PRJNA453567_P_NODE_6044_length_408_cov_1.633423_g5808_i0 | PRJNA453567 | 6044 | 408 | 1.633423 | 6.66436584 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 60.5 | 1.51e-7 | NR | XP_013762271.1 | 461836 | g5808 | i0 | 41.9 | 0.544117647058823 | 74 | 41 | 52.9 | 1 | 221 | 6 | 802 | 875 | XP_013762271.1 uncharacterized protein AMSG_01099 [Thecamonas trahens ATCC 50062] | diamond | 222 | 60.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27819055 | 27819055 | PRJNA453567_P_NODE_5944_length_412_cov_1.877333_g5708_i0 | PRJNA453567 | 5944 | 412 | 1.877333 | 7.73461196 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 74.3 | 2.41e-12 | NR | XP_013757752.1 | 461836 | g5708 | i0 | 35.7 | 4.71116504854369 | 129 | 34 | 93.9 | 3 | 409 | 23 | 2530 | 2609 | XP_013757752.1 ubiquitin carboxyl-terminal hydrolase 34 [Thecamonas trahens ATCC 50062] | diamond | 1941 | 74.3 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28023748 | 28023748 | PRJNA453567_P_NODE_11365_length_276_cov_2.753138_g11128_i0 | PRJNA453567 | 11365 | 276 | 2.753138 | 7.59866088 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 77 | 4.78e-14 | NR | XP_013753152.1 | 461836 | g11128 | i0 | 60.9 | 0.695652173913043 | 64 | 25 | 69.6 | 0 | 67 | 258 | 23 | 86 | XP_013753152.1 phosphatidylglycerol specific phospholipase C [Thecamonas trahens ATCC 50062] | diamond | 192 | 77 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29002928 | 29002928 | PRJNA453567_P_NODE_3788_length_551_cov_1.678988_g3559_i0 | PRJNA453567 | 3788 | 551 | 1.678988 | 9.25122388 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 169 | 6.87e-47 | NR | XP_013762250.1 | 461836 | g3559 | i0 | 44.8 | 7.03992740471869 | 183 | 92 | 99.6 | 2 | 2 | 550 | 139 | 312 | XP_013762250.1 GPR108 protein [Thecamonas trahens ATCC 50062] | diamond | 3879 | 169 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29839595 | 29839595 | PRJNA453567_P_NODE_9031_length_318_cov_2.768683_g8794_i0 | PRJNA453567 | 9031 | 318 | 2.768683 | 8.80441194 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.9 | 5.87e-4 | NR | XP_013760385.1 | 461836 | g8794 | i0 | 56.5 | 2.39622641509434 | 46 | 19 | 42.5 | 1 | 175 | 309 | 35 | 80 | XP_013760385.1 sphingosine-1-phosphate phosphatase 2 [Thecamonas trahens ATCC 50062] | diamond | 762 | 49.3 | 0.991886409736308 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29981379 | 29981379 | PRJNA453567_P_NODE_3631_length_566_cov_2.013233_g3404_i0 | PRJNA453567 | 3631 | 566 | 2.013233 | 11.39489878 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 119 | 2.74e-28 | NR | XP_013762582.1 | 461836 | g3404 | i0 | 49 | 0.757950530035336 | 143 | 61 | 70.5 | 3 | 564 | 166 | 216 | 356 | XP_013762582.1 selenide, water dikinase [Thecamonas trahens ATCC 50062] | diamond | 429 | 119 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30360971 | 30360971 | PRJNA453567_P_NODE_732_length_1332_cov_3.413900_g667_i0 | PRJNA453567 | 732 | 1332 | 3.4139 | 45.473148 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 179 | 4.95e-50 | NR | XP_013753014.1 | 461836 | g667 | i0 | 43.6 | 0.506756756756757 | 225 | 120 | 50.2 | 4 | 1287 | 619 | 1 | 220 | XP_013753014.1 uncharacterized protein AMSG_11038 [Thecamonas trahens ATCC 50062] | diamond | 675 | 179 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30613103 | 30613103 | PRJNA453567_P_NODE_23773_length_180_cov_1.608392_g23536_i0 | PRJNA453567 | 23773 | 180 | 1.608392 | 2.8951056 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 41.6 | 0.041 | NR | XP_013760437.1 | 461836 | g23536 | i0 | 38 | 0.833333333333333 | 50 | 31 | 83.3 | 0 | 152 | 3 | 312 | 361 | XP_013760437.1 uncharacterized protein AMSG_03102 [Thecamonas trahens ATCC 50062] | diamond | 150 | 41.6 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31483061 | 31483061 | PRJNA453567_P_NODE_11336_length_277_cov_1.458333_g11099_i0 | PRJNA453567 | 11336 | 277 | 1.458333 | 4.03958241 | root | 1 | Root_unresolved | Root_unresolved | 43.9 | 0.0111 | NR | XP_013760082.1 | 461836 | g11099 | i0 | 50 | 1.75451263537906 | 42 | 17 | 41.2 | 1 | 160 | 273 | 1 | 42 | XP_013760082.1 methionine-R-sulfoxide reductase [Thecamonas trahens ATCC 50062] | diamond | 486 | 43.9 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31719652 | 31719652 | PRJNA453567_P_NODE_26697_length_170_cov_0.872180_g26460_i0 | PRJNA453567 | 26697 | 170 | 0.87218 | 1.482706 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 41.2 | 0.0499 | NR | XP_013754761.1 | 461836 | g26460 | i0 | 40 | 1.39411764705882 | 55 | 28 | 97.1 | 1 | 168 | 4 | 837 | 886 | XP_013754761.1 uncharacterized protein AMSG_09394 [Thecamonas trahens ATCC 50062] | diamond | 237 | 41.2 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31782721 | 31782721 | PRJNA453567_P_NODE_12497_length_261_cov_1.566964_g12260_i0 | PRJNA453567 | 12497 | 261 | 1.566964 | 4.08977604 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 71.2 | 4.33e-12 | NR | XP_013758568.1 | 461836 | g12260 | i0 | 43.3 | 1.03448275862069 | 90 | 44 | 97.7 | 3 | 3 | 257 | 1116 | 1203 | XP_013758568.1 uncharacterized protein AMSG_04901 [Thecamonas trahens ATCC 50062] | diamond | 270 | 71.2 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31830547 | 31830547 | PRJNA453567_P_NODE_2437_length_724_cov_2.965066_g2258_i0 | PRJNA453567 | 2437 | 724 | 2.965066 | 21.46707784 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 51.6 | 0.00169 | NR | XP_013756559.1 | 461836 | g2258 | i0 | 25.4 | 2.26657458563536 | 197 | 116 | 80.4 | 3 | 100 | 681 | 614 | 782 | XP_013756559.1 uncharacterized protein AMSG_12028 [Thecamonas trahens ATCC 50062] | diamond | 1641 | 51.6 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32067528 | 32067528 | PRJNA453567_P_NODE_15978_length_225_cov_1.452128_g15741_i0 | PRJNA453567 | 15978 | 225 | 1.452128 | 3.267288 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 46.2 | 0.00179 | NR | XP_013757550.1 | 461836 | g15741 | i0 | 43.5 | 0.826666666666667 | 62 | 31 | 82.7 | 2 | 190 | 5 | 554 | 611 | XP_013757550.1 ACS4 protein [Thecamonas trahens ATCC 50062] | diamond | 186 | 46.2 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32289506 | 32289506 | PRJNA453567_P_NODE_15339_length_230_cov_2.626943_g15102_i0 | PRJNA453567 | 15339 | 230 | 2.626943 | 6.0419689 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 82 | 4.66e-16 | NR | XP_013756676.1 | 461836 | g15102 | i0 | 62.5 | 0.834782608695652 | 64 | 24 | 83.5 | 0 | 229 | 38 | 614 | 677 | XP_013756676.1 uncharacterized protein AMSG_12048 [Thecamonas trahens ATCC 50062] | diamond | 192 | 82 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32463690 | 32463690 | PRJNA453567_P_NODE_23479_length_181_cov_1.861111_g23242_i0 | PRJNA453567 | 23479 | 181 | 1.861111 | 3.36861091 | root | 1 | Root_unresolved | Root_unresolved | 58.2 | 3e-8 | NR | XP_013760043.1 | 461836 | g23242 | i0 | 50.8 | 3.77900552486188 | 59 | 28 | 96.1 | 1 | 177 | 4 | 11 | 69 | XP_013760043.1 uncharacterized protein AMSG_03193 [Thecamonas trahens ATCC 50062] | diamond | 684 | 58.2 | 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);;