contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA421571" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1086259 | 1086259 | PRJNA421571_P_NODE_92221_length_251_cov_0.865169_g89672_i0 | PRJNA421571 | 92221 | 251 | 0.865169 | 2.17157419 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2917940740|emb|OZ237567.1| | 6108 | g89672 | i0 | 100 | 0.47808764940239 | 30 | 0 | 12 | 0 | 10 | 39 | 5727897 | 5727868 | Anemonia sulcata genome assembly, chromosome: 13 | blastn | 120 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 1699130 | 1699130 | PRJNA421571_P_NODE_88662_length_257_cov_1.673913_g86113_i0 | PRJNA421571 | 88662 | 257 | 1.673913 | 4.30195641 | Pocillopora verrucosa | 203993 | Cnidaria | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2751551215|ref|XM_059101251.2| | 203993 | g86113 | i0 | 100 | 0.330739299610895 | 29 | 0 | 11 | 0 | 198 | 226 | 1547 | 1575 | PREDICTED: Pocillopora verrucosa sialin (LOC131784448), mRNA | blastn | 85 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora verrucosa | |
| 2972472 | 2972472 | PRJNA421571_P_NODE_100983_length_245_cov_0.895349_g98434_i0 | PRJNA421571 | 100983 | 245 | 0.895349 | 2.19360505 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2918369538|emb|OZ237720.1| | 317547 | g98434 | i0 | 100 | 0.114285714285714 | 28 | 0 | 11 | 0 | 3 | 30 | 46492025 | 46491998 | Eunicella cavolini genome assembly, chromosome: 4 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 5527898 | 5527898 | PRJNA421571_P_NODE_86305_length_262_cov_2.031746_g83756_i0 | PRJNA421571 | 86305 | 262 | 2.031746 | 5.32317452 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 113 | 1.08e-20 | NTclustered | gi|2518956760|ref|XR_008978244.1| | 13093 | g83756 | i0 | 85.849 | 40.4580152671756 | 106 | 15 | 40 | 0 | 153 | 258 | 3352 | 3247 | PREDICTED: Hydractinia symbiolongicarpus large subunit ribosomal RNA (LOC130617162), rRNA | blastn | 10600 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 9352074 | 9352074 | PRJNA421571_P_NODE_78128_length_281_cov_2.322115_g75579_i0 | PRJNA421571 | 78128 | 281 | 2.322115 | 6.52514315 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.026 | NTclustered | gi|2917940714|emb|OZ237561.1| | 6108 | g75579 | i0 | 100 | 0.099644128113879 | 28 | 0 | 10 | 0 | 254 | 281 | 10507536 | 10507563 | Anemonia sulcata genome assembly, chromosome: 7 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 13177106 | 13177106 | PRJNA421571_P_NODE_54511_length_365_cov_0.914384_g51962_i0 | PRJNA421571 | 54511 | 365 | 0.914384 | 3.3375016 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 180 | 1.52e-40 | NTclustered | gi|2782881614|ref|XM_067063607.1| | 252671 | g51962 | i0 | 80.408 | 23.5260273972603 | 245 | 40 | 66 | 5 | 36 | 276 | 428 | 188 | PREDICTED: Clytia hemisphaerica large ribosomal subunit protein uL4B-like (LOC136807038), mRNA | blastn | 8587 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 22099466 | 22099466 | PRJNA421571_P_NODE_40758_length_459_cov_4.880829_g38210_i0 | PRJNA421571 | 40758 | 459 | 4.880829 | 22.40300511 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 62.1 | 7.4e-5 | NTclustered | gi|2744898063|ref|XM_065814701.1| | 6087 | g38210 | i0 | 97.222 | 0.0784313725490196 | 36 | 1 | 8 | 0 | 46 | 81 | 1026 | 1061 | PREDICTED: Hydra vulgaris arginine--tRNA ligase, cytoplasmic (LOC100214624), mRNA | blastn | 36 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris |
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);;