contig_metadata
18 rows where bioproject = "PRJNA857143", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2119296 | 2119296 | PRJNA857143_S_NODE_21882_length_515_cov_27.176471_g20796_i0 | PRJNA857143 | 21882 | 515 | 27.176471 | 139.95882565 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 227 | 3.5399999999999996e-72 | NR | XP_013754328.1 | 461836 | g20796 | i0 | 71.1 | 3.47766990291262 | 149 | 42 | 86.2 | 1 | 4 | 447 | 94 | 242 | XP_013754328.1 60S ribosomal protein L7 [Thecamonas trahens ATCC 50062] | diamond | 1791 | 227 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 5947471 | 5947471 | PRJNA857143_S_NODE_58945_length_375_cov_4.741722_g57852_i0 | PRJNA857143 | 58945 | 375 | 4.741722 | 17.7814575 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 153 | 6.85e-44 | NR | XP_013754328.1 | 461836 | g57852 | i0 | 62.6 | 1.84 | 115 | 42 | 91.2 | 1 | 374 | 33 | 127 | 241 | XP_013754328.1 60S ribosomal protein L7 [Thecamonas trahens ATCC 50062] | diamond | 690 | 153 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 7222062 | 7222062 | PRJNA857143_S_NODE_24846_length_494_cov_19.313539_g23757_i0 | PRJNA857143 | 24846 | 494 | 19.313539 | 95.40888266 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 131 | 4.37e-36 | NR | XP_013758175.1 | 461836 | g23757 | i0 | 65 | 11.1801619433198 | 103 | 36 | 62.6 | 0 | 31 | 339 | 4 | 106 | XP_013758175.1 small subunit ribosomal protein S24e [Thecamonas trahens ATCC 50062] | diamond | 5523 | 132 | 0.992424242424242 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 12322708 | 12322708 | PRJNA857143_S_NODE_16990_length_561_cov_37.471311_g15924_i0 | PRJNA857143 | 16990 | 561 | 37.471311 | 210.21405471 | Podomonas magna | 2925398 | Root_unresolved | Root_unresolved | 207 | 1.11e-48 | NTclustered | gi|2206682163|gb|OM966636.1| | 2925398 | g15924 | i0 | 87.363 | 37.7344028520499 | 182 | 21 | 32 | 2 | 1 | 182 | 5809 | 5988 | Podomonas magna strain CCAP19014 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 21169 | 207 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Podomonas | Podomonas magna | ||||
| 14872582 | 14872582 | PRJNA857143_S_NODE_96152_length_317_cov_3.450820_g95059_i0 | PRJNA857143 | 96152 | 317 | 3.45082 | 10.9390994 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 69.4 | 2.95e-7 | NTclustered | gi|923135822|ref|XM_013905923.1| | 461836 | g95059 | i0 | 97.5 | 0.236593059936909 | 40 | 1 | 13 | 0 | 226 | 265 | 1513 | 1474 | Thecamonas trahens ATCC 50062 phosphatidylinositol 3-and 4-kinase (AMSG_01873), partial mRNA | blastn | 75 | 69.4 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 19970166 | 19970166 | PRJNA857143_S_NODE_175996_length_250_cov_1.056497_g174903_i0 | PRJNA857143 | 175996 | 250 | 1.056497 | 2.6412425 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 207 | 4.57e-49 | NTclustered | gi|761380055|ref|NC_026452.1| | 529818 | g174903 | i0 | 82.041 | 87.672 | 245 | 42 | 97 | 2 | 1 | 243 | 786 | 542 | Thecamonas trahens strain ATCC 50062 mitochondrion, complete genome | blastn | 21918 | 207 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 22520145 | 22520145 | PRJNA857143_S_NODE_161558_length_258_cov_1.264865_g160465_i0 | PRJNA857143 | 161558 | 258 | 1.264865 | 3.2633517 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 60.2 | 1.4e-4 | NTclustered | gi|923133852|ref|XM_013904938.1| | 461836 | g160465 | i0 | 100 | 3.41472868217054 | 32 | 0 | 12 | 0 | 49 | 80 | 263 | 232 | Thecamonas trahens ATCC 50062 uncharacterized protein (AMSG_03055), partial mRNA | blastn | 881 | 60.2 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 23795431 | 23795431 | PRJNA857143_S_NODE_142739_length_272_cov_1.959799_g141646_i0 | PRJNA857143 | 142739 | 272 | 1.959799 | 5.33065328 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 60.1 | 2.4e-9 | NR | XP_013760378.1 | 461836 | g141646 | i0 | 47.3 | 0.606617647058823 | 55 | 26 | 60.7 | 1 | 2 | 166 | 45 | 96 | XP_013760378.1 uncharacterized protein AMSG_03040 [Thecamonas trahens ATCC 50062] | diamond | 165 | 60.1 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27149442 | 27149442 | PRJNA857143_S_NODE_118182_length_294_cov_1.710407_g117089_i0 | PRJNA857143 | 118182 | 294 | 1.710407 | 5.02859658 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 48.1 | 8.87e-4 | NR | XP_013754456.1 | 461836 | g117089 | i0 | 31.6 | 0.775510204081633 | 76 | 47 | 77.6 | 1 | 294 | 67 | 644 | 714 | XP_013754456.1 uncharacterized protein AMSG_08923 [Thecamonas trahens ATCC 50062] | diamond | 228 | 48.1 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27212918 | 27212918 | PRJNA857143_S_NODE_123842_length_289_cov_1.083333_g122749_i0 | PRJNA857143 | 123842 | 289 | 1.083333 | 3.13083237 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 69.7 | 2.1e-11 | NR | XP_013759472.1 | 461836 | g122749 | i0 | 47.3 | 0.768166089965398 | 74 | 39 | 76.8 | 0 | 61 | 282 | 422 | 495 | XP_013759472.1 major facilitator superfamily transporter MFS_1 [Thecamonas trahens ATCC 50062] | diamond | 222 | 69.7 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27276419 | 27276419 | PRJNA857143_S_NODE_189743_length_244_cov_1.157895_g188650_i0 | PRJNA857143 | 189743 | 244 | 1.157895 | 2.8252638 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 68.6 | 8.63e-12 | NR | XP_013753014.1 | 461836 | g188650 | i0 | 47.2 | 0.885245901639344 | 72 | 36 | 88.5 | 2 | 16 | 231 | 152 | 221 | XP_013753014.1 uncharacterized protein AMSG_11038 [Thecamonas trahens ATCC 50062] | diamond | 216 | 68.6 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27308116 | 27308116 | PRJNA857143_S_NODE_19023_length_540_cov_3.310493_g17946_i0 | PRJNA857143 | 19023 | 540 | 3.310493 | 17.8766622 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 99.8 | 4.4899999999999997e-23 | NR | XP_013758370.1 | 461836 | g17946 | i0 | 42.1 | 0.672222222222222 | 121 | 70 | 67.2 | 0 | 11 | 373 | 28 | 148 | XP_013758370.1 uncharacterized protein AMSG_04698 [Thecamonas trahens ATCC 50062] | diamond | 363 | 99.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27718902 | 27718902 | PRJNA857143_S_NODE_26844_length_482_cov_6.520782_g25752_i0 | PRJNA857143 | 26844 | 482 | 6.520782 | 31.43016924 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 112 | 6.53e-28 | NR | XP_013758125.1 | 461836 | g25752 | i0 | 54.5 | 0.628630705394191 | 101 | 46 | 62.9 | 0 | 480 | 178 | 93 | 193 | XP_013758125.1 lipocalin family protein [Thecamonas trahens ATCC 50062] | diamond | 303 | 112 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27781740 | 27781740 | PRJNA857143_S_NODE_176264_length_250_cov_0.881356_g175171_i0 | PRJNA857143 | 176264 | 250 | 0.881356 | 2.20339 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 56.2 | 7.08e-7 | NR | XP_013757138.1 | 461836 | g175171 | i0 | 49.2 | 0.78 | 65 | 27 | 78 | 2 | 5 | 199 | 403 | 461 | XP_013757138.1 serine hydroxymethyltransferase [Thecamonas trahens ATCC 50062] | diamond | 195 | 56.2 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29549558 | 29549558 | PRJNA857143_S_NODE_148710_length_267_cov_5.144330_g147617_i0 | PRJNA857143 | 148710 | 267 | 5.14433 | 13.7353611 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 80.5 | 1.83e-16 | NR | XP_013758125.1 | 461836 | g147617 | i0 | 54.3 | 0.910112359550562 | 81 | 35 | 89.9 | 2 | 241 | 2 | 27 | 106 | XP_013758125.1 lipocalin family protein [Thecamonas trahens ATCC 50062] | diamond | 243 | 80.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29928878 | 29928878 | PRJNA857143_S_NODE_21651_length_517_cov_7.677928_g20566_i0 | PRJNA857143 | 21651 | 517 | 7.677928 | 39.69488776 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 214 | 7.33e-66 | NR | XP_013760592.1 | 461836 | g20566 | i0 | 64.2 | 0.940038684719536 | 162 | 55 | 93.4 | 2 | 2 | 484 | 181 | 340 | XP_013760592.1 adenine nucleotide translocator [Thecamonas trahens ATCC 50062] | diamond | 486 | 214 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30094679 | 30094679 | PRJNA857143_S_NODE_126252_length_286_cov_3.215962_g125159_i0 | PRJNA857143 | 126252 | 286 | 3.215962 | 9.19765132 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 57.4 | 2.23e-7 | NR | XP_013754463.1 | 461836 | g125159 | i0 | 31.9 | 3.60839160839161 | 72 | 41 | 67.1 | 1 | 17 | 208 | 133 | 204 | XP_013754463.1 group XIIA secretory phospholipase A2 [Thecamonas trahens ATCC 50062] | diamond | 1032 | 57.4 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31635231 | 31635231 | PRJNA857143_S_NODE_57896_length_378_cov_1.022951_g56803_i0 | PRJNA857143 | 57896 | 378 | 1.022951 | 3.86675478 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 51.2 | 1.82e-4 | NR | XP_013762065.1 | 461836 | g56803 | i0 | 36.8 | 0.53968253968254 | 68 | 42 | 54 | 1 | 375 | 172 | 636 | 702 | XP_013762065.1 phospholipase C delta isoform [Thecamonas trahens ATCC 50062] | diamond | 204 | 51.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);;