contig_metadata
9 rows where bioproject = "PRJNA1174234" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1590725 | 1590725 | PRJNA1174234_P_NODE_16202_length_343_cov_1.162963_g16006_i0 | PRJNA1174234 | 16202 | 343 | 1.162963 | 3.98896309 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 75.5 | 3.6e-13 | NR | XP_013754475.1 | 461836 | g16006 | i0 | 39.3 | 3.05247813411079 | 117 | 65 | 99.7 | 2 | 342 | 1 | 46 | 159 | XP_013754475.1 uncharacterized protein AMSG_08947 [Thecamonas trahens ATCC 50062] | diamond | 1047 | 75.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 4143074 | 4143074 | PRJNA1174234_P_NODE_33584_length_244_cov_0.900585_g33388_i0 | PRJNA1174234 | 33584 | 244 | 0.900585 | 2.1974274 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 101 | 1.88e-25 | NR | XP_013758175.1 | 461836 | g33388 | i0 | 73.6 | 3.54098360655738 | 72 | 19 | 88.5 | 0 | 1 | 216 | 52 | 123 | XP_013758175.1 small subunit ribosomal protein S24e [Thecamonas trahens ATCC 50062] | diamond | 864 | 102 | 0.990196078431373 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 21992782 | 21992782 | PRJNA1174234_P_NODE_32538_length_246_cov_0.890173_g32342_i0 | PRJNA1174234 | 32538 | 246 | 0.890173 | 2.18982558 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 230 | 9.56e-56 | NTclustered | gi|923124487|ref|XM_013900258.1| | 461836 | g32342 | i0 | 84.549 | 8.36178861788618 | 233 | 34 | 94 | 2 | 15 | 246 | 256 | 25 | Thecamonas trahens ATCC 50062 60S ribosomal protein L44 Q (AMSG_07943), mRNA | blastn | 2057 | 230 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28208996 | 28208996 | PRJNA1174234_P_NODE_29326_length_251_cov_0.865169_g29130_i0 | PRJNA1174234 | 29326 | 251 | 0.865169 | 2.17157419 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 52.8 | 1.22e-5 | NR | XP_013758318.1 | 461836 | g29130 | i0 | 57.5 | 0.47808764940239 | 40 | 17 | 47.8 | 0 | 9 | 128 | 176 | 215 | XP_013758318.1 ubiquitin carboxyl-terminal hydrolase [Thecamonas trahens ATCC 50062] | diamond | 120 | 52.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29566745 | 29566745 | PRJNA1174234_P_NODE_23730_length_283_cov_1.085714_g23534_i0 | PRJNA1174234 | 23730 | 283 | 1.085714 | 3.07257062 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 97.4 | 3.56e-21 | NR | XP_013759900.1 | 461836 | g23534 | i0 | 45.7 | 0.975265017667845 | 92 | 50 | 97.5 | 0 | 280 | 5 | 293 | 384 | XP_013759900.1 monooxygenase [Thecamonas trahens ATCC 50062] | diamond | 276 | 97.4 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30072030 | 30072030 | PRJNA1174234_P_NODE_13432_length_375_cov_2.923841_g13236_i0 | PRJNA1174234 | 13432 | 375 | 2.923841 | 10.96440375 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 120 | 8.520000000000001e-29 | NR | XP_013754710.1 | 461836 | g13236 | i0 | 49.1 | 1.936 | 108 | 48 | 80.8 | 2 | 50 | 352 | 475 | 582 | XP_013754710.1 uncharacterized protein AMSG_09324 [Thecamonas trahens ATCC 50062] | diamond | 726 | 120 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30388522 | 30388522 | PRJNA1174234_P_NODE_20033_length_308_cov_2.038298_g19837_i0 | PRJNA1174234 | 20033 | 308 | 2.038298 | 6.27795784 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 45.8 | 0.00309 | NR | XP_013753243.1 | 461836 | g19837 | i0 | 33.3 | 0.818181818181818 | 84 | 54 | 79.9 | 1 | 308 | 63 | 78 | 161 | XP_013753243.1 uncharacterized protein AMSG_10809 [Thecamonas trahens ATCC 50062] | diamond | 252 | 45.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31430926 | 31430926 | PRJNA1174234_P_NODE_21296_length_299_cov_1.362832_g21100_i0 | PRJNA1174234 | 21296 | 299 | 1.362832 | 4.07486768 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 56.6 | 1e-6 | NR | XP_013756677.1 | 461836 | g21100 | i0 | 68.8 | 0.321070234113712 | 32 | 10 | 32.1 | 0 | 98 | 3 | 479 | 510 | XP_013756677.1 uncharacterized protein AMSG_12049 [Thecamonas trahens ATCC 50062] | diamond | 96 | 56.6 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31652252 | 31652252 | PRJNA1174234_P_NODE_7417_length_503_cov_1.783721_g7221_i0 | PRJNA1174234 | 7417 | 503 | 1.783721 | 8.97211663 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 52.4 | 1.59e-4 | NR | XP_013759479.1 | 461836 | g7221 | i0 | 47.6 | 0.769383697813121 | 63 | 30 | 35.8 | 2 | 29 | 208 | 1 | 63 | XP_013759479.1 uncharacterized protein AMSG_02572 [Thecamonas trahens ATCC 50062] | diamond | 387 | 52.4 | 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);;