contig_metadata
8 rows where bioproject = "PRJNA835051", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 825656 | 825656 | PRJNA835051_S_NODE_15721_length_293_cov_1.516000_g15425_i0 | PRJNA835051 | 15721 | 293 | 1.516 | 4.44188 | Pocillopora verrucosa | 203993 | Cnidaria | other_Eukaryota | 73.1 | 2.09e-8 | NTclustered | gi|2751521993|ref|XM_059084146.2| | 203993 | g15425 | i0 | 95.652 | 87.6518771331058 | 46 | 1 | 16 | 1 | 97 | 142 | 2084 | 2128 | PREDICTED: Pocillopora verrucosa pre-mRNA-splicing factor CWC25 homolog (LOC131768411), mRNA | blastn | 25682 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora verrucosa | |
| 4655053 | 4655053 | PRJNA835051_S_NODE_92184_length_175_cov_1.416667_g91888_i0 | PRJNA835051 | 92184 | 175 | 1.416667 | 2.47916725 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|2918369535|emb|OZ237717.1| | 317547 | g91888 | i0 | 100 | 0.165714285714286 | 29 | 0 | 17 | 0 | 40 | 68 | 50532247 | 50532219 | Eunicella cavolini genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 7204312 | 7204312 | PRJNA835051_S_NODE_43586_length_226_cov_1.535519_g43290_i0 | PRJNA835051 | 43586 | 226 | 1.535519 | 3.47027294 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.02 | NTclustered | gi|2917940720|emb|OZ237562.1| | 6108 | g43290 | i0 | 100 | 0.123893805309735 | 28 | 0 | 12 | 0 | 88 | 115 | 14201314 | 14201287 | Anemonia sulcata genome assembly, chromosome: 8 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 7204644 | 7204644 | PRJNA835051_S_NODE_69446_length_194_cov_2.589404_g69150_i0 | PRJNA835051 | 69446 | 194 | 2.589404 | 5.02344376 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 52.8 | 0.017 | NTclustered | gi|2918369563|emb|OZ237729.1| | 317547 | g69150 | i0 | 100 | 0.144329896907216 | 28 | 0 | 14 | 0 | 135 | 162 | 654336 | 654363 | Eunicella cavolini genome assembly, chromosome: 13 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 9754324 | 9754324 | PRJNA835051_S_NODE_63008_length_201_cov_1.518987_g62712_i0 | PRJNA835051 | 63008 | 201 | 1.518987 | 3.05316387 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|2918369538|emb|OZ237720.1| | 317547 | g62712 | i0 | 100 | 0.149253731343284 | 30 | 0 | 15 | 0 | 18 | 47 | 47483106 | 47483077 | Eunicella cavolini genome assembly, chromosome: 4 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 23778332 | 23778332 | PRJNA835051_S_NODE_34439_length_241_cov_1.914141_g34143_i0 | PRJNA835051 | 34439 | 241 | 1.914141 | 4.61307981 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2917940740|emb|OZ237567.1| | 6108 | g34143 | i0 | 100 | 0.116182572614108 | 28 | 0 | 12 | 0 | 130 | 157 | 13504796 | 13504823 | Anemonia sulcata genome assembly, chromosome: 13 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 25052775 | 25052775 | PRJNA835051_S_NODE_80900_length_184_cov_1.340426_g80604_i0 | PRJNA835051 | 80900 | 184 | 1.340426 | 2.46638384 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|2744824631|ref|XM_002160953.5| | 6087 | g80604 | i0 | 96.97 | 0.331521739130435 | 33 | 1 | 18 | 0 | 31 | 63 | 2 | 34 | PREDICTED: Hydra vulgaris gem-associated protein 8 (LOC100197072), transcript variant X1, mRNA | blastn | 61 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 26642960 | 26642960 | PRJNA835051_S_NODE_83061_length_182_cov_1.690647_g82765_i0 | PRJNA835051 | 83061 | 182 | 1.690647 | 3.07697754 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 81.3 | 3.14e-17 | NR | CAB4023423.1 | 317549 | g82765 | i0 | 58.3 | 2.96703296703297 | 60 | 25 | 98.9 | 0 | 182 | 3 | 57 | 116 | CAB4023423.1 isochorismatase domain-containing 2-like [Paramuricea clavata] | diamond | 540 | 81.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata |
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);;