RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJEB27957", tax_kingdom = "Metazoa" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 16 ✖

tax_kingdom 1

  • Metazoa · 16 ✖

tax_clade 1

bioproject 1

  • PRJEB27957 · 16 ✖
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
23429 23429 PRJEB27957_P_NODE_87241_length_184_cov_1.503704_g87131_i0 PRJEB27957 87241 184 1.503704 2.76681536 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 56.5 0.001   NTclustered gi|2518980744|ref|XM_057440768.1| 13093 g87131 i0 96.97 2.64130434782609 33 1 18 0 99 131 2042 2010 PREDICTED: Hydractinia symbiolongicarpus uncharacterized LOC130625669 (LOC130625669), mRNA blastn 486 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
1297650 1297650 PRJEB27957_P_NODE_39482_length_254_cov_1.482927_g39372_i0 PRJEB27957 39482 254 1.482927 3.76663458 Eunicella cavolini 317547 Cnidaria other_Eukaryota 56.5 0.002   NTclustered gi|2918369537|emb|OZ237719.1| 317547 g39372 i0 96.97 0.12992125984252 33 1 13 0 154 186 30822678 30822646 Eunicella cavolini genome assembly, chromosome: 3 blastn 33 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
2573332 2573332 PRJEB27957_P_NODE_51983_length_228_cov_1.452514_g51873_i0 PRJEB27957 51983 228 1.452514 3.31173192 Eunicella cavolini 317547 Cnidaria other_Eukaryota 56.5 0.002   NTclustered gi|2918369536|emb|OZ237718.1| 317547 g51873 i0 100 3.34649122807018 30 0 13 0 41 70 20127839 20127868 Eunicella cavolini genome assembly, chromosome: 2 blastn 763 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
10226147 10226147 PRJEB27957_P_NODE_110669_length_167_cov_0.881356_g110559_i0 PRJEB27957 110669 167 0.881356 1.47186452 Eunicella cavolini 317547 Cnidaria other_Eukaryota 52.8 0.014   NTclustered gi|2918369539|emb|OZ237721.1| 317547 g110559 i0 96.774 0.18562874251497 31 1 19 0 123 153 31735645 31735615 Eunicella cavolini genome assembly, chromosome: 5 blastn 31 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
10226167 10226167 PRJEB27957_P_NODE_34929_length_266_cov_2.156682_g34819_i0 PRJEB27957 34929 266 2.156682 5.73677412 Eunicella cavolini 317547 Cnidaria other_Eukaryota 56.5 0.002   NTclustered gi|2918369538|emb|OZ237720.1| 317547 g34819 i0 90.698 0.161654135338346 43 2 16 1 55 97 19621841 19621881 Eunicella cavolini genome assembly, chromosome: 4 blastn 43 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
12776972 12776972 PRJEB27957_P_NODE_22131_length_317_cov_1.880597_g22021_i0 PRJEB27957 22131 317 1.880597 5.96149249 Eunicella cavolini 317547 Cnidaria other_Eukaryota 52.8 0.03   NTclustered gi|2918369535|emb|OZ237717.1| 317547 g22021 i0 100 0.0883280757097792 28 0 9 0 100 127 47877154 47877127 Eunicella cavolini genome assembly, chromosome: 1 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
16289500 16289500 PRJEB27957_P_NODE_51793_length_228_cov_2.033520_g51683_i0 PRJEB27957 51793 228 2.03352 4.6364256 Metazoa 33208 Cnidaria other_Eukaryota 52.8 0.02   NTclustered gi|2917940687|emb|OZ237555.1| 6108 g51683 i0 100 0.245614035087719 28 0 12 0 18 45 33072859 33072832 Anemonia sulcata genome assembly, chromosome: 1 blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
16600210 16600210 PRJEB27957_P_NODE_123994_length_162_cov_1.336283_g123884_i0 PRJEB27957 123994 162 1.336283 2.16477846 Anemonia sulcata 6108 Cnidaria other_Eukaryota 63.9 6.23e-6   NTclustered gi|2917940701|emb|OZ237558.1| 6108 g123884 i0 97.297 3.18518518518519 37 1 23 0 24 60 3014853 3014817 Anemonia sulcata genome assembly, chromosome: 4 blastn 516 63.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
16600257 16600257 PRJEB27957_P_NODE_94694_length_176_cov_2.866142_g94584_i0 PRJEB27957 94694 176 2.866142 5.04440992 Eunicella cavolini 317547 Cnidaria other_Eukaryota 52.8 0.015   NTclustered gi|2918369536|emb|OZ237718.1| 317547 g94584 i0 100 0.636363636363636 28 0 16 0 137 164 65157915 65157888 Eunicella cavolini genome assembly, chromosome: 2 blastn 112 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
19148894 19148894 PRJEB27957_P_NODE_20076_length_329_cov_1.292857_g19966_i0 PRJEB27957 20076 329 1.292857 4.25349953 Anemonia sulcata 6108 Cnidaria other_Eukaryota 54.7 0.009   NTclustered gi|2917940712|emb|OZ237560.1| 6108 g19966 i0 100 0.173252279635258 29 0 9 0 300 328 12740899 12740927 Anemonia sulcata genome assembly, chromosome: 6 blastn 57 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
19148926 19148926 PRJEB27957_P_NODE_68036_length_205_cov_1.666667_g67926_i0 PRJEB27957 68036 205 1.666667 3.41666735 Anemonia sulcata 6108 Cnidaria other_Eukaryota 52.8 0.018   NTclustered gi|2917940687|emb|OZ237555.1| 6108 g67926 i0 100 0.136585365853659 28 0 14 0 95 122 525363 525336 Anemonia sulcata genome assembly, chromosome: 1 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
20424108 20424108 PRJEB27957_P_NODE_34697_length_267_cov_1.513761_g34587_i0 PRJEB27957 34697 267 1.513761 4.04174187 Eunicella cavolini 317547 Cnidaria other_Eukaryota 52.8 0.024   NTclustered gi|2918369540|emb|OZ237722.1| 317547 g34587 i0 100 0.104868913857678 28 0 10 0 20 47 986750 986777 Eunicella cavolini genome assembly, chromosome: 6 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
22975381 22975381 PRJEB27957_P_NODE_54299_length_224_cov_2.080000_g54189_i0 PRJEB27957 54299 224 2.08 4.6592 Anemonia sulcata 6108 Cnidaria other_Eukaryota 58.4 4.28e-4   NTclustered gi|2917940701|emb|OZ237558.1| 6108 g54189 i0 100 14.6696428571429 31 0 14 0 1 31 13148705 13148675 Anemonia sulcata genome assembly, chromosome: 4 blastn 3286 58.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
26716211 26716211 PRJEB27957_P_NODE_108201_length_167_cov_1.762712_g108091_i0 PRJEB27957 108201 167 1.762712 2.94372904 Actinostola sp. cb2 3060491 Cnidaria other_Eukaryota 42.7 0.0134   NR KAK3705766.1 3060491 g108091 i0 64.3 1.0059880239521 28 10 50.3 0 166 83 457 484 KAK3705766.1 hypothetical protein QZH41_000593 [Actinostola sp. cb2023] diamond 168 42.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actinostolidae Actinostola Actinostola sp. cb2023
30349692 30349692 PRJEB27957_P_NODE_76152_length_196_cov_1.061224_g76042_i0 PRJEB27957 76152 196 1.061224 2.07999904 Paramuricea clavata 317549 Cnidaria other_Eukaryota 67.4 1.53e-11   NR CAB4044841.1 317549 g76042 i0 59.6 1.59183673469388 52 21 79.6 0 40 195 49 100 CAB4044841.1 Hypothetical predicted protein [Paramuricea clavata] diamond 312 67.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Plexauridae Paramuricea Paramuricea clavata
31992982 31992982 PRJEB27957_P_NODE_62078_length_213_cov_1.268293_g61968_i0 PRJEB27957 62078 213 1.268293 2.70146409 Stylophora pistillata 50429 Cnidaria other_Eukaryota 61.2 7.76e-9   NR PFX13441.1 50429 g61968 i0 53.2 6.11267605633803 62 27 84.5 2 34 213 413 474 PFX13441.1 putative RNA-directed DNA polymerase from transposon X-element [Stylophora pistillata] diamond 1302 61.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;