contig_metadata
7 rows where bioproject = "PRJNA431371", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20829771 | 20829771 | PRJNA431371_P_NODE_18877_length_294_cov_2.303167_g18804_i0 | PRJNA431371 | 18877 | 294 | 2.303167 | 6.77131098 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 54.7 | 0.008 | NTclustered | gi|923134970|ref|XM_013905497.1| | 461836 | g18804 | i0 | 100 | 0.193877551020408 | 29 | 0 | 10 | 0 | 255 | 283 | 1916 | 1944 | Thecamonas trahens ATCC 50062 STE/STE11 protein kinase (AMSG_02409), partial mRNA | blastn | 57 | 54.7 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 26886112 | 26886112 | PRJNA431371_P_NODE_11901_length_365_cov_1.318493_g11828_i0 | PRJNA431371 | 11901 | 365 | 1.318493 | 4.81249945 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 58.9 | 3.09e-7 | NR | XP_013755013.1 | 461836 | g11828 | i0 | 32.6 | 0.731506849315068 | 89 | 51 | 73.2 | 1 | 271 | 5 | 173 | 252 | XP_013755013.1 uncharacterized protein AMSG_12227 [Thecamonas trahens ATCC 50062] | diamond | 267 | 58.9 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 26886136 | 26886136 | PRJNA431371_P_NODE_6321_length_484_cov_1.428224_g6248_i0 | PRJNA431371 | 6321 | 484 | 1.428224 | 6.91260416 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 85.1 | 3.85e-16 | NR | XP_013754609.1 | 461836 | g6248 | i0 | 41.9 | 0.576446280991736 | 93 | 53 | 57.6 | 1 | 7 | 285 | 68 | 159 | XP_013754609.1 uncharacterized protein AMSG_09209 [Thecamonas trahens ATCC 50062] | diamond | 279 | 85.1 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29145207 | 29145207 | PRJNA431371_P_NODE_7869_length_440_cov_1.258856_g7796_i0 | PRJNA431371 | 7869 | 440 | 1.258856 | 5.5389664 | root | 1 | Root_unresolved | Root_unresolved | 53.9 | 3.92e-5 | NR | XP_013754026.1 | 461836 | g7796 | i0 | 36.4 | 3.59318181818182 | 99 | 61 | 67.5 | 1 | 3 | 299 | 374 | 470 | XP_013754026.1 AtuA protein [Thecamonas trahens ATCC 50062] | diamond | 1581 | 53.9 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29570313 | 29570313 | PRJNA431371_P_NODE_11230_length_374_cov_2.737542_g11157_i0 | PRJNA431371 | 11230 | 374 | 2.737542 | 10.23840708 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 174 | 4.24e-50 | NR | XP_013753190.1 | 461836 | g11157 | i0 | 61.2 | 1.11497326203209 | 139 | 39 | 99.5 | 2 | 372 | 1 | 224 | 362 | XP_013753190.1 uncharacterized protein AMSG_12392 [Thecamonas trahens ATCC 50062] | diamond | 417 | 174 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29981025 | 29981025 | PRJNA431371_P_NODE_691_length_1046_cov_1.431655_g634_i0 | PRJNA431371 | 691 | 1046 | 1.431655 | 14.9751113 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 155 | 1.1e-37 | NR | XP_013753710.1 | 461836 | g634 | i0 | 34.9 | 1.83269598470363 | 315 | 187 | 89.2 | 7 | 1025 | 93 | 3955 | 4255 | XP_013753710.1 dynein-1-alpha heavy chain [Thecamonas trahens ATCC 50062] | diamond | 1917 | 155 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30170411 | 30170411 | PRJNA431371_P_NODE_232_length_1470_cov_2.076593_g194_i0 | PRJNA431371 | 232 | 1470 | 2.076593 | 30.5259171 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 218 | 5.2e-59 | NR | XP_013754426.1 | 461836 | g194 | i0 | 47.4 | 0.508163265306122 | 249 | 123 | 49.8 | 4 | 734 | 3 | 8 | 253 | XP_013754426.1 uncharacterized protein AMSG_08886 [Thecamonas trahens ATCC 50062] | diamond | 747 | 218 | 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);;