contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA494251" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4302343 | 4302343 | PRJNA494251_P_NODE_42684_length_246_cov_1.433526_g42370_i0 | PRJNA494251 | 42684 | 246 | 1.433526 | 3.52647396 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 145 | 3.56e-30 | NTclustered | gi|2202661671|ref|XM_047003315.1| | 2897299 | g42370 | i0 | 85.507 | 4.6869918699187 | 138 | 20 | 56 | 0 | 3 | 140 | 2771 | 2908 | PREDICTED: Xenia sp. Carnegie-2017 26S proteasome non-ATPase regulatory subunit 2-like (LOC124452719), mRNA | blastn | 1153 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 4935116 | 4935116 | PRJNA494251_P_NODE_40804_length_248_cov_0.880000_g40490_i0 | PRJNA494251 | 40804 | 248 | 0.88 | 2.1824 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 60.2 | 1.34e-4 | NTclustered | gi|2917940696|emb|OZ237557.1| | 6108 | g40490 | i0 | 92.683 | 11.2258064516129 | 41 | 3 | 17 | 0 | 18 | 58 | 13835449 | 13835489 | Anemonia sulcata genome assembly, chromosome: 3 | blastn | 2784 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 5579118 | 5579118 | PRJNA494251_P_NODE_6185_length_520_cov_8.724832_g5885_i0 | PRJNA494251 | 6185 | 520 | 8.724832 | 45.3691264 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 311 | 7.62e-80 | NTclustered | gi|1524889088|ref|XM_027196664.1| | 46731 | g5885 | i0 | 81.649 | 61.2519230769231 | 376 | 67 | 72 | 2 | 53 | 427 | 560 | 186 | PREDICTED: Pocillopora damicornis peptidyl-prolyl cis-trans isomerase-like (LOC113679698), mRNA | blastn | 31851 | 311 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 6210259 | 6210259 | PRJNA494251_P_NODE_21405_length_309_cov_1.347458_g21091_i0 | PRJNA494251 | 21405 | 309 | 1.347458 | 4.16364522 | Myxobolidae | 35587 | Cnidaria | other_Eukaryota | 158 | 5.939999999999999e-34 | NTclustered | gi|2089706636|gb|OK030695.1| | 1720082 | g21091 | i0 | 97.802 | 21.4983818770227 | 91 | 2 | 29 | 0 | 1 | 91 | 2028 | 1938 | Unicauda fimbrethilae large subunit ribosomal RNA gene, partial sequence | blastn | 6643 | 159 | 0.993710691823899 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Unicauda | Unicauda fimbrethilae | |
| 6852985 | 6852985 | PRJNA494251_P_NODE_29806_length_272_cov_2.939698_g29492_i0 | PRJNA494251 | 29806 | 272 | 2.939698 | 7.99597856 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2918369567|emb|OZ237733.1| | 317547 | g29492 | i0 | 96.97 | 0.768382352941177 | 33 | 0 | 12 | 1 | 194 | 226 | 812068 | 812037 | Eunicella cavolini genome assembly, chromosome: 17 | blastn | 209 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 11953945 | 11953945 | PRJNA494251_P_NODE_20550_length_314_cov_1.435685_g20236_i0 | PRJNA494251 | 20550 | 314 | 1.435685 | 4.5080509 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 76.8 | 1.74e-9 | NTclustered | gi|1619644761|ref|XM_021045705.2| | 2652724 | g20236 | i0 | 89.831 | 4.6687898089172 | 59 | 6 | 19 | 0 | 9 | 67 | 578 | 520 | PREDICTED: Exaiptasia diaphana eukaryotic peptide chain release factor GTP-binding subunit ERF3A (LOC110239944), mRNA | blastn | 1466 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 12585872 | 12585872 | PRJNA494251_P_NODE_7630_length_474_cov_1.533666_g7327_i0 | PRJNA494251 | 7630 | 474 | 1.533666 | 7.26957684 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 60.2 | 2.76e-4 | NTclustered | gi|2917940687|emb|OZ237555.1| | 6108 | g7327 | i0 | 100 | 0.582278481012658 | 32 | 0 | 7 | 0 | 95 | 126 | 20196514 | 20196545 | Anemonia sulcata genome assembly, chromosome: 1 | blastn | 276 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 13229322 | 13229322 | PRJNA494251_P_NODE_44471_length_245_cov_0.895349_g44157_i0 | PRJNA494251 | 44471 | 245 | 0.895349 | 2.19360505 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 58.4 | 4.75e-4 | NTclustered | gi|2917940735|emb|OZ237565.1| | 6108 | g44157 | i0 | 97.059 | 0.277551020408163 | 34 | 1 | 14 | 0 | 146 | 179 | 8222402 | 8222369 | Anemonia sulcata genome assembly, chromosome: 11 | blastn | 68 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 15778136 | 15778136 | PRJNA494251_P_NODE_46773_length_243_cov_0.905882_g46459_i0 | PRJNA494251 | 46773 | 243 | 0.905882 | 2.20129326 | Montipora capricornis | 246305 | Cnidaria | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2812107500|ref|XM_068866263.1| | 246305 | g46459 | i0 | 94.286 | 0.288065843621399 | 35 | 0 | 14 | 2 | 99 | 133 | 1515 | 1547 | PREDICTED: Montipora capricornis anillin-like (LOC138019467), transcript variant X2, mRNA | blastn | 70 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 18326910 | 18326910 | PRJNA494251_P_NODE_24955_length_291_cov_1.389908_g24641_i0 | PRJNA494251 | 24955 | 291 | 1.389908 | 4.04463228 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 58.4 | 5.79e-4 | NTclustered | gi|2917940752|emb|OZ237570.1| | 6108 | g24641 | i0 | 97.059 | 0.350515463917526 | 34 | 1 | 12 | 0 | 250 | 283 | 654564 | 654597 | Anemonia sulcata genome assembly, chromosome: 16 | blastn | 102 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 20233289 | 20233289 | PRJNA494251_P_NODE_24116_length_295_cov_1.387387_g23802_i0 | PRJNA494251 | 24116 | 295 | 1.387387 | 4.09279165 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 95.3 | 4.49e-15 | NTclustered | gi|2744834657|ref|XM_002163363.5| | 6087 | g23802 | i0 | 87.654 | 0.8 | 81 | 10 | 27 | 0 | 2 | 82 | 300 | 380 | PREDICTED: Hydra vulgaris ubiquitin-like FUBI-ribosomal protein eS30 fusion protein (LOC100211988), mRNA | blastn | 236 | 95.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 20877090 | 20877090 | PRJNA494251_P_NODE_2997_length_710_cov_2.455259_g2727_i0 | PRJNA494251 | 2997 | 710 | 2.455259 | 17.4323389 | Obelia bidentata | 314517 | Cnidaria | other_Eukaryota | 396 | 2.8499999999999994e-105 | NTclustered | gi|62825445|gb|AY789859.1| | 314517 | g2727 | i0 | 84.673 | 45.9915492957746 | 398 | 59 | 56 | 2 | 64 | 460 | 3 | 399 | Obelia bidentata voucher 76NC calmodulin gene, partial cds | blastn | 32654 | 396 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Obeliidae | Obelia | Obelia bidentata | |
| 23427855 | 23427855 | PRJNA494251_P_NODE_40159_length_248_cov_1.760000_g39845_i0 | PRJNA494251 | 40159 | 248 | 1.76 | 4.3648 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 58.4 | 4.82e-4 | NTclustered | gi|2812002153|ref|XM_068819268.1| | 591990 | g39845 | i0 | 100 | 0.241935483870968 | 31 | 0 | 13 | 0 | 201 | 231 | 14 | 44 | PREDICTED: Montipora foliosa secreted acidic protein 2-like (LOC137972514), mRNA | blastn | 60 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 24701500 | 24701500 | PRJNA494251_P_NODE_49040_length_241_cov_1.630952_g48726_i0 | PRJNA494251 | 49040 | 241 | 1.630952 | 3.93059432 | Symplectoscyphus tricuspidatus | 308614 | Cnidaria | other_Eukaryota | 93.5 | 1.28e-14 | NTclustered | gi|1006165264|gb|KT190774.1| | 308614 | g48726 | i0 | 83.036 | 10.0041493775934 | 112 | 9 | 45 | 6 | 8 | 116 | 2385 | 2489 | Symplectoscyphus tricuspidatus voucher MBM240558 clone STNB12P212-1, P213-1 28S ribosomal RNA gene, partial sequence | blastn | 2411 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Sertulariidae | Symplectoscyphus | Symplectoscyphus tricuspidatus | |
| 24701519 | 24701519 | PRJNA494251_P_NODE_50720_length_236_cov_2.165644_g50406_i0 | PRJNA494251 | 50720 | 236 | 2.165644 | 5.11091984 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 58.4 | 4.55e-4 | NTclustered | gi|2917940714|emb|OZ237561.1| | 6108 | g50406 | i0 | 97.143 | 0.385593220338983 | 35 | 0 | 15 | 1 | 22 | 56 | 4542884 | 4542917 | Anemonia sulcata genome assembly, chromosome: 7 | blastn | 91 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 24701535 | 24701535 | PRJNA494251_P_NODE_52240_length_213_cov_5.235714_g51926_i0 | PRJNA494251 | 52240 | 213 | 5.235714 | 11.15207082 | Bivalvulida gen. n. sp. a JO-2023 | 3073449 | Cnidaria | other_Eukaryota | 211 | 2.92e-50 | NTclustered | gi|2572825558|gb|OR509833.1| | 3073449 | g51926 | i0 | 86.735 | 72.1408450704225 | 196 | 18 | 92 | 6 | 2 | 196 | 427 | 615 | Bivalvulida gen. n. sp. a JO-2023 isolate BM_02 large subunit ribosomal RNA gene, partial sequence | blastn | 15366 | 211 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Bivalvulida gen. n. sp. a JO-2023 |
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);;