contig_metadata
4 rows where bioproject = "PRJNA280983", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1646460 | 1646460 | PRJNA280983_P_NODE_7342_length_213_cov_0.890244_g7227_i0 | PRJNA280983 | 7342 | 213 | 0.890244 | 1.89621972 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 195 | 2.94e-45 | NTclustered | gi|2202661593|ref|XM_047003276.1| | 2897299 | g7227 | i0 | 83.491 | 77.2816901408451 | 212 | 31 | 99 | 4 | 4 | 213 | 682 | 473 | PREDICTED: Xenia sp. Carnegie-2017 heat shock cognate 71 kDa protein-like (LOC124452687), mRNA | blastn | 16461 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 16949055 | 16949055 | PRJNA280983_P_NODE_9514_length_171_cov_1.254098_g9399_i0 | PRJNA280983 | 9514 | 171 | 1.254098 | 2.14450758 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 110 | 8.38e-20 | NTclustered | gi|1603803279|ref|XM_028549847.1| | 151771 | g9399 | i0 | 86.735 | 2.35672514619883 | 98 | 13 | 57 | 0 | 57 | 154 | 223 | 126 | PREDICTED: Dendronephthya gigantea 40S ribosomal protein S25-like (LOC114528224), mRNA | blastn | 403 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 27818515 | 27818515 | PRJNA280983_P_NODE_9244_length_175_cov_1.619048_g9129_i0 | PRJNA280983 | 9244 | 175 | 1.619048 | 2.833334 | Hydrozoa | 6074 | Cnidaria | other_Eukaryota | 69.7 | 3.06e-13 | NR | XP_002155359.2 | 6087 | g9129 | i0 | 74.4 | 1.45714285714286 | 43 | 10 | 73.7 | 1 | 173 | 45 | 101 | 142 | XP_002155359.2 small ribosomal subunit protein eS12 [Hydra vulgaris] | diamond | 255 | 70.1 | 0.994293865905849 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 28842428 | 28842428 | PRJNA280983_P_NODE_10168_length_166_cov_0.871795_g10053_i0 | PRJNA280983 | 10168 | 166 | 0.871795 | 1.4471797 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 78.6 | 3.1e-15 | NR | EDO33206.1 | 45351 | g10053 | i0 | 63 | 12.578313253012 | 54 | 20 | 97.6 | 0 | 4 | 165 | 285 | 338 | EDO33206.1 predicted protein [Nematostella vectensis] | diamond | 2088 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis |
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);;