contig_metadata
5 rows where analysis = "diamond", bioproject = "PRJNA596870" and tax_phylum = "Heterolobosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10772395 | 10772395 | PRJNA596870_P_NODE_11449_length_377_cov_1.013158_g11316_i0 | PRJNA596870 | 11449 | 377 | 1.013158 | 3.81960566 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 211 | 1.27e-65 | NR | XP_044557880.1 | 5763 | g11316 | i0 | 80.8 | 2.9840848806366 | 125 | 24 | 99.5 | 0 | 2 | 376 | 17 | 141 | XP_044557880.1 uncharacterized protein FDP41_008374 [Naegleria fowleri] | diamond | 1125 | 211 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 26921623 | 26921623 | PRJNA596870_P_NODE_29682_length_251_cov_0.865169_g29549_i0 | PRJNA596870 | 29682 | 251 | 0.865169 | 2.17157419 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 107 | 7.71e-28 | NR | KAL0479597.1 | 1008807 | g29549 | i0 | 59 | 1.9840637450199201 | 83 | 34 | 99.2 | 0 | 249 | 1 | 53 | 135 | KAL0479597.1 NAD-dependent protein deacetylase Sirtuin [Acrasis kona] | diamond | 498 | 107 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 27409474 | 27409474 | PRJNA596870_P_NODE_31083_length_249_cov_1.698864_g30950_i0 | PRJNA596870 | 31083 | 249 | 1.698864 | 4.23017136 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 88.2 | 3.82e-18 | NR | XP_044558917.1 | 5763 | g30950 | i0 | 46.3 | 3.96385542168675 | 82 | 44 | 98.8 | 0 | 248 | 3 | 275 | 356 | XP_044558917.1 uncharacterized protein FDP41_006814 [Naegleria fowleri] | diamond | 987 | 88.2 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 29826982 | 29826982 | PRJNA596870_P_NODE_28391_length_254_cov_1.226519_g28258_i0 | PRJNA596870 | 28391 | 254 | 1.226519 | 3.11535826 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 98.2 | 1.22e-22 | NR | XP_002679493.1 | 5762 | g28258 | i0 | 84.2 | 0.673228346456693 | 57 | 8 | 67.3 | 1 | 252 | 82 | 86 | 141 | XP_002679493.1 VHP domain-containing protein [Naegleria gruberi] | diamond | 171 | 98.2 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 31881347 | 31881347 | PRJNA596870_P_NODE_29077_length_251_cov_0.865169_g28944_i0 | PRJNA596870 | 29077 | 251 | 0.865169 | 2.17157419 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 80.1 | 2.91e-15 | NR | KAL0483870.1 | 1008807 | g28944 | i0 | 51.2 | 0.9800796812749 | 82 | 39 | 96.8 | 1 | 246 | 4 | 259 | 340 | KAL0483870.1 Nlrc3 [Acrasis kona] | diamond | 246 | 80.1 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona |
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);;