contig_metadata
7 rows where bioproject = "PRJNA613025" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 591594 | 591594 | PRJNA613025_S_NODE_14321_length_290_cov_6.564315_g14167_i0 | PRJNA613025 | 14321 | 290 | 6.564315 | 19.0365135 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 76.8 | 1.59e-9 | NTclustered | gi|2729058829|ref|XR_010517322.1| | 499914 | g14167 | i0 | 92.453 | 15.7310344827586 | 53 | 4 | 18 | 0 | 33 | 85 | 3608 | 3556 | PREDICTED: Rhopilema esculentum large subunit ribosomal RNA (LOC135695981), rRNA | blastn | 4562 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 9519922 | 9519922 | PRJNA613025_S_NODE_15168_length_276_cov_2.312775_g15014_i0 | PRJNA613025 | 15168 | 276 | 2.312775 | 6.383259 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 147 | 1.3899999999999996e-42 | NR | XP_027041682.1 | 46731 | g15014 | i0 | 76.9 | 7.93478260869565 | 91 | 21 | 98.9 | 0 | 276 | 4 | 24 | 114 | XP_027041682.1 40S ribosomal protein S8-like [Pocillopora damicornis] | diamond | 2190 | 148 | 0.993243243243243 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 14620777 | 14620777 | PRJNA613025_S_NODE_24612_length_190_cov_2.531915_g24458_i0 | PRJNA613025 | 24612 | 190 | 2.531915 | 4.8106385 | Ceratomyxa leatherjacketi | 1579382 | Cnidaria | other_Eukaryota | 115 | 2.0500000000000003e-21 | NTclustered | gi|730837044|gb|KM392428.1| | 1579382 | g24458 | i0 | 90 | 19.3210526315789 | 90 | 8 | 47 | 1 | 99 | 188 | 380 | 468 | Ceratomyxa leatherjacketi isolate LJ-GB-B 28S ribosomal RNA gene, partial sequence | blastn | 3671 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Ceratomyxidae | Ceratomyxa | Ceratomyxa leatherjacketi | |
| 16451742 | 16451742 | PRJNA613025_S_NODE_9113_length_427_cov_13.955026_g8961_i0 | PRJNA613025 | 9113 | 427 | 13.955026 | 59.58796102 | Rhizostomeae | 37535 | Cnidaria | other_Eukaryota | 145 | 6.6e-30 | NTclustered | gi|2862235116|gb|PQ647263.1| | 880218 | g8961 | i0 | 87.5 | 25.1381733021077 | 128 | 12 | 30 | 4 | 1 | 127 | 6904 | 6780 | Cephea cephea isolate AGC18069 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 10734 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Cepheidae | Cephea | Cephea cephea | |
| 18443901 | 18443901 | PRJNA613025_S_NODE_26275_length_182_cov_1.526316_g26121_i0 | PRJNA613025 | 26275 | 182 | 1.526316 | 2.77789512 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 52.8 | 0.015 | NTclustered | gi|2518997299|ref|XM_057450091.1| | 13093 | g26121 | i0 | 100 | 0.307692307692308 | 28 | 0 | 15 | 0 | 85 | 112 | 3028 | 3055 | PREDICTED: Hydractinia symbiolongicarpus AT-rich interactive domain-containing protein 1A-like (LOC130644467), transcript variant X2, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 28766990 | 28766990 | PRJNA613025_S_NODE_26947_length_179_cov_1.530769_g26793_i0 | PRJNA613025 | 26947 | 179 | 1.530769 | 2.74007651 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 74.7 | 1.61e-15 | NR | XP_028401732.1 | 151771 | g26793 | i0 | 68.6 | 3.3854748603352 | 51 | 16 | 85.5 | 0 | 27 | 179 | 3 | 53 | XP_028401732.1 60S ribosomal protein L33-A-like [Dendronephthya gigantea] | diamond | 606 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 31534208 | 31534208 | PRJNA613025_S_NODE_28936_length_171_cov_1.254098_g28782_i0 | PRJNA613025 | 28936 | 171 | 1.254098 | 2.14450758 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 52.8 | 5.88e-7 | NR | XP_028401732.1 | 151771 | g28782 | i0 | 56.4 | 6.56140350877193 | 55 | 20 | 96.5 | 2 | 6 | 170 | 24 | 74 | XP_028401732.1 60S ribosomal protein L33-A-like [Dendronephthya gigantea] | diamond | 1122 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea |
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);;