contig_metadata
12 rows where bioproject = "PRJNA797655", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5888648 | 5888648 | PRJNA797655_S_NODE_212325_length_173_cov_1.846154_g211720_i0 | PRJNA797655 | 212325 | 173 | 1.846154 | 3.19384642 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|2917940737|emb|OZ237566.1| | 6108 | g211720 | i0 | 100 | 0.167630057803468 | 29 | 0 | 17 | 0 | 24 | 52 | 9233213 | 9233185 | Anemonia sulcata genome assembly, chromosome: 12 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 8434801 | 8434801 | PRJNA797655_S_NODE_103807_length_242_cov_2.648241_g103202_i0 | PRJNA797655 | 103807 | 242 | 2.648241 | 6.40874322 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2202666560|ref|XR_006951441.1| | 2897299 | g103202 | i0 | 100 | 0.115702479338843 | 28 | 0 | 12 | 0 | 215 | 242 | 28 | 1 | PREDICTED: Xenia sp. Carnegie-2017 uncharacterized LOC124454405 (LOC124454405), ncRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 13539479 | 13539479 | PRJNA797655_S_NODE_238651_length_162_cov_2.411765_g238046_i0 | PRJNA797655 | 238651 | 162 | 2.411765 | 3.9070593 | Pocillopora verrucosa | 203993 | Cnidaria | other_Eukaryota | 73.1 | 1.03e-8 | NTclustered | gi|2751521993|ref|XM_059084146.2| | 203993 | g238046 | i0 | 95.652 | 158.530864197531 | 46 | 1 | 28 | 1 | 28 | 73 | 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 | |
| 13541661 | 13541661 | PRJNA797655_S_NODE_54911_length_305_cov_2.591603_g54306_i0 | PRJNA797655 | 54911 | 305 | 2.591603 | 7.90438915 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 52.8 | 0.028 | NTclustered | gi|2202666560|ref|XR_006951441.1| | 2897299 | g54306 | i0 | 100 | 0.0918032786885246 | 28 | 0 | 9 | 0 | 1 | 28 | 1 | 28 | PREDICTED: Xenia sp. Carnegie-2017 uncharacterized LOC124454405 (LOC124454405), ncRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 14816286 | 14816286 | PRJNA797655_S_NODE_48452_length_318_cov_1.930909_g47847_i0 | PRJNA797655 | 48452 | 318 | 1.930909 | 6.14029062 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 52.8 | 0.03 | NTclustered | gi|2202666560|ref|XR_006951441.1| | 2897299 | g47847 | i0 | 100 | 0.0880503144654088 | 28 | 0 | 9 | 0 | 1 | 28 | 1 | 28 | PREDICTED: Xenia sp. Carnegie-2017 uncharacterized LOC124454405 (LOC124454405), ncRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 21186089 | 21186089 | PRJNA797655_S_NODE_164577_length_197_cov_1.558442_g163972_i0 | PRJNA797655 | 164577 | 197 | 1.558442 | 3.07013074 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 52.8 | 0.017 | NTclustered | gi|2202666560|ref|XR_006951441.1| | 2897299 | g163972 | i0 | 100 | 0.142131979695431 | 28 | 0 | 14 | 0 | 170 | 197 | 28 | 1 | PREDICTED: Xenia sp. Carnegie-2017 uncharacterized LOC124454405 (LOC124454405), ncRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 22458866 | 22458866 | PRJNA797655_S_NODE_104838_length_241_cov_2.616162_g104233_i0 | PRJNA797655 | 104838 | 241 | 2.616162 | 6.30495042 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2918369540|emb|OZ237722.1| | 317547 | g104233 | i0 | 100 | 0.116182572614108 | 28 | 0 | 12 | 0 | 207 | 234 | 19361319 | 19361346 | Eunicella cavolini genome assembly, chromosome: 6 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 23736013 | 23736013 | PRJNA797655_S_NODE_152979_length_204_cov_1.788820_g152374_i0 | PRJNA797655 | 152979 | 204 | 1.78882 | 3.6491928 | Corymorpha bigelowi | 498525 | Cnidaria | other_Eukaryota | 84.2 | 6.31e-12 | NTclustered | gi|166407147|gb|EU272563.1| | 498525 | g152374 | i0 | 82.979 | 0.46078431372549 | 94 | 15 | 46 | 1 | 112 | 204 | 2578 | 2485 | Corymorpha bigelowi voucher KUNHM 2829 28S large subunit ribosomal RNA gene, partial sequence | blastn | 94 | 84.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Corymorphidae | Corymorpha | Corymorpha bigelowi | |
| 23737587 | 23737587 | PRJNA797655_S_NODE_202819_length_177_cov_2.514925_g202214_i0 | PRJNA797655 | 202819 | 177 | 2.514925 | 4.45141725 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|2918369537|emb|OZ237719.1| | 317547 | g202214 | i0 | 96.875 | 0.180790960451977 | 32 | 1 | 18 | 0 | 3 | 34 | 56050606 | 56050637 | Eunicella cavolini genome assembly, chromosome: 3 | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 25010699 | 25010699 | PRJNA797655_S_NODE_186300_length_185_cov_2.359155_g185695_i0 | PRJNA797655 | 186300 | 185 | 2.359155 | 4.36443675 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 52.8 | 0.016 | NTclustered | gi|2202666560|ref|XR_006951441.1| | 2897299 | g185695 | i0 | 100 | 0.151351351351351 | 28 | 0 | 15 | 0 | 1 | 28 | 1 | 28 | PREDICTED: Xenia sp. Carnegie-2017 uncharacterized LOC124454405 (LOC124454405), ncRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 25444019 | 25444019 | PRJNA797655_S_NODE_185900_length_185_cov_3.718310_g185295_i0 | PRJNA797655 | 185900 | 185 | 3.71831 | 6.8788735 | Montipora | 46703 | Cnidaria | other_Eukaryota | 52.8 | 0.016 | NTclustered | gi|2812188878|ref|XM_068861125.1| | 246305 | g185295 | i0 | 100 | 0.454054054054054 | 28 | 0 | 15 | 0 | 10 | 37 | 15597 | 15624 | PREDICTED: Montipora capricornis uncharacterized protein (LOC138014097), mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 32718257 | 32718257 | PRJNA797655_S_NODE_65780_length_287_cov_2.598361_g65175_i0 | PRJNA797655 | 65780 | 287 | 2.598361 | 7.45729607 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 43.5 | 0.034 | NR | XP_068694397.1 | 591990 | g65175 | i0 | 36.9 | 1.58885017421603 | 84 | 36 | 79.4 | 4 | 232 | 5 | 560 | 634 | XP_068694397.1 transient receptor potential cation channel subfamily M member 4-like isoform X2 [Montipora foliosa] | diamond | 456 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa |
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);;