contig_metadata
12 rows where bioproject = "PRJNA565778" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5662287 | 5662287 | PRJNA565778_S_NODE_8325_length_373_cov_3.366071_g8031_i0 | PRJNA565778 | 8325 | 373 | 3.366071 | 12.55544483 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 69.4 | 3.52e-7 | NTclustered | gi|2917940696|emb|OZ237557.1| | 6108 | g8031 | i0 | 82.143 | 301.833780160858 | 84 | 11 | 21 | 2 | 229 | 308 | 2830730 | 2830813 | Anemonia sulcata genome assembly, chromosome: 3 | blastn | 112584 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 6936466 | 6936466 | PRJNA565778_S_NODE_34026_length_187_cov_3.140000_g33730_i0 | PRJNA565778 | 34026 | 187 | 3.14 | 5.8718 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 73.6 | 2.2e-13 | NR | CAB4001185.1 | 317549 | g33730 | i0 | 76.7 | 1.57219251336898 | 43 | 10 | 69 | 0 | 130 | 2 | 3 | 45 | CAB4001185.1 dnaJ homolog subfamily A member 2 [Paramuricea clavata] | diamond | 294 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 7513711 | 7513711 | PRJNA565778_S_NODE_5046_length_461_cov_1699.603774_g4809_i0 | PRJNA565778 | 5046 | 461 | 1699.603774 | 7835.17339814 | Acropora | 6127 | Cnidaria | other_Eukaryota | 133 | 6.39e-33 | NR | KAK2558371.1 | 6130 | g4809 | i0 | 56 | 1.41865509761388 | 109 | 48 | 70.9 | 0 | 388 | 62 | 607 | 715 | KAK2558371.1 Nuclear pore complex protein Nup107 [Acropora cervicornis] | diamond | 654 | 133 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 9486541 | 9486541 | PRJNA565778_S_NODE_18628_length_256_cov_215.890411_g18332_i0 | PRJNA565778 | 18628 | 256 | 215.890411 | 552.67945216 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 65.8 | 2.99e-6 | NTclustered | gi|2917940759|emb|OZ237572.1| | 6108 | g18332 | i0 | 95.122 | 0.74609375 | 41 | 2 | 16 | 0 | 116 | 156 | 5752933 | 5752893 | Anemonia sulcata genome assembly, chromosome: 18 | blastn | 191 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 17135782 | 17135782 | PRJNA565778_S_NODE_14_length_2098_cov_3.901989_g12_i0 | PRJNA565778 | 14 | 2098 | 3.901989 | 81.86372922 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 687 | 6.22e-236 | NR | XP_048587532.1 | 45351 | g12 | i0 | 54.2 | 9.30028598665396 | 659 | 279 | 93.4 | 5 | 2093 | 135 | 206 | 847 | XP_048587532.1 pre-mRNA-splicing factor SYF1-like [Nematostella vectensis] | diamond | 19512 | 687 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 23510610 | 23510610 | PRJNA565778_S_NODE_22239_length_235_cov_1.525253_g21943_i0 | PRJNA565778 | 22239 | 235 | 1.525253 | 3.58434455 | Trachyphyllia geoffroyi | 196280 | Cnidaria | other_Eukaryota | 429 | 8.33e-116 | NTclustered | gi|23503507|dbj|AB085641.1| | 196280 | g21943 | i0 | 99.574 | 5 | 235 | 1 | 100 | 0 | 1 | 235 | 300 | 534 | Trachyphyllia geoffroyi mRNA for Kaede, complete cds | blastn | 1175 | 429 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Trachyphyllia | Trachyphyllia geoffroyi | |
| 24087674 | 24087674 | PRJNA565778_S_NODE_19519_length_251_cov_2.345794_g19223_i0 | PRJNA565778 | 19519 | 251 | 2.345794 | 5.88794294 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 76.6 | 4.65e-14 | NR | XP_046855008.1 | 2897299 | g19223 | i0 | 50.7 | 0.824701195219124 | 69 | 33 | 81.3 | 1 | 238 | 35 | 286 | 354 | XP_046855008.1 rho GTPase-activating protein 44-like isoform X2 [Xenia sp. Carnegie-2017] | diamond | 207 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 24087791 | 24087791 | PRJNA565778_S_NODE_7419_length_392_cov_102.123944_g7134_i0 | PRJNA565778 | 7419 | 392 | 102.123944 | 400.32586048 | Montipora | 46703 | Cnidaria | other_Eukaryota | 52.8 | 0.037 | NTclustered | gi|2812154001|ref|XM_068889629.1| | 246305 | g7134 | i0 | 100 | 0.571428571428571 | 28 | 0 | 7 | 0 | 23 | 50 | 1550 | 1523 | PREDICTED: Montipora capricornis galanin receptor type 1-like (LOC138043384), mRNA | blastn | 224 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 26858355 | 26858355 | PRJNA565778_S_NODE_20461_length_244_cov_783.347826_g20165_i0 | PRJNA565778 | 20461 | 244 | 783.347826 | 1911.36869544 | Desmophyllum pertusum | 174260 | Cnidaria | other_Eukaryota | 75.5 | 4.3e-14 | NR | KAJ7389832.1 | 174260 | g20165 | i0 | 66.1 | 2.69262295081967 | 59 | 19 | 71.3 | 1 | 33 | 206 | 115 | 173 | KAJ7389832.1 Transient receptor putative cation channel sub M member 2 [Desmophyllum pertusum] | diamond | 657 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum | |
| 31009353 | 31009353 | PRJNA565778_S_NODE_5074_length_460_cov_290.893617_g4837_i0 | PRJNA565778 | 5074 | 460 | 290.893617 | 1338.1106382 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 127 | 1.81e-33 | NR | CAH3124719.1 | 104759 | g4837 | i0 | 51.7 | 5.98695652173913 | 116 | 56 | 75.7 | 0 | 443 | 96 | 80 | 195 | CAH3124719.1 unnamed protein product [Porites lobata] | diamond | 2754 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 31483821 | 31483821 | PRJNA565778_S_NODE_236_length_1247_cov_3.200000_g208_i0 | PRJNA565778 | 236 | 1247 | 3.2 | 39.904 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 106 | 1.63e-21 | NR | XP_020609478.1 | 48498 | g208 | i0 | 50.9 | 1.43865276663994 | 110 | 52 | 26.2 | 2 | 1089 | 763 | 59 | 167 | XP_020609478.1 uncharacterized protein LOC110048052 isoform X1 [Orbicella faveolata] | diamond | 1794 | 107 | 0.990654205607477 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 32797392 | 32797392 | PRJNA565778_S_NODE_22300_length_234_cov_115.441624_g22004_i0 | PRJNA565778 | 22300 | 234 | 115.441624 | 270.13340016 | Porites evermanni | 104178 | Cnidaria | other_Eukaryota | 66.6 | 1.16e-10 | NR | CAH3158448.1 | 104178 | g22004 | i0 | 45.5 | 4.94871794871795 | 66 | 36 | 84.6 | 0 | 32 | 229 | 264 | 329 | CAH3158448.1 unnamed protein product [Porites evermanni] | diamond | 1158 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni |
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);;