contig_metadata
3 rows where analysis = "diamond", bioproject = "PRJNA1195551" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27388714 | 27388714 | PRJNA1195551_S_NODE_8643_length_311_cov_1.519084_g8290_i0 | PRJNA1195551 | 8643 | 311 | 1.519084 | 4.72435124 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 63.9 | 1.92e-10 | NR | KAI0218681.1 | 104711 | g8290 | i0 | 44.2 | 0.742765273311897 | 77 | 36 | 73.3 | 3 | 1 | 228 | 55 | 125 | KAI0218681.1 Profilin [Lamellibrachia satsuma] | diamond | 231 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 28177634 | 28177634 | PRJNA1195551_S_NODE_38426_length_166_cov_0.863248_g38073_i0 | PRJNA1195551 | 38426 | 166 | 0.863248 | 1.43299168 | Cossura aciculata | 3162496 | Annelida | Annelida | 43.9 | 0.005 | NR | XOU09021.1 | 3162496 | g38073 | i0 | 90.9 | 31.8072289156627 | 22 | 2 | 39.8 | 0 | 126 | 61 | 201 | 222 | XOU09021.1 cytochrome c oxidase subunit 3 [Cossura aciculata] | diamond | 5280 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Cossuridae | Cossura | Cossura aciculata | ||
| 32632915 | 32632915 | PRJNA1195551_S_NODE_8700_length_310_cov_2.846743_g8347_i0 | PRJNA1195551 | 8700 | 310 | 2.846743 | 8.8249033 | Imetescolex patriarchalis | 1537933 | Annelida | Annelida | 103 | 2.3499999999999994e-23 | NR | XNY95961.1 | 1537933 | g8347 | i0 | 78.1 | 1.23870967741935 | 64 | 12 | 61.9 | 1 | 118 | 309 | 498 | 559 | XNY95961.1 NADH dehydrogenase subunit 5 [Imetescolex patriarchalis] | diamond | 384 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Imetescolex | Imetescolex patriarchalis |
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);;