contig_metadata
4 rows where analysis = "diamond", bioproject = "PRJNA1233317" and tax_phylum = "Discosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22012394 | 22012394 | PRJNA1233317_S_NODE_7258_length_283_cov_3.241071_g7222_i0 | PRJNA1233317 | 7258 | 283 | 3.241071 | 9.17223093 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 91.3 | 6.45e-22 | NR | XP_004339811.1 | 1257118 | g7222 | i0 | 79.6 | 0.57243816254417 | 54 | 9 | 55.1 | 1 | 283 | 128 | 20 | 73 | XP_004339811.1 ribonucleotide reductase [Acanthamoeba castellanii str. Neff] | diamond | 162 | 91.3 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29819816 | 29819816 | PRJNA1233317_S_NODE_4951_length_319_cov_7.511538_g4915_i0 | PRJNA1233317 | 4951 | 319 | 7.511538 | 23.96180622 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 70.5 | 2.32e-12 | NR | XP_004341175.1 | 1257118 | g4915 | i0 | 46.3 | 0.630094043887147 | 67 | 36 | 63 | 0 | 3 | 203 | 122 | 188 | XP_004341175.1 uncharacterized protein ACA1_323420 [Acanthamoeba castellanii str. Neff] | diamond | 201 | 70.5 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30230715 | 30230715 | PRJNA1233317_S_NODE_6692_length_291_cov_2.633621_g6656_i0 | PRJNA1233317 | 6692 | 291 | 2.633621 | 7.66383711 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 111 | 4.15e-27 | NR | XP_004333197.1 | 1257118 | g6656 | i0 | 59.8 | 1 | 97 | 37 | 99 | 2 | 2 | 289 | 205 | 300 | XP_004333197.1 oxidoreductase, short chain dehydrogenase/reductase superfamily protein [Acanthamoeba castellanii str. Neff] | diamond | 291 | 111 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 32728005 | 32728005 | PRJNA1233317_S_NODE_6100_length_300_cov_3.639004_g6064_i0 | PRJNA1233317 | 6100 | 300 | 3.639004 | 10.917012 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 72.4 | 2.1e-12 | NR | XP_004334335.1 | 1257118 | g6064 | i0 | 66.1 | 0.59 | 59 | 15 | 59 | 2 | 12 | 188 | 306 | 359 | XP_004334335.1 actin related protein 2/3 complex, 41 kDa subunit [Acanthamoeba castellanii str. Neff] | diamond | 177 | 72.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;