contig_metadata
23 rows where bioproject = "PRJNA384462", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 405341 | 405341 | PRJNA384462_S_NODE_3861_length_268_cov_1.598174_g3745_i0 | PRJNA384462 | 3861 | 268 | 1.598174 | 4.28310632 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2917940766|emb|OZ237573.1| | 6108 | g3745 | i0 | 100 | 0.108208955223881 | 29 | 0 | 11 | 0 | 16 | 44 | 8320375 | 8320403 | Anemonia sulcata genome assembly, chromosome: 19 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 1680198 | 1680198 | PRJNA384462_S_NODE_8142_length_198_cov_2.570470_g8026_i0 | PRJNA384462 | 8142 | 198 | 2.57047 | 5.0895306 | Montipora capricornis | 246305 | Cnidaria | other_Eukaryota | 83.2 | 5.24e-18 | NR | XP_068752466.1 | 246305 | g8026 | i0 | 73.6 | 4.8030303030303 | 53 | 14 | 80.3 | 0 | 197 | 39 | 123 | 175 | XP_068752466.1 large ribosomal subunit protein uL5-like [Montipora capricornis] | diamond | 951 | 83.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 18927371 | 18927371 | PRJNA384462_S_NODE_335_length_797_cov_340.760695_g263_i0 | PRJNA384462 | 335 | 797 | 340.760695 | 2715.86273915 | Malacalcyonacea | 3028843 | Cnidaria | other_Eukaryota | 99 | 1.01e-15 | NTclustered | gi|527502257|gb|KC864804.1| | 1366484 | g263 | i0 | 93.846 | 9.44667503136763 | 65 | 3 | 8 | 1 | 41 | 105 | 779 | 842 | Ovabunda biseriata voucher 1201944 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 7529 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Ovabunda | Ovabunda biseriata | |
| 20806940 | 20806940 | PRJNA384462_S_NODE_8377_length_196_cov_2.272109_g8261_i0 | PRJNA384462 | 8377 | 196 | 2.272109 | 4.45333364 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|2918369555|emb|OZ237727.1| | 317547 | g8261 | i0 | 100 | 0.295918367346939 | 30 | 0 | 15 | 0 | 72 | 101 | 1823481 | 1823452 | Eunicella cavolini genome assembly, chromosome: 11 | blastn | 58 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 26663360 | 26663360 | PRJNA384462_S_NODE_4181_length_259_cov_1.942857_g4065_i0 | PRJNA384462 | 4181 | 259 | 1.942857 | 5.03199963 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 45.8 | 0.00364 | NR | PFX22407.1 | 50429 | g4065 | i0 | 43.6 | 1.27413127413127 | 55 | 30 | 63.7 | 1 | 8 | 172 | 136 | 189 | PFX22407.1 Kinesin light chain [Stylophora pistillata] | diamond | 330 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 26980166 | 26980166 | PRJNA384462_S_NODE_15002_length_162_cov_0.902655_g14886_i0 | PRJNA384462 | 15002 | 162 | 0.902655 | 1.4623011 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 70.9 | 1.47e-12 | NR | XP_057294290.1 | 13093 | g14886 | i0 | 60.8 | 1.85185185185185 | 51 | 19 | 92.6 | 1 | 158 | 9 | 401 | 451 | XP_057294290.1 probable RNA-binding protein 19 isoform X2 [Hydractinia symbiolongicarpus] | diamond | 300 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 26997001 | 26997001 | PRJNA384462_S_NODE_8642_length_194_cov_1.400000_g8526_i0 | PRJNA384462 | 8642 | 194 | 1.4 | 2.716 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 85.9 | 7.63e-20 | NR | ABD04179.1 | 6110 | g8526 | i0 | 73.7 | 3.55670103092783 | 57 | 15 | 88.1 | 0 | 2 | 172 | 37 | 93 | ABD04179.1 60S ribosomal protein L26-like protein, partial [Anthopleura elegantissima] | diamond | 690 | 85.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anthopleura | Anthopleura elegantissima | |
| 27028815 | 27028815 | PRJNA384462_S_NODE_10782_length_178_cov_8.550388_g10666_i0 | PRJNA384462 | 10782 | 178 | 8.550388 | 15.21969064 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.4 | 5e-6 | NR | CAB3985391.1 | 317549 | g10666 | i0 | 47.9 | 20.2752808988764 | 48 | 23 | 80.9 | 1 | 144 | 1 | 20 | 65 | CAB3985391.1 Retrovirus-related Pol poly from transposon TNT 1-94 [Paramuricea clavata] | diamond | 3609 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 27423055 | 27423055 | PRJNA384462_S_NODE_13903_length_164_cov_1.791304_g13787_i0 | PRJNA384462 | 13903 | 164 | 1.791304 | 2.93773856 | Actinostola sp. cb2 | 3060491 | Cnidaria | other_Eukaryota | 65.1 | 1.64e-10 | NR | KAK3752751.1 | 3060491 | g13787 | i0 | 60.4 | 1.92073170731707 | 48 | 15 | 87.8 | 1 | 145 | 2 | 321 | 364 | KAK3752751.1 hypothetical protein QZH41_018717 [Actinostola sp. cb2023] | diamond | 315 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Actinostola | Actinostola sp. cb2023 | |
| 27675670 | 27675670 | PRJNA384462_S_NODE_15224_length_161_cov_1.366071_g15108_i0 | PRJNA384462 | 15224 | 161 | 1.366071 | 2.19937431 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 75.1 | 7.03e-15 | NR | XP_028404257.1 | 151771 | g15108 | i0 | 69.8 | 12.7267080745342 | 53 | 16 | 98.8 | 0 | 161 | 3 | 10 | 62 | XP_028404257.1 40S ribosomal protein S8-like [Dendronephthya gigantea] | diamond | 2049 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 27692578 | 27692578 | PRJNA384462_S_NODE_6344_length_218_cov_1.195266_g6228_i0 | PRJNA384462 | 6344 | 218 | 1.195266 | 2.60567988 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 47.4 | 6.02e-4 | NR | EDO42448.1 | 45351 | g6228 | i0 | 46.2 | 4.07339449541284 | 52 | 26 | 71.6 | 1 | 216 | 61 | 215 | 264 | EDO42448.1 predicted protein [Nematostella vectensis] | diamond | 888 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 27707418 | 27707418 | PRJNA384462_S_NODE_5084_length_238_cov_2.010582_g4968_i0 | PRJNA384462 | 5084 | 238 | 2.010582 | 4.78518516 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 47 | 0.00103 | NR | XP_031569604.1 | 6105 | g4968 | i0 | 38.3 | 0.592436974789916 | 47 | 29 | 59.2 | 0 | 210 | 70 | 211 | 257 | XP_031569604.1 ribosomal L1 domain-containing protein 1-like [Actinia tenebrosa] | diamond | 141 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 28671217 | 28671217 | PRJNA384462_S_NODE_9967_length_184_cov_1.007407_g9851_i0 | PRJNA384462 | 9967 | 184 | 1.007407 | 1.85362888 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 61.6 | 3.36e-9 | NR | KAK2573205.1 | 6130 | g9851 | i0 | 50 | 25.0108695652174 | 50 | 25 | 81.5 | 0 | 183 | 34 | 137 | 186 | KAK2573205.1 Receptor of activated protein C kinase 1 [Acropora cervicornis] | diamond | 4602 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 29081647 | 29081647 | PRJNA384462_S_NODE_4708_length_246_cov_3.690355_g4592_i0 | PRJNA384462 | 4708 | 246 | 3.690355 | 9.0782733 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 120 | 1.06e-32 | NR | RMX59830.1 | 46731 | g4592 | i0 | 68.4 | 5.5 | 76 | 24 | 92.7 | 0 | 6 | 233 | 51 | 126 | RMX59830.1 hypothetical protein pdam_00007337, partial [Pocillopora damicornis] | diamond | 1353 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 29113218 | 29113218 | PRJNA384462_S_NODE_14488_length_163_cov_0.894737_g14372_i0 | PRJNA384462 | 14488 | 163 | 0.894737 | 1.45842131 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 103 | 6.18e-26 | NR | XP_048575653.1 | 45351 | g14372 | i0 | 75.9 | 15.8834355828221 | 54 | 13 | 99.4 | 0 | 1 | 162 | 70 | 123 | XP_048575653.1 ras-related C3 botulinum toxin substrate 1-like [Nematostella vectensis] | diamond | 2589 | 104 | 0.990384615384615 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 29460136 | 29460136 | PRJNA384462_S_NODE_12110_length_171_cov_1.180328_g11994_i0 | PRJNA384462 | 12110 | 171 | 1.180328 | 2.01836088 | Acropora | 6127 | Cnidaria | other_Eukaryota | 52 | 7.56e-6 | NR | KAK2563153.1 | 6130 | g11994 | i0 | 54.3 | 4.78947368421053 | 46 | 21 | 80.7 | 0 | 21 | 158 | 353 | 398 | KAK2563153.1 Leucine-rich repeat serine/threonine-protein kinase 2 [Acropora cervicornis] | diamond | 819 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 29776058 | 29776058 | PRJNA384462_S_NODE_6671_length_214_cov_1.545455_g6555_i0 | PRJNA384462 | 6671 | 214 | 1.545455 | 3.3072737 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 77.4 | 3.52e-15 | NR | XP_001628718.1 | 45351 | g6555 | i0 | 52.1 | 13.3177570093458 | 73 | 29 | 93.9 | 1 | 213 | 13 | 162 | 234 | XP_001628718.1 60S ribosomal protein L7 [Nematostella vectensis] | diamond | 2850 | 77.8 | 0.994858611825193 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 30485963 | 30485963 | PRJNA384462_S_NODE_6873_length_212_cov_0.920245_g6757_i0 | PRJNA384462 | 6873 | 212 | 0.920245 | 1.9509194 | Actinostola sp. cb2 | 3060491 | Cnidaria | other_Eukaryota | 65.1 | 3.25e-10 | NR | KAK3740943.1 | 3060491 | g6757 | i0 | 55.7 | 1.9811320754717 | 70 | 31 | 99.1 | 0 | 3 | 212 | 53 | 122 | KAK3740943.1 hypothetical protein QZH41_017792 [Actinostola sp. cb2023] | diamond | 420 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Actinostola | Actinostola sp. cb2023 | |
| 30864978 | 30864978 | PRJNA384462_S_NODE_12694_length_167_cov_2.593220_g12578_i0 | PRJNA384462 | 12694 | 167 | 2.59322 | 4.3306774 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 50.1 | 2.79e-5 | NR | AAO20336.1 | 6087 | g12578 | i0 | 61 | 1.47305389221557 | 41 | 16 | 73.7 | 0 | 165 | 43 | 185 | 225 | AAO20336.1 ribosomal protein S3, partial [Hydra vulgaris] | diamond | 246 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 31813562 | 31813562 | PRJNA384462_S_NODE_11317_length_175_cov_2.452381_g11201_i0 | PRJNA384462 | 11317 | 175 | 2.452381 | 4.29166675 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 62.4 | 1.68e-9 | NR | KXJ25318.1 | 2652724 | g11201 | i0 | 74.3 | 11.4 | 35 | 9 | 60 | 0 | 69 | 173 | 281 | 315 | KXJ25318.1 putative ATP-dependent RNA helicase DDX56 [Exaiptasia diaphana] | diamond | 1995 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 31893736 | 31893736 | PRJNA384462_S_NODE_8977_length_191_cov_1.739437_g8861_i0 | PRJNA384462 | 8977 | 191 | 1.739437 | 3.32232467 | root | 1 | Root_unresolved | Root_unresolved | 45.1 | 0.00287 | NR | PFX21664.1 | 50429 | g8861 | i0 | 42.2 | 1.28795811518325 | 45 | 26 | 70.7 | 0 | 174 | 40 | 230 | 274 | PFX21664.1 hypothetical protein AWC38_SpisGene13848 [Stylophora pistillata] | diamond | 246 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 32035042 | 32035042 | PRJNA384462_S_NODE_2398_length_336_cov_1.418118_g2282_i0 | PRJNA384462 | 2398 | 336 | 1.418118 | 4.76487648 | Porites lobata | 104759 | Cnidaria | other_Eukaryota | 45.4 | 0.0123 | NR | CAH3156649.1 | 104759 | g2282 | i0 | 39.5 | 0.723214285714286 | 81 | 40 | 66.1 | 5 | 259 | 38 | 419 | 497 | CAH3156649.1 unnamed protein product [Porites lobata] | diamond | 243 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 32824844 | 32824844 | PRJNA384462_S_NODE_6600_length_215_cov_0.921687_g6484_i0 | PRJNA384462 | 6600 | 215 | 0.921687 | 1.98162705 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 47 | 3.71e-4 | NR | XP_057316972.1 | 13093 | g6484 | i0 | 40.9 | 0.92093023255814 | 66 | 38 | 92.1 | 1 | 10 | 207 | 93 | 157 | XP_057316972.1 uncharacterized protein LOC130657978 [Hydractinia symbiolongicarpus] | diamond | 198 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus |
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);;