contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJEB81171" and tax_clade = "Discoba"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17990881 | 17990881 | PRJEB81171_P_NODE_1615_length_520_cov_1.040268_g1492_i0 | PRJEB81171 | 1615 | 520 | 1.040268 | 5.4093936 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 191 | 9.789999999999996e-55 | NR | XP_044566001.1 | 5763 | g1492 | i0 | 57.8 | 3.99230769230769 | 173 | 73 | 99.8 | 0 | 1 | 519 | 73 | 245 | XP_044566001.1 uncharacterized protein FDP41_012548 [Naegleria fowleri] | diamond | 2076 | 192 | 0.994791666666667 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 28069286 | 28069286 | PRJEB81171_P_NODE_8285_length_250_cov_0.881356_g8158_i0 | PRJEB81171 | 8285 | 250 | 0.881356 | 2.20339 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 121 | 7.46e-30 | NR | XP_044548617.1 | 51637 | g8158 | i0 | 65.1 | 5.976 | 83 | 29 | 99.6 | 0 | 2 | 250 | 866 | 948 | XP_044548617.1 uncharacterized protein C9374_004905 [Naegleria lovaniensis] | diamond | 1494 | 121 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 28739656 | 28739656 | PRJEB81171_P_NODE_6187_length_276_cov_1.339901_g6060_i0 | PRJEB81171 | 6187 | 276 | 1.339901 | 3.69812676 | Leishmania donovani | 5661 | Euglenozoa | other_Eukaryota | 48.1 | 7.15e-4 | NR | TPP40392.1 | 5661 | g6060 | i0 | 45.2 | 0.91304347826087 | 42 | 22 | 44.6 | 1 | 254 | 132 | 979 | 1020 | TPP40392.1 putative integral membrane protein [Leishmania donovani] | diamond | 252 | 48.1 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania donovani | ||
| 29654867 | 29654867 | PRJEB81171_P_NODE_7110_length_261_cov_1.569149_g6983_i0 | PRJEB81171 | 7110 | 261 | 1.569149 | 4.09547889 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 59.3 | 6.55e-8 | NR | XP_044560734.1 | 5763 | g6983 | i0 | 36 | 3.82758620689655 | 89 | 53 | 97.7 | 3 | 6 | 260 | 405 | 493 | XP_044560734.1 uncharacterized protein FDP41_004697 [Naegleria fowleri] | diamond | 999 | 59.3 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 30697656 | 30697656 | PRJEB81171_P_NODE_6794_length_266_cov_1.590674_g6667_i0 | PRJEB81171 | 6794 | 266 | 1.590674 | 4.23119284 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 58.2 | 1.87e-7 | NR | CAG4716594.1 | 5763 | g6667 | i0 | 38.6 | 0.992481203007519 | 88 | 52 | 97 | 1 | 8 | 265 | 589 | 676 | CAG4716594.1 unnamed protein product [Naegleria fowleri] | diamond | 264 | 58.2 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 31290746 | 31290746 | PRJEB81171_P_NODE_8095_length_251_cov_0.876404_g7968_i0 | PRJEB81171 | 8095 | 251 | 0.876404 | 2.19977404 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 62.8 | 1.72e-9 | NR | XP_002671304.1 | 5762 | g7968 | i0 | 38.4 | 4.24302788844621 | 73 | 45 | 87.3 | 0 | 29 | 247 | 112 | 184 | XP_002671304.1 uncharacterized protein NAEGRDRAFT_73614 [Naegleria gruberi] | diamond | 1065 | 63.2 | 0.993670886075949 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 32752573 | 32752573 | PRJEB81171_P_NODE_2800_length_395_cov_0.968944_g2673_i0 | PRJEB81171 | 2800 | 395 | 0.968944 | 3.8273288 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 105 | 4.01e-24 | NR | XP_044548436.1 | 51637 | g2673 | i0 | 44.6 | 2.76455696202532 | 121 | 59 | 91.9 | 2 | 20 | 382 | 199 | 311 | XP_044548436.1 uncharacterized protein C9374_005337 [Naegleria lovaniensis] | diamond | 1092 | 105 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis |
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);;