contig_metadata
3 rows where analysis = "diamond", bioproject = "PRJNA1092581" and tax_phylum = "Annelida"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9124302 | 9124302 | PRJNA1092581_P_NODE_34128_length_472_cov_2.601504_g33596_i0 | PRJNA1092581 | 34128 | 472 | 2.601504 | 12.27909888 | Metazoa | 33208 | Annelida | Annelida | 185 | 9.83e-57 | NR | ABW90355.1 | 6446 | g33596 | i0 | 65.5 | 13.2902542372881 | 142 | 49 | 90.3 | 0 | 459 | 34 | 27 | 168 | ABW90355.1 putative ribosomal protein L23a [Sipunculus nudus] | diamond | 6273 | 186 | 0.99462365591397806 | Eukaryota | Opisthokonta | Metazoa | Annelida | Sipuncula | Golfingiida | Sipunculidae | Sipunculus | Sipunculus nudus | |
| 19323690 | 19323690 | PRJNA1092581_P_NODE_84356_length_280_cov_2.975845_g83823_i0 | PRJNA1092581 | 84356 | 280 | 2.975845 | 8.332366 | Polychaeta | 6341 | Annelida | Annelida | 78.6 | 4.17e-15 | NR | CAH1777065.1 | 6347 | g83823 | i0 | 68.6 | 1.08214285714286 | 51 | 16 | 54.6 | 0 | 119 | 271 | 70 | 120 | CAH1777065.1 unnamed protein product [Owenia fusiformis] | diamond | 303 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 26655825 | 26655825 | PRJNA1092581_P_NODE_64941_length_327_cov_2.448819_g64408_i0 | PRJNA1092581 | 64941 | 327 | 2.448819 | 8.00763813 | Helobdella robusta | 6412 | Annelida | Annelida | 58.9 | 2.11e-7 | NR | XP_009027794.1 | 6412 | g64408 | i0 | 41 | 5.91743119266055 | 83 | 49 | 76.1 | 0 | 325 | 77 | 156 | 238 | XP_009027794.1 hypothetical protein HELRODRAFT_187454 [Helobdella robusta] | diamond | 1935 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta |
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);;