contig_metadata
4 rows where bioproject = "PRJNA429937" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2978165 | 2978165 | PRJNA429937_P_NODE_82203_length_359_cov_2.018182_g59744_i0 | PRJNA429937 | 82203 | 359 | 2.018182 | 7.24527338 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.034 | NTclustered | gi|2917940696|emb|OZ237557.1| | 6108 | g59744 | i0 | 100 | 0.0779944289693593 | 28 | 0 | 8 | 0 | 305 | 332 | 17833514 | 17833487 | Anemonia sulcata genome assembly, chromosome: 3 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 13181113 | 13181113 | PRJNA429937_P_NODE_78751_length_370_cov_3.788856_g56424_i0 | PRJNA429937 | 78751 | 370 | 3.788856 | 14.0187672 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 54.7 | 0.01 | NTclustered | gi|2917940687|emb|OZ237555.1| | 6108 | g56424 | i0 | 100 | 0.0783783783783784 | 29 | 0 | 8 | 0 | 16 | 44 | 25943373 | 25943401 | Anemonia sulcata genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 26886094 | 26886094 | PRJNA429937_P_NODE_71781_length_396_cov_2.618529_g50026_i0 | PRJNA429937 | 71781 | 396 | 2.618529 | 10.36937484 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 51.6 | 1.57e-4 | NR | XP_047123845.1 | 6087 | g50026 | i0 | 29.1 | 0.598484848484849 | 79 | 56 | 59.8 | 0 | 385 | 149 | 560 | 638 | XP_047123845.1 uncharacterized protein K02A2.6 [Hydra vulgaris] | diamond | 237 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 28591700 | 28591700 | PRJNA429937_P_NODE_23887_length_751_cov_6.574792_g14258_i0 | PRJNA429937 | 23887 | 751 | 6.574792 | 49.37668792 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 141 | 4.36e-34 | NR | KXJ08474.1 | 2652724 | g14258 | i0 | 37.6 | 3.69107856191744 | 186 | 112 | 74.3 | 2 | 580 | 23 | 182 | 363 | KXJ08474.1 Uncharacterized protein K02A2.6, partial [Exaiptasia diaphana] | diamond | 2772 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana |
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);;