contig_metadata
14 rows where bioproject = "PRJNA1102048" and tax_clade = "Apusozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6589818 | 6589818 | PRJNA1102048_P_NODE_17266_length_242_cov_0.911243_g17162_i0 | PRJNA1102048 | 17266 | 242 | 0.911243 | 2.20520806 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 147 | 5.72e-40 | NR | XP_013762089.1 | 461836 | g17162 | i0 | 88.8 | 4.95867768595041 | 80 | 9 | 99.2 | 0 | 1 | 240 | 300 | 379 | XP_013762089.1 inositol-3-phosphate synthase [Thecamonas trahens ATCC 50062] | diamond | 1200 | 147 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 26655919 | 26655919 | PRJNA1102048_P_NODE_14841_length_247_cov_0.885057_g14737_i0 | PRJNA1102048 | 14841 | 247 | 0.885057 | 2.18609079 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 73.2 | 7.21e-13 | NR | XP_013759355.1 | 461836 | g14737 | i0 | 57.1 | 1.31174089068826 | 56 | 24 | 68 | 0 | 200 | 33 | 545 | 600 | XP_013759355.1 uncharacterized protein AMSG_04107 [Thecamonas trahens ATCC 50062] | diamond | 324 | 73.2 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27193990 | 27193990 | PRJNA1102048_P_NODE_9922_length_279_cov_1.509709_g9818_i0 | PRJNA1102048 | 9922 | 279 | 1.509709 | 4.21208811 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 83.2 | 2.04e-16 | NR | XP_013761142.1 | 461836 | g9818 | i0 | 48.8 | 0.903225806451613 | 84 | 43 | 90.3 | 0 | 278 | 27 | 210 | 293 | XP_013761142.1 pyoverdine biosynthesis regulatory [Thecamonas trahens ATCC 50062] | diamond | 252 | 83.2 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27257311 | 27257311 | PRJNA1102048_P_NODE_5903_length_355_cov_1.638298_g5799_i0 | PRJNA1102048 | 5903 | 355 | 1.638298 | 5.8159579 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 130 | 1.56e-32 | NR | XP_013754662.1 | 461836 | g5799 | i0 | 68.8 | 2.51830985915493 | 93 | 29 | 78.6 | 0 | 2 | 280 | 623 | 715 | XP_013754662.1 Cyp27a1 protein [Thecamonas trahens ATCC 50062] | diamond | 894 | 130 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27825894 | 27825894 | PRJNA1102048_P_NODE_16464_length_243_cov_1.358824_g16360_i0 | PRJNA1102048 | 16464 | 243 | 1.358824 | 3.30194232 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 68.6 | 2.97e-11 | NR | XP_013754965.1 | 461836 | g16360 | i0 | 45.3 | 1.06172839506173 | 86 | 32 | 98.8 | 2 | 2 | 241 | 359 | 435 | XP_013754965.1 transketolase domain-containing protein [Thecamonas trahens ATCC 50062] | diamond | 258 | 68.6 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28078274 | 28078274 | PRJNA1102048_P_NODE_11925_length_257_cov_3.755435_g11821_i0 | PRJNA1102048 | 11925 | 257 | 3.755435 | 9.65146795 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 86.7 | 7.1e-20 | NR | XP_013760378.1 | 461836 | g11821 | i0 | 53.2 | 0.898832684824903 | 77 | 36 | 89.9 | 0 | 25 | 255 | 5 | 81 | XP_013760378.1 uncharacterized protein AMSG_03040 [Thecamonas trahens ATCC 50062] | diamond | 231 | 86.7 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28078292 | 28078292 | PRJNA1102048_P_NODE_6145_length_348_cov_1.429091_g6041_i0 | PRJNA1102048 | 6145 | 348 | 1.429091 | 4.97323668 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 142 | 4.87e-40 | NR | XP_013753590.1 | 461836 | g6041 | i0 | 61.1 | 1.92241379310345 | 113 | 42 | 96.6 | 2 | 2 | 337 | 98 | 209 | XP_013753590.1 actin-family protein 2/3 complex subunit 3 [Thecamonas trahens ATCC 50062] | diamond | 669 | 142 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28299330 | 28299330 | PRJNA1102048_P_NODE_15986_length_244_cov_0.959064_g15882_i0 | PRJNA1102048 | 15986 | 244 | 0.959064 | 2.34011616 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 75.5 | 7.82e-14 | NR | XP_013760274.1 | 461836 | g15882 | i0 | 45.6 | 0.971311475409836 | 79 | 42 | 97.1 | 1 | 242 | 6 | 204 | 281 | XP_013760274.1 deoxyribonuclease II family protein [Thecamonas trahens ATCC 50062] | diamond | 237 | 75.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28353820 | 28353820 | PRJNA1102048_P_NODE_16006_length_244_cov_0.900585_g15902_i0 | PRJNA1102048 | 16006 | 244 | 0.900585 | 2.1974274 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 2.38e-6 | NR | XP_013760945.1 | 461836 | g15902 | i0 | 50 | 3.68852459016393 | 44 | 20 | 51.6 | 1 | 225 | 100 | 16 | 59 | XP_013760945.1 major vault protein [Thecamonas trahens ATCC 50062] | diamond | 900 | 54.7 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28488907 | 28488907 | PRJNA1102048_P_NODE_8227_length_303_cov_2.304348_g8123_i0 | PRJNA1102048 | 8227 | 303 | 2.304348 | 6.98217444 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 58.2 | 7.95e-8 | NR | XP_013762493.1 | 461836 | g8123 | i0 | 33.8 | 0.792079207920792 | 80 | 53 | 79.2 | 0 | 286 | 47 | 11 | 90 | XP_013762493.1 uncharacterized protein AMSG_00767 [Thecamonas trahens ATCC 50062] | diamond | 240 | 58.2 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30193929 | 30193929 | PRJNA1102048_P_NODE_16272_length_244_cov_0.900585_g16168_i0 | PRJNA1102048 | 16272 | 244 | 0.900585 | 2.1974274 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 49.3 | 1.9e-4 | NR | XP_013754234.1 | 461836 | g16168 | i0 | 45.5 | 0.676229508196721 | 55 | 29 | 67.6 | 1 | 1 | 165 | 193 | 246 | XP_013754234.1 uncharacterized protein AMSG_09805 [Thecamonas trahens ATCC 50062] | diamond | 165 | 49.3 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30320974 | 30320974 | PRJNA1102048_P_NODE_14932_length_246_cov_2.213873_g14828_i0 | PRJNA1102048 | 14932 | 246 | 2.213873 | 5.44612758 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 114 | 3.39e-27 | NR | XP_013754784.1 | 461836 | g14828 | i0 | 68.8 | 0.975609756097561 | 80 | 25 | 97.6 | 0 | 245 | 6 | 180 | 259 | XP_013754784.1 major vault protein [Thecamonas trahens ATCC 50062] | diamond | 240 | 114 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31616268 | 31616268 | PRJNA1102048_P_NODE_876_length_780_cov_2.702970_g784_i0 | PRJNA1102048 | 876 | 780 | 2.70297 | 21.083166 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 84.7 | 1.94e-14 | NR | XP_013757898.1 | 461836 | g784 | i0 | 32.9 | 0.665384615384615 | 173 | 98 | 65.8 | 7 | 72 | 584 | 3046 | 3202 | XP_013757898.1 uncharacterized protein AMSG_05495 [Thecamonas trahens ATCC 50062] | diamond | 519 | 84.7 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32439143 | 32439143 | PRJNA1102048_P_NODE_7699_length_313_cov_1.870833_g7595_i0 | PRJNA1102048 | 7699 | 313 | 1.870833 | 5.85570729 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 150 | 2.26e-40 | NR | XP_013759182.1 | 461836 | g7595 | i0 | 64.4 | 0.996805111821086 | 104 | 35 | 99.7 | 1 | 312 | 1 | 269 | 370 | XP_013759182.1 peptidase S8 and S53 domain-containing protein [Thecamonas trahens ATCC 50062] | diamond | 312 | 150 | 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);;