contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJEB2925" and tax_phylum = "Cnidaria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3852208 | 3852208 | PRJEB2925_P_NODE_12404_length_304_cov_1.553903_g11127_i0 | PRJEB2925 | 12404 | 304 | 1.553903 | 4.72386512 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 67.8 | 3.05e-12 | NR | CAB4019690.1 | 317549 | g11127 | i0 | 52.4 | 2.64473684210526 | 63 | 30 | 62.2 | 0 | 302 | 114 | 27 | 89 | CAB4019690.1 60S ribosomal L4-1, partial [Paramuricea clavata] | diamond | 804 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 14054281 | 14054281 | PRJEB2925_P_NODE_4912_length_615_cov_2.175862_g3914_i0 | PRJEB2925 | 4912 | 615 | 2.175862 | 13.3815513 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 191 | 5.919999999999999e-57 | NR | XP_057289659.1 | 13093 | g3914 | i0 | 66.4 | 16.0536585365854 | 152 | 49 | 74.1 | 1 | 143 | 598 | 63 | 212 | XP_057289659.1 60S ribosomal protein L7a-like [Hydractinia symbiolongicarpus] | diamond | 9873 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 26653098 | 26653098 | PRJEB2925_P_NODE_14561_length_267_cov_1.732759_g13283_i0 | PRJEB2925 | 14561 | 267 | 1.732759 | 4.62646653 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 79 | 9.38e-15 | NR | XP_066918755.1 | 252671 | g13283 | i0 | 54.5 | 0.98876404494382 | 88 | 40 | 98.9 | 0 | 4 | 267 | 716 | 803 | XP_066918755.1 major vault protein-like isoform X2 [Clytia hemisphaerica] | diamond | 264 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 28416526 | 28416526 | PRJEB2925_P_NODE_10206_length_360_cov_1.516923_g8934_i0 | PRJEB2925 | 10206 | 360 | 1.516923 | 5.4609228 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 52.8 | 3.78e-5 | NR | XP_031551396.1 | 6105 | g8934 | i0 | 56.8 | 6.7 | 37 | 16 | 30.8 | 0 | 131 | 21 | 211 | 247 | XP_031551396.1 uncharacterized protein LOC116288709 [Actinia tenebrosa] | diamond | 2412 | 53.1 | 0.994350282485876 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 30626925 | 30626925 | PRJEB2925_P_NODE_6673_length_501_cov_2.660944_g5524_i0 | PRJEB2925 | 6673 | 501 | 2.660944 | 13.33132944 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 121 | 7.71e-32 | NR | XP_068680699.1 | 591990 | g5524 | i0 | 49.6 | 3.98203592814371 | 131 | 66 | 78.4 | 0 | 42 | 434 | 2 | 132 | XP_068680699.1 large ribosomal subunit protein eL14-like [Montipora foliosa] | diamond | 1995 | 122 | 0.991803278688525 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 32087986 | 32087986 | PRJEB2925_P_NODE_13918_length_276_cov_2.315353_g12640_i0 | PRJEB2925 | 13918 | 276 | 2.315353 | 6.39037428 | Pocillopora verrucosa | 203993 | Cnidaria | other_Eukaryota | 54.7 | 3.33e-6 | NR | XP_058954688.2 | 203993 | g12640 | i0 | 43.1 | 0.782608695652174 | 72 | 32 | 72.8 | 4 | 266 | 66 | 372 | 439 | XP_058954688.2 ectin isoform X2 [Pocillopora verrucosa] | diamond | 216 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora verrucosa |
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);;