contig_metadata
20 rows where bioproject = "PRJNA193544" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4883216 | 4883216 | PRJNA193544_S_NODE_2764_length_166_cov_8.963504_g2749_i0 | PRJNA193544 | 2764 | 166 | 8.963504 | 14.87941664 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 222 | 1e-53 | NTclustered | gi|2689317372|gb|PP410781.1| | 578585 | g2749 | i0 | 90.909 | 99.566265060241 | 165 | 15 | 99 | 0 | 1 | 165 | 1484 | 1648 | Aphanipathes pedata voucher USNM:1695055 large subunit ribosomal RNA gene, partial sequence | blastn | 16528 | 222 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Antipatharia | Aphanipathidae | Aphanipathes | Aphanipathes pedata | |
| 6743579 | 6743579 | PRJNA193544_S_NODE_3226_length_155_cov_22.039683_g3211_i0 | PRJNA193544 | 3226 | 155 | 22.039683 | 34.16150865 | Sibogagorgia sp. | 3097326 | Cnidaria | other_Eukaryota | 86.1 | 1.26e-12 | NTclustered | gi|2689317284|gb|PP410738.1| | 3097326 | g3211 | i0 | 81.915 | 2.4258064516129 | 94 | 15 | 59 | 2 | 48 | 139 | 3517 | 3610 | Sibogagorgia sp. voucher USNM:1695026 large subunit ribosomal RNA gene, partial sequence | blastn | 376 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleralcyonacea | Coralliidae | Sibogagorgia | Sibogagorgia sp. | |
| 7433121 | 7433121 | PRJNA193544_S_NODE_1726_length_202_cov_20277.832370_g1711_i0 | PRJNA193544 | 1726 | 202 | 20277.83237 | 40961.2213874 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 228 | 2.7199999999999995e-55 | NTclustered | gi|15208488|gb|AY026375.1| | 48499 | g1711 | i0 | 93.464 | 76.2079207920792 | 153 | 10 | 76 | 0 | 50 | 202 | 3358 | 3206 | Montastraea franksi 28S large subunit ribosomal RNA gene, partial sequence | blastn | 15394 | 228 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella franksi | |
| 11258472 | 11258472 | PRJNA193544_S_NODE_809_length_272_cov_9.650206_g794_i0 | PRJNA193544 | 809 | 272 | 9.650206 | 26.24856032 | Anthoathecata | 406427 | Cnidaria | other_Eukaryota | 84.2 | 8.85e-12 | NTclustered | gi|259130322|gb|GQ424317.1| | 168780 | g794 | i0 | 96.078 | 18.0183823529412 | 51 | 2 | 19 | 0 | 220 | 270 | 2139 | 2089 | Polyorchis haplus isolate 06CA001 28S ribosomal RNA gene, partial sequence | blastn | 4901 | 84.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Polyorchidae | Polyorchis | Polyorchis haplus | |
| 11844474 | 11844474 | PRJNA193544_S_NODE_430_length_330_cov_6.102990_g415_i0 | PRJNA193544 | 430 | 330 | 6.10299 | 20.139867 | Myxobolus arcticus | 81492 | Cnidaria | other_Eukaryota | 326 | 1.6599999999999999e-84 | NTclustered | gi|380343413|gb|JN003830.1| | 81492 | g415 | i0 | 85.106 | 82 | 329 | 37 | 99 | 10 | 1 | 327 | 1378 | 1060 | Myxobolus arcticus from Japan 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 | 27060 | 326 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus arcticus | |
| 15668667 | 15668667 | PRJNA193544_S_NODE_1473_length_214_cov_21282.286486_g1458_i0 | PRJNA193544 | 1473 | 214 | 21282.286486 | 45544.09308004 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 78.7 | 3.11e-10 | NTclustered | gi|2918369537|emb|OZ237719.1| | 317547 | g1458 | i0 | 92.593 | 8.03738317757009 | 54 | 4 | 45 | 0 | 161 | 214 | 27389922 | 27389975 | Eunicella cavolini genome assembly, chromosome: 3 | blastn | 1720 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 15668677 | 15668677 | PRJNA193544_S_NODE_1713_length_203_cov_5.988506_g1698_i0 | PRJNA193544 | 1713 | 203 | 5.988506 | 12.15666718 | Sphaeromyxa sp. M0416 | 650982 | Cnidaria | other_Eukaryota | 82.4 | 2.26e-11 | NTclustered | gi|241911767|gb|FJ417073.1| | 650982 | g1698 | i0 | 81.818 | 0.487684729064039 | 99 | 16 | 48 | 2 | 83 | 180 | 98 | 1 | Sphaeromyxa sp. M0416 28S large subunit ribosomal RNA gene, partial sequence | blastn | 99 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Sphaeromyxidae | Sphaeromyxa | Sphaeromyxa sp. M0416 | |
| 16943137 | 16943137 | PRJNA193544_S_NODE_1354_length_221_cov_20677.744792_g1339_i0 | PRJNA193544 | 1354 | 221 | 20677.744792 | 45697.81599032 | Ortholinea sp. jeju-2020 | 2806109 | Cnidaria | other_Eukaryota | 202 | 1.8399999999999998e-47 | NTclustered | gi|1972887737|gb|MW540892.2| | 2806109 | g1339 | i0 | 98.261 | 50.1945701357466 | 115 | 2 | 52 | 0 | 34 | 148 | 3176 | 3062 | Ortholinea sp. jeju-2020 large subunit ribosomal RNA gene, partial sequence | blastn | 11093 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Ortholineidae | Ortholinea | Ortholinea sp. jeju-2020 | |
| 16943139 | 16943139 | PRJNA193544_S_NODE_1414_length_218_cov_12.047619_g1399_i0 | PRJNA193544 | 1414 | 218 | 12.047619 | 26.26380942 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 217 | 6.459999999999999e-52 | NTclustered | gi|2663986575|emb|OY756916.1| | 69463 | g1399 | i0 | 87.179 | 86.394495412844 | 195 | 19 | 88 | 5 | 28 | 218 | 5764 | 5572 | Henneguya salminicola isolate Hz1 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 18834 | 217 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 16943170 | 16943170 | PRJNA193544_S_NODE_274_length_366_cov_21.204748_g259_i0 | PRJNA193544 | 274 | 366 | 21.204748 | 77.60937768 | Myxobolus cloutmani | 2766936 | Cnidaria | other_Eukaryota | 302 | 3.12e-77 | NTclustered | gi|1896054819|gb|MT919695.1| | 2766936 | g259 | i0 | 88.372 | 69.9289617486339 | 258 | 21 | 70 | 6 | 63 | 320 | 1087 | 839 | Myxobolus cloutmani isolate CTM large subunit ribosomal RNA gene, partial sequence | blastn | 25594 | 302 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus cloutmani | |
| 18217556 | 18217556 | PRJNA193544_S_NODE_1075_length_245_cov_14.171296_g1060_i0 | PRJNA193544 | 1075 | 245 | 14.171296 | 34.7196752 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 195 | 3.47e-45 | NTclustered | gi|2663986577|emb|OY756918.1| | 59785 | g1060 | i0 | 83.333 | 59.1836734693878 | 228 | 20 | 93 | 15 | 19 | 245 | 4184 | 3974 | Myxobolus squamalis isolate 71B08 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 14500 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 18217572 | 18217572 | PRJNA193544_S_NODE_1695_length_204_cov_6.817143_g1680_i0 | PRJNA193544 | 1695 | 204 | 6.817143 | 13.90697172 | Henneguya doneci | 378740 | Cnidaria | other_Eukaryota | 134 | 6.1800000000000006e-27 | NTclustered | gi|384482801|gb|JQ690376.1| | 378740 | g1680 | i0 | 85.938 | 45.0637254901961 | 128 | 14 | 63 | 3 | 1 | 128 | 1621 | 1498 | Henneguya doneci isolate 8-3 28S ribosomal RNA gene, partial sequence | blastn | 9193 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya doneci | |
| 20181277 | 20181277 | PRJNA193544_S_NODE_1336_length_222_cov_18299.621762_g1321_i0 | PRJNA193544 | 1336 | 222 | 18299.621762 | 40625.16031164 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 291 | 3.83e-74 | NTclustered | gi|15208488|gb|AY026375.1| | 48499 | g1321 | i0 | 94.241 | 86.3378378378378 | 191 | 10 | 86 | 1 | 1 | 190 | 3206 | 3396 | Montastraea franksi 28S large subunit ribosomal RNA gene, partial sequence | blastn | 19167 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella franksi | |
| 21457006 | 21457006 | PRJNA193544_S_NODE_217_length_390_cov_10647.775623_g202_i0 | PRJNA193544 | 217 | 390 | 10647.775623 | 41526.3249297 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.8 | 0.037 | NTclustered | gi|2113715647|ref|XR_006393646.1| | 45264 | g202 | i0 | 100 | 1.14871794871795 | 28 | 0 | 7 | 0 | 363 | 390 | 2993 | 2966 | PREDICTED: Acropora millepora large subunit ribosomal RNA (LOC122954209), rRNA | blastn | 448 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 21457007 | 21457007 | PRJNA193544_S_NODE_237_length_380_cov_331.635328_g222_i0 | PRJNA193544 | 237 | 380 | 331.635328 | 1260.2142464 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.8 | 0.036 | NTclustered | gi|2113715647|ref|XR_006393646.1| | 45264 | g222 | i0 | 100 | 1.17894736842105 | 28 | 0 | 7 | 0 | 1 | 28 | 2966 | 2993 | PREDICTED: Acropora millepora large subunit ribosomal RNA (LOC122954209), rRNA | blastn | 448 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 22042537 | 22042537 | PRJNA193544_S_NODE_3338_length_153_cov_6.862903_g3323_i0 | PRJNA193544 | 3338 | 153 | 6.862903 | 10.50024159 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 283 | 4.0799999999999995e-72 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g3323 | i0 | 100 | 5.02614379084967 | 153 | 0 | 100 | 0 | 1 | 153 | 2068 | 2220 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 769 | 283 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 22732007 | 22732007 | PRJNA193544_S_NODE_2998_length_160_cov_6.679389_g2983_i0 | PRJNA193544 | 2998 | 160 | 6.679389 | 10.6870224 | Stichodactylidae | 42825 | Cnidaria | other_Eukaryota | 152 | 1.2699999999999998e-32 | NTclustered | gi|506993414|gb|KC812185.1| | 478399 | g2983 | i0 | 84.242 | 58.40625 | 165 | 17 | 100 | 9 | 1 | 160 | 1472 | 1632 | Heteractis aurora isolate HR2 18S ribosomal RNA gene, partial sequence | blastn | 9345 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Stichodactylidae | Heteractis | Heteractis aurora | |
| 23318028 | 23318028 | PRJNA193544_S_NODE_719_length_284_cov_9.133333_g704_i0 | PRJNA193544 | 719 | 284 | 9.133333 | 25.93866572 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 525 | 1.2899999999999994e-144 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g704 | i0 | 100 | 48.6866197183099 | 284 | 0 | 100 | 0 | 1 | 284 | 439 | 156 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 13827 | 525 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 24592128 | 24592128 | PRJNA193544_S_NODE_1940_length_194_cov_8.387879_g1925_i0 | PRJNA193544 | 1940 | 194 | 8.387879 | 16.27248526 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 217 | 5.61e-52 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g1925 | i0 | 99.174 | 82.701030927835 | 121 | 0 | 62 | 1 | 20 | 140 | 120 | 1 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 16044 | 217 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 25281327 | 25281327 | PRJNA193544_S_NODE_3000_length_160_cov_3.427481_g2985_i0 | PRJNA193544 | 3000 | 160 | 3.4274810000000002 | 5.4839696 | Clytia | 13436 | Cnidaria | other_Eukaryota | 69.4 | 1.32e-7 | NTclustered | gi|1069323964|gb|KX665481.1| | 252669 | g2985 | i0 | 93.617 | 18.48125 | 47 | 2 | 29 | 1 | 114 | 160 | 2237 | 2282 | Clytia gracilis voucher MZUSP:2767 28S ribosomal RNA gene, partial sequence | blastn | 2957 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia gracilis |
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);;