contig_metadata
14 rows where bioproject = "PRJNA438687", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5539090 | 5539090 | PRJNA438687_S_NODE_8245_length_150_cov_1.486957_g8155_i0 | PRJNA438687 | 8245 | 150 | 1.486957 | 2.2304355 | Stomphia didemon | 478421 | Cnidaria | other_Eukaryota | 119 | 1.19e-22 | NTclustered | gi|636577293|gb|KJ483127.1| | 478421 | g8155 | i0 | 87.379 | 70.26 | 103 | 13 | 69 | 0 | 1 | 103 | 978 | 876 | Stomphia didemon isolate st 28S large subunit ribosomal RNA gene, partial sequence | blastn | 10539 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Stomphia | Stomphia didemon | |
| 10019403 | 10019403 | PRJNA438687_S_NODE_7668_length_156_cov_2.024793_g7578_i0 | PRJNA438687 | 7668 | 156 | 2.024793 | 3.15867708 | Ectopleura | 264051 | Cnidaria | other_Eukaryota | 117 | 4.49e-22 | NTclustered | gi|166407145|gb|EU272561.1| | 498506 | g7578 | i0 | 82.119 | 6.71794871794872 | 151 | 14 | 96 | 4 | 2 | 151 | 1398 | 1536 | Ectopleura dumortieri voucher personal:A. Lindner:AL525 28S large subunit ribosomal RNA gene, partial sequence | blastn | 1048 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Tubulariidae | Ectopleura | Ectopleura dumortierii | |
| 10639132 | 10639132 | PRJNA438687_S_NODE_1489_length_334_cov_5.428094_g1399_i0 | PRJNA438687 | 1489 | 334 | 5.428094 | 18.12983396 | Sphaeromyxa zaharoni | 275449 | Cnidaria | other_Eukaryota | 60.2 | 1.88e-4 | NTclustered | gi|2663986569|emb|OY751524.1| | 275449 | g1399 | i0 | 100 | 1.9940119760479 | 32 | 0 | 10 | 0 | 222 | 253 | 6365 | 6334 | Sphaeromyxa zaharoni isolate 24.2.2011 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 666 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Sphaeromyxidae | Sphaeromyxa | Sphaeromyxa zaharoni | |
| 11294335 | 11294335 | PRJNA438687_S_NODE_4989_length_199_cov_2.829268_g4899_i0 | PRJNA438687 | 4989 | 199 | 2.829268 | 5.63024332 | Bougainvilliidae | 168713 | Cnidaria | other_Eukaryota | 89.8 | 1.32e-13 | NTclustered | gi|2743359199|gb|PP913638.1| | 308567 | g4899 | i0 | 75.743 | 9.60301507537688 | 202 | 36 | 99 | 13 | 1 | 197 | 1979 | 1786 | Bougainvillia muscus isolate H49 large subunit ribosomal RNA gene, partial sequence | blastn | 1911 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Bougainvilliidae | Bougainvillia | Bougainvillia muscus | |
| 13188927 | 13188927 | PRJNA438687_S_NODE_1251_length_352_cov_12.107256_g1161_i0 | PRJNA438687 | 1251 | 352 | 12.107256 | 42.61754112 | Polypodium hydriforme | 43186 | Cnidaria | other_Eukaryota | 54.7 | 0.009 | NTclustered | gi|2663986578|emb|OY756919.1| | 43186 | g1161 | i0 | 100 | 0.0823863636363636 | 29 | 0 | 8 | 0 | 107 | 135 | 6126 | 6154 | Polypodium hydriforme genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Polypodiozoa | Polypodiidea | Polypodiidae | Polypodium | Polypodium hydriforme | |
| 13189026 | 13189026 | PRJNA438687_S_NODE_5471_length_189_cov_1.629870_g5381_i0 | PRJNA438687 | 5471 | 189 | 1.62987 | 3.0804543 | Tetrorchis erythrogaster | 515659 | Cnidaria | other_Eukaryota | 102 | 1.59e-17 | NTclustered | gi|1100849074|gb|KY077285.1| | 515659 | g5381 | i0 | 82.5 | 61.2328042328042 | 120 | 18 | 63 | 3 | 5 | 123 | 835 | 718 | Tetrorchis erythrogaster isolate BB027 small subunit ribosomal RNA gene, partial sequence | blastn | 11573 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Trachymedusae | Rhopalonematidae | Tetrorchis | Tetrorchis erythrogaster | |
| 13844761 | 13844761 | PRJNA438687_S_NODE_5591_length_187_cov_1.381579_g5501_i0 | PRJNA438687 | 5591 | 187 | 1.381579 | 2.58355273 | Scleralcyonacea | 3028851 | Cnidaria | other_Eukaryota | 52.8 | 0.016 | NTclustered | gi|2160785914|gb|OL741708.1| | 1399339 | g5501 | i0 | 100 | 0.299465240641711 | 28 | 0 | 15 | 0 | 160 | 187 | 5767 | 5740 | Virgularia mirabilis voucher NMS.Z.2019.25.15 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleralcyonacea | Virgulariidae | Virgularia | Virgularia mirabilis | |
| 13844806 | 13844806 | PRJNA438687_S_NODE_7591_length_157_cov_1.754098_g7501_i0 | PRJNA438687 | 7591 | 157 | 1.754098 | 2.75393386 | Sphaerospora | 109798 | Cnidaria | other_Eukaryota | 87.9 | 3.55e-13 | NTclustered | gi|1279404852|gb|MG554465.1| | 665600 | g7501 | i0 | 90.909 | 6.80891719745223 | 66 | 4 | 42 | 2 | 54 | 119 | 1837 | 1900 | Sphaerospora formosa isolate Olo-8 small subunit ribosomal RNA gene, partial sequence | blastn | 1069 | 87.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Sphaerosporidae | Sphaerospora | Sphaerospora formosa | |
| 14464064 | 14464064 | PRJNA438687_S_NODE_7832_length_154_cov_3.294118_g7742_i0 | PRJNA438687 | 7832 | 154 | 3.294118 | 5.07294172 | Cunina frugifera | 168732 | Cnidaria | other_Eukaryota | 108 | 2.66e-19 | NTclustered | gi|1100849065|gb|KY077276.1| | 168732 | g7742 | i0 | 79.487 | 53.0454545454545 | 156 | 28 | 100 | 4 | 1 | 154 | 1564 | 1411 | Cunina frugifera isolate AGC1026 large subunit ribosomal RNA gene, partial sequence | blastn | 8169 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Narcomedusae | Cuninidae | Cunina | Cunina frugifera | |
| 18286901 | 18286901 | PRJNA438687_S_NODE_1855_length_314_cov_2.745520_g1765_i0 | PRJNA438687 | 1855 | 314 | 2.74552 | 8.6209328 | Salacia desmoides | 662031 | Cnidaria | other_Eukaryota | 73.1 | 2.26e-8 | NTclustered | gi|256674477|gb|FJ550381.1| | 662031 | g1765 | i0 | 86.364 | 10.2834394904459 | 66 | 9 | 21 | 0 | 249 | 314 | 1580 | 1515 | Salacia desmoides 28S ribosomal RNA gene, partial sequence | blastn | 3229 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Sertulariidae | Salacia | Salacia desmoides | |
| 18942685 | 18942685 | PRJNA438687_S_NODE_6715_length_168_cov_5.548872_g6625_i0 | PRJNA438687 | 6715 | 168 | 5.548872 | 9.32210496 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 231 | 1.6899999999999998e-56 | NTclustered | gi|1025756939|gb|KU308586.1| | 37531 | g6625 | i0 | 91.667 | 100 | 168 | 13 | 99 | 1 | 2 | 168 | 1388 | 1221 | Craterolophus convolvulus isolate USA CRA01 28S large subunit ribosomal RNA gene, partial sequence | blastn | 16800 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Staurozoa | Stauromedusae | Craterolophidae | Craterolophus | Craterolophus convolvulus | |
| 24043085 | 24043085 | PRJNA438687_S_NODE_619_length_431_cov_7.709596_g531_i0 | PRJNA438687 | 619 | 431 | 7.709596 | 33.22835876 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 91.6 | 8.81e-14 | NTclustered | gi|2689317146|gb|PP410670.1| | 44190 | g531 | i0 | 94.828 | 21.6705336426914 | 58 | 3 | 20 | 0 | 55 | 112 | 3605 | 3548 | Acanthogorgia sp. voucher USNM:1659375 large subunit ribosomal RNA gene, partial sequence | blastn | 9340 | 91.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Acanthogorgiidae | Acanthogorgia | Acanthogorgia sp. | |
| 24661591 | 24661591 | PRJNA438687_S_NODE_5140_length_195_cov_8.875000_g5050_i0 | PRJNA438687 | 5140 | 195 | 8.875 | 17.30625 | Enallopsammia rostrata | 44301 | Cnidaria | other_Eukaryota | 183 | 5.729999999999998e-42 | NTclustered | gi|353329902|gb|HQ439654.1| | 44301 | g5050 | i0 | 85.876 | 88.1025641025641 | 177 | 19 | 88 | 6 | 1 | 172 | 9 | 184 | Enallopsammia rostrata voucher JCU MVK-48 28S ribosomal RNA gene, partial sequence | blastn | 17180 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Dendrophylliidae | Enallopsammia | Enallopsammia rostrata | |
| 29918195 | 29918195 | PRJNA438687_S_NODE_6291_length_175_cov_1.342857_g6201_i0 | PRJNA438687 | 6291 | 175 | 1.342857 | 2.34999975 | Actinostola sp. cb2 | 3060491 | Cnidaria | other_Eukaryota | 49.7 | 5.36e-5 | NR | KAK3748527.1 | 3060491 | g6201 | i0 | 60 | 0.685714285714286 | 40 | 16 | 68.6 | 0 | 22 | 141 | 463 | 502 | KAK3748527.1 hypothetical protein QZH41_012374 [Actinostola sp. cb2023] | diamond | 120 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Actinostola | Actinostola sp. cb2023 |
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);;