contig_metadata
7 rows where bioproject = "PRJNA1241156" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2900859 | 2900859 | PRJNA1241156_S_NODE_45383_length_288_cov_1.310204_g44923_i0 | PRJNA1241156 | 45383 | 288 | 1.310204 | 3.77338752 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 52.8 | 0.027 | NTclustered | gi|2918369555|emb|OZ237727.1| | 317547 | g44923 | i0 | 100 | 0.291666666666667 | 28 | 0 | 10 | 0 | 27 | 54 | 8045961 | 8045934 | Eunicella cavolini genome assembly, chromosome: 11 | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 11828365 | 11828365 | PRJNA1241156_S_NODE_24010_length_350_cov_5.540717_g23550_i0 | PRJNA1241156 | 24010 | 350 | 5.540717 | 19.3925095 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|2918369565|emb|OZ237731.1| | 317547 | g23550 | i0 | 92.308 | 0.911428571428571 | 39 | 3 | 11 | 0 | 87 | 125 | 934011 | 934049 | Eunicella cavolini genome assembly, chromosome: 15 | blastn | 319 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 14378745 | 14378745 | PRJNA1241156_S_NODE_22732_length_355_cov_2.301282_g22272_i0 | PRJNA1241156 | 22732 | 355 | 2.301282 | 8.1695511 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 52.8 | 0.034 | NTclustered | gi|2744850920|ref|XM_065792695.1| | 6087 | g22272 | i0 | 100 | 0.0788732394366197 | 28 | 0 | 8 | 0 | 18 | 45 | 144 | 117 | PREDICTED: Hydra vulgaris germinal-center associated nuclear protein (LOC101237473), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 15652818 | 15652818 | PRJNA1241156_S_NODE_31953_length_324_cov_7.163701_g31493_i0 | PRJNA1241156 | 31953 | 324 | 7.163701 | 23.21039124 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|2918369553|emb|OZ237725.1| | 317547 | g31493 | i0 | 100 | 0.0895061728395062 | 29 | 0 | 9 | 0 | 143 | 171 | 1429757 | 1429729 | Eunicella cavolini genome assembly, chromosome: 9 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 16927209 | 16927209 | PRJNA1241156_S_NODE_41814_length_297_cov_6.157480_g41354_i0 | PRJNA1241156 | 41814 | 297 | 6.15748 | 18.2877156 | Acropora muricata | 159855 | Cnidaria | other_Eukaryota | 52.8 | 0.028 | NTclustered | gi|2784647305|ref|XM_067174708.1| | 159855 | g41354 | i0 | 100 | 0.0942760942760943 | 28 | 0 | 9 | 0 | 142 | 169 | 3018 | 2991 | PREDICTED: Acropora muricata tetratricopeptide repeat protein 28-like (LOC136908186), transcript variant X1, mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora muricata | |
| 19475832 | 19475832 | PRJNA1241156_S_NODE_27776_length_337_cov_5.741497_g27316_i0 | PRJNA1241156 | 27776 | 337 | 5.741497 | 19.34884489 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2918369555|emb|OZ237727.1| | 317547 | g27316 | i0 | 100 | 0.0890207715133531 | 30 | 0 | 9 | 0 | 224 | 253 | 16655794 | 16655765 | Eunicella cavolini genome assembly, chromosome: 11 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 29189519 | 29189519 | PRJNA1241156_S_NODE_10569_length_418_cov_6.701333_g10113_i0 | PRJNA1241156 | 10569 | 418 | 6.701333 | 28.01157194 | Acropora cervicornis | 6130 | Cnidaria | other_Eukaryota | 47.8 | 0.00235 | NR | KAK2554295.1 | 6130 | g10113 | i0 | 60 | 0.215311004784689 | 30 | 12 | 21.5 | 0 | 49 | 138 | 83 | 112 | KAK2554295.1 Retrovirus-related Pol polyprotein from transposon 17.6 [Acropora cervicornis] | diamond | 90 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis |
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);;