contig_metadata
4 rows where analysis = "diamond", bioproject = "PRJNA951412" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16237634 | 16237634 | PRJNA951412_P_NODE_4173_length_252_cov_1.731844_g4088_i0 | PRJNA951412 | 4173 | 252 | 1.731844 | 4.36424688 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 139 | 6.26e-36 | NR | XP_013756049.1 | 461836 | g4088 | i0 | 72.3 | 0.988095238095238 | 83 | 23 | 98.8 | 0 | 2 | 250 | 846 | 928 | XP_013756049.1 NAD-specific glutamate dehydrogenase [Thecamonas trahens ATCC 50062] | diamond | 249 | 139 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29772735 | 29772735 | PRJNA951412_P_NODE_1791_length_341_cov_1.152985_g1706_i0 | PRJNA951412 | 1791 | 341 | 1.152985 | 3.93167885 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 55.5 | 1.33e-7 | NR | XP_013754142.1 | 461836 | g1706 | i0 | 47.7 | 0.387096774193548 | 44 | 23 | 38.7 | 0 | 26 | 157 | 11 | 54 | XP_013754142.1 uncharacterized protein AMSG_09583 [Thecamonas trahens ATCC 50062] | diamond | 132 | 55.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30032250 | 30032250 | PRJNA951412_P_NODE_3191_length_275_cov_1.539604_g3106_i0 | PRJNA951412 | 3191 | 275 | 1.539604 | 4.233911 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 133 | 1.77e-35 | NR | XP_013760592.1 | 461836 | g3106 | i0 | 71.7 | 1.96363636363636 | 92 | 24 | 98.2 | 1 | 272 | 3 | 43 | 134 | XP_013760592.1 adenine nucleotide translocator [Thecamonas trahens ATCC 50062] | diamond | 540 | 134 | 0.992537313432836 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31700720 | 31700720 | PRJNA951412_P_NODE_4337_length_252_cov_0.865922_g4252_i0 | PRJNA951412 | 4337 | 252 | 0.865922 | 2.18212344 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 43.5 | 0.0226 | NR | XP_013754157.1 | 461836 | g4252 | i0 | 39.3 | 0.666666666666667 | 56 | 32 | 64.3 | 1 | 2 | 163 | 632 | 687 | XP_013754157.1 uncharacterized protein AMSG_09601 [Thecamonas trahens ATCC 50062] | diamond | 168 | 43.5 | 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);;