contig_metadata
15 rows where bioproject = "PRJNA564013" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3102828 | 3102828 | PRJNA564013_P_NODE_365523_length_185_cov_26.701613_g362671_i0 | PRJNA564013 | 365523 | 185 | 26.701613 | 49.39798405 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|2918369535|emb|OZ237717.1| | 317547 | g362671 | i0 | 100 | 0.156756756756757 | 29 | 0 | 16 | 0 | 36 | 64 | 9830707 | 9830735 | Eunicella cavolini genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 7510514 | 7510514 | PRJNA564013_P_NODE_300826_length_225_cov_1.585366_g297974_i0 | PRJNA564013 | 300826 | 225 | 1.585366 | 3.5670735 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 58.4 | 4.3e-4 | NTclustered | gi|2917940740|emb|OZ237567.1| | 6108 | g297974 | i0 | 79.762 | 4.29333333333333 | 84 | 14 | 37 | 3 | 121 | 203 | 1518657 | 1518738 | Anemonia sulcata genome assembly, chromosome: 13 | blastn | 966 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 8200539 | 8200539 | PRJNA564013_P_NODE_153587_length_348_cov_7.456446_g150738_i0 | PRJNA564013 | 153587 | 348 | 7.456446 | 25.94843208 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 52.8 | 0.033 | NTclustered | gi|1005456825|ref|XM_015910048.1| | 70779 | g150738 | i0 | 92.105 | 0.109195402298851 | 38 | 2 | 11 | 1 | 116 | 152 | 1184 | 1221 | PREDICTED: Acropora digitifera cathepsin B-like cysteine proteinase 4 (LOC107344399), mRNA | blastn | 38 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 10061339 | 10061339 | PRJNA564013_P_NODE_348308_length_199_cov_13.855072_g345456_i0 | PRJNA564013 | 348308 | 199 | 13.855072 | 27.57159328 | Oswaldella | 655722 | Cnidaria | other_Eukaryota | 60.2 | 1.03e-4 | NTclustered | gi|984932149|gb|KT722418.1| | 655725 | g345456 | i0 | 100 | 0.482412060301508 | 32 | 0 | 16 | 0 | 26 | 57 | 3 | 34 | Oswaldella laertesi voucher LEM m3x S129 small subunit 18S ribosomal RNA gene, partial sequence | blastn | 96 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Kirchenpaueriidae | Oswaldella | Oswaldella laertesi | |
| 15159912 | 15159912 | PRJNA564013_P_NODE_192132_length_313_cov_10.992063_g189281_i0 | PRJNA564013 | 192132 | 313 | 10.992063 | 34.40515719 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 143 | 1.69e-29 | NTclustered | gi|256674522|gb|FJ550426.1| | 308670 | g189281 | i0 | 90.741 | 54.7188498402556 | 108 | 8 | 50 | 2 | 207 | 313 | 2113 | 2219 | Plumularia spiralis voucher MHNG INVE32600 28S ribosomal RNA gene, partial sequence | blastn | 17127 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Plumulariidae | Plumularia | Plumularia spiralis | |
| 15851066 | 15851066 | PRJNA564013_P_NODE_176093_length_328_cov_6.640449_g173243_i0 | PRJNA564013 | 176093 | 328 | 6.640449 | 21.78067272 | Errina atlantica | 3282226 | Cnidaria | other_Eukaryota | 52.8 | 0.031 | NTclustered | gi|2905010471|gb|PV035086.1| | 3282226 | g173243 | i0 | 100 | 0.0853658536585366 | 28 | 0 | 9 | 0 | 119 | 146 | 2693 | 2720 | Errina atlantica isolate USNM1673622 mitochondrion, partial genome | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Stylasteridae | Errina | Errina atlantica | |
| 17127145 | 17127145 | PRJNA564013_P_NODE_232294_length_276_cov_10.683721_g229442_i0 | PRJNA564013 | 232294 | 276 | 10.683721 | 29.48706996 | Calycella syringa | 314529 | Cnidaria | other_Eukaryota | 110 | 1.48e-19 | NTclustered | gi|256674468|gb|FJ550372.1| | 314529 | g229442 | i0 | 84.821 | 19.0253623188406 | 112 | 13 | 39 | 4 | 99 | 207 | 1457 | 1567 | Calycella syringa 28S ribosomal RNA gene, partial sequence | blastn | 5251 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Campanulariidae | Calycella | Calycella syringa | |
| 19675948 | 19675948 | PRJNA564013_P_NODE_233916_length_275_cov_3.738318_g231064_i0 | PRJNA564013 | 233916 | 275 | 3.738318 | 10.2803745 | Acropora muricata | 159855 | Cnidaria | other_Eukaryota | 52.8 | 0.025 | NTclustered | gi|2784711924|ref|XM_067185087.1| | 159855 | g231064 | i0 | 100 | 0.101818181818182 | 28 | 0 | 10 | 0 | 106 | 133 | 2657 | 2630 | PREDICTED: Acropora muricata uncharacterized protein (LOC136917516), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora muricata | |
| 27205398 | 27205398 | PRJNA564013_P_NODE_124002_length_378_cov_4.208202_g121156_i0 | PRJNA564013 | 124002 | 378 | 4.208202 | 15.90700356 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 71.6 | 1.29e-11 | NR | XP_065675501.1 | 6087 | g121156 | i0 | 36.4 | 0.936507936507937 | 118 | 73 | 92.1 | 1 | 27 | 374 | 188 | 305 | XP_065675501.1 uncharacterized protein LOC136091722 [Hydra vulgaris] | diamond | 354 | 71.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 29826400 | 29826400 | PRJNA564013_P_NODE_181871_length_323_cov_4.122137_g179021_i0 | PRJNA564013 | 181871 | 323 | 4.122137 | 13.31450251 | Porites evermanni | 104178 | Cnidaria | other_Eukaryota | 70.5 | 1.45e-12 | NR | CAH3191542.1 | 104178 | g179021 | i0 | 42.3 | 3.86377708978328 | 104 | 54 | 91 | 2 | 317 | 24 | 56 | 159 | CAH3191542.1 unnamed protein product, partial [Porites evermanni] | diamond | 1248 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 30395647 | 30395647 | PRJNA564013_P_NODE_35753_length_643_cov_14.307560_g33090_i0 | PRJNA564013 | 35753 | 643 | 14.30756 | 91.9976108 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 47.4 | 0.0294 | NR | CAB4025375.1 | 317549 | g33090 | i0 | 34.7 | 0.349922239502333 | 75 | 48 | 35 | 1 | 21 | 245 | 1012 | 1085 | CAB4025375.1 zinc finger [Paramuricea clavata] | diamond | 225 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 31027272 | 31027272 | PRJNA564013_P_NODE_206855_length_299_cov_28.542017_g204004_i0 | PRJNA564013 | 206855 | 299 | 28.542017 | 85.34063083 | Actinostola sp. cb2 | 3060491 | Cnidaria | other_Eukaryota | 56.6 | 8.52e-7 | NR | KAK3739092.1 | 3060491 | g204004 | i0 | 54.5 | 0.441471571906354 | 44 | 20 | 44.1 | 0 | 214 | 83 | 111 | 154 | KAK3739092.1 hypothetical protein QZH41_006316 [Actinostola sp. cb2023] | diamond | 132 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Actinostola | Actinostola sp. cb2023 | |
| 31279880 | 31279880 | PRJNA564013_P_NODE_294655_length_229_cov_1.523810_g291803_i0 | PRJNA564013 | 294655 | 229 | 1.52381 | 3.4895249 | Actinostola sp. cb2 | 3060491 | Cnidaria | other_Eukaryota | 42.4 | 0.0427 | NR | KAK3728551.1 | 3060491 | g291803 | i0 | 36.4 | 0.720524017467249 | 55 | 35 | 72.1 | 0 | 177 | 13 | 318 | 372 | KAK3728551.1 hypothetical protein QZH41_011640 [Actinostola sp. cb2023] | diamond | 165 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Actinostola | Actinostola sp. cb2023 | |
| 32021306 | 32021306 | PRJNA564013_P_NODE_36598_length_637_cov_5.390625_g33928_i0 | PRJNA564013 | 36598 | 637 | 5.390625 | 34.33828125 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 61.2 | 5.1e-7 | NR | XP_022788722.1 | 50429 | g33928 | i0 | 35.2 | 2.47252747252747 | 105 | 65 | 49.5 | 2 | 212 | 526 | 423 | 524 | XP_022788722.1 uncharacterized protein LOC111328527 [Stylophora pistillata] | diamond | 1575 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 32070777 | 32070777 | PRJNA564013_P_NODE_56758_length_529_cov_22.237179_g53978_i0 | PRJNA564013 | 56758 | 529 | 22.237179 | 117.63467691 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 63.9 | 3.05e-8 | NR | XP_028405267.1 | 151771 | g53978 | i0 | 49.1 | 0.958412098298677 | 57 | 29 | 32.3 | 0 | 336 | 506 | 1306 | 1362 | XP_028405267.1 uncharacterized protein LOC114527777 [Dendronephthya gigantea] | diamond | 507 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea |
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);;