contig_metadata
8 rows where bioproject = "PRJEB81463", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3966548 | 3966548 | PRJEB81463_P_NODE_19044_length_257_cov_1.766304_g18772_i0 | PRJEB81463 | 19044 | 257 | 1.766304 | 4.53940128 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 131 | 5.12e-34 | NR | XP_013753872.1 | 461836 | g18772 | i0 | 69.4 | 0.992217898832685 | 85 | 26 | 99.2 | 0 | 1 | 255 | 243 | 327 | XP_013753872.1 isocitrate dehydrogenase [Thecamonas trahens ATCC 50062] | diamond | 255 | 131 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 14168769 | 14168769 | PRJEB81463_P_NODE_1712_length_767_cov_2.384726_g1471_i0 | PRJEB81463 | 1712 | 767 | 2.384726 | 18.29084842 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 69.4 | 7.64e-7 | NTclustered | gi|923118291|ref|XM_013897168.1| | 461836 | g1471 | i0 | 89.474 | 0.475880052151239 | 57 | 3 | 7 | 1 | 565 | 621 | 931 | 878 | Thecamonas trahens ATCC 50062 translation elongation factor Ts (AMSG_11511), partial mRNA | blastn | 365 | 69.4 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 21817455 | 21817455 | PRJEB81463_P_NODE_7858_length_358_cov_4.547368_g7586_i0 | PRJEB81463 | 7858 | 358 | 4.547368 | 16.27957744 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 124 | 1.3e-31 | NR | XP_013760592.1 | 461836 | g7586 | i0 | 60.9 | 7.86871508379888 | 110 | 40 | 91.3 | 2 | 3 | 329 | 233 | 340 | XP_013760592.1 adenine nucleotide translocator [Thecamonas trahens ATCC 50062] | diamond | 2817 | 124 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27508444 | 27508444 | PRJEB81463_P_NODE_4223_length_489_cov_1.406250_g3952_i0 | PRJEB81463 | 4223 | 489 | 1.40625 | 6.8765625 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 86.7 | 1.71e-16 | NR | XP_013760602.1 | 461836 | g3952 | i0 | 36.7 | 0.969325153374233 | 158 | 70 | 96.3 | 4 | 17 | 487 | 2 | 130 | XP_013760602.1 transcription factor lim1, variant [Thecamonas trahens ATCC 50062] | diamond | 474 | 86.7 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28613361 | 28613361 | PRJEB81463_P_NODE_18947_length_258_cov_1.264865_g18675_i0 | PRJEB81463 | 18947 | 258 | 1.264865 | 3.2633517 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 48.5 | 4.28e-4 | NR | XP_013762411.1 | 461836 | g18675 | i0 | 29.5 | 1.1046511627907 | 95 | 53 | 94.2 | 3 | 252 | 10 | 712 | 806 | XP_013762411.1 uncharacterized protein AMSG_00680 [Thecamonas trahens ATCC 50062] | diamond | 285 | 48.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28676630 | 28676630 | PRJEB81463_P_NODE_12967_length_288_cov_1.423256_g12695_i0 | PRJEB81463 | 12967 | 288 | 1.423256 | 4.09897728 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 102 | 4.9199999999999987e-23 | NR | XP_013753152.1 | 461836 | g12695 | i0 | 52.9 | 2.09375 | 102 | 38 | 99 | 3 | 287 | 3 | 326 | 424 | XP_013753152.1 phosphatidylglycerol specific phospholipase C [Thecamonas trahens ATCC 50062] | diamond | 603 | 102 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30128746 | 30128746 | PRJEB81463_P_NODE_13292_length_286_cov_1.450704_g13020_i0 | PRJEB81463 | 13292 | 286 | 1.450704 | 4.14901344 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 87.8 | 5.13e-18 | NR | XP_013761652.1 | 461836 | g13020 | i0 | 46.9 | 1.00699300699301 | 96 | 49 | 98.6 | 1 | 3 | 284 | 118 | 213 | XP_013761652.1 glutaredoxin family protein [Thecamonas trahens ATCC 50062] | diamond | 288 | 87.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32215670 | 32215670 | PRJEB81463_P_NODE_11138_length_304_cov_3.311688_g10866_i0 | PRJEB81463 | 11138 | 304 | 3.311688 | 10.06753152 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 70.1 | 1.8e-11 | NR | XP_013755586.1 | 461836 | g10866 | i0 | 37.7 | 1.04605263157895 | 106 | 59 | 98.7 | 3 | 304 | 5 | 339 | 443 | XP_013755586.1 pregnancy-associated glycoprotein 6 [Thecamonas trahens ATCC 50062] | diamond | 318 | 70.1 | 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);;