contig_metadata
7 rows where bioproject = "PRJNA558770" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6233411 | 6233411 | PRJNA558770_P_NODE_381485_length_211_cov_7.306818_g379480_i0 | PRJNA558770 | 381485 | 211 | 7.306818 | 15.41738598 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 141 | 3.85e-29 | NTclustered | gi|2113718509|ref|XR_006393933.1| | 45264 | g379480 | i0 | 86.029 | 64.1848341232227 | 136 | 13 | 64 | 6 | 4 | 137 | 2584 | 2715 | PREDICTED: Acropora millepora large subunit ribosomal RNA (LOC122955186), rRNA | blastn | 13543 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 9467604 | 9467604 | PRJNA558770_P_NODE_190288_length_234_cov_4.170854_g188283_i0 | PRJNA558770 | 190288 | 234 | 4.170854 | 9.75979836 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2918369536|emb|OZ237718.1| | 317547 | g188283 | i0 | 94.444 | 0.290598290598291 | 36 | 2 | 15 | 0 | 197 | 232 | 53745391 | 53745426 | Eunicella cavolini genome assembly, chromosome: 2 | blastn | 68 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 17707089 | 17707089 | PRJNA558770_P_NODE_217014_length_234_cov_3.180905_g215009_i0 | PRJNA558770 | 217014 | 234 | 3.180905 | 7.4433177 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2917940724|emb|OZ237563.1| | 6108 | g215009 | i0 | 100 | 1.14957264957265 | 30 | 0 | 13 | 0 | 142 | 171 | 455682 | 455653 | Anemonia sulcata genome assembly, chromosome: 9 | blastn | 269 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 20944551 | 20944551 | PRJNA558770_P_NODE_60417_length_269_cov_1.482906_g58412_i0 | PRJNA558770 | 60417 | 269 | 1.482906 | 3.98901714 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2917940693|emb|OZ237556.1| | 6108 | g58412 | i0 | 94.444 | 0.594795539033457 | 36 | 1 | 13 | 1 | 168 | 202 | 1482266 | 1482231 | Anemonia sulcata genome assembly, chromosome: 2 | blastn | 160 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 23492811 | 23492811 | PRJNA558770_P_NODE_273979_length_234_cov_1.834171_g271974_i0 | PRJNA558770 | 273979 | 234 | 1.834171 | 4.29196014 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 58.4 | 4.5e-4 | NTclustered | gi|2744807007|ref|XR_007021335.2| | 6087 | g271974 | i0 | 92.683 | 0.175213675213675 | 41 | 1 | 18 | 2 | 35 | 75 | 261 | 299 | PREDICTED: Hydra vulgaris uncharacterized LOC124810868 (LOC124810868), ncRNA | blastn | 41 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 24766586 | 24766586 | PRJNA558770_P_NODE_271920_length_234_cov_1.874372_g269915_i0 | PRJNA558770 | 271920 | 234 | 1.874372 | 4.38603048 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 52.8 | 0.021 | NTclustered | gi|2729102036|ref|XM_065214049.1| | 499914 | g269915 | i0 | 100 | 0.11965811965812 | 28 | 0 | 12 | 0 | 190 | 217 | 1785 | 1812 | PREDICTED: Rhopilema esculentum rhodopsin, GQ-coupled-like (LOC135695092), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 31975468 | 31975468 | PRJNA558770_P_NODE_181218_length_234_cov_4.587940_g179213_i0 | PRJNA558770 | 181218 | 234 | 4.58794 | 10.7357796 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 50.8 | 3.86e-5 | NR | XP_057293116.1 | 13093 | g179213 | i0 | 78.3 | 0.58974358974359 | 23 | 5 | 29.5 | 0 | 166 | 234 | 199 | 221 | XP_057293116.1 uncharacterized protein LOC130621786 [Hydractinia symbiolongicarpus] | diamond | 138 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus |
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);;