RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA1059246" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1059246 · 15 ✖

analysis 1

  • blastn · 15 ✖
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
2286673 2286673 PRJNA1059246_P_NODE_26302_length_433_cov_2.255556_g25677_i0 PRJNA1059246 26302 433 2.255556 9.76655748 Acropora 6127 Cnidaria other_Eukaryota 52.8 0.042   NTclustered gi|2114030162|ref|XM_029347707.2| 45264 g25677 i0 100 0.12933025404157 28 0 6 0 214 241 621 594 PREDICTED: Acropora millepora uncharacterized LOC114967640 (LOC114967640), mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora
2727419 2727419 PRJNA1059246_P_NODE_26043_length_436_cov_1.319559_g25418_i0 PRJNA1059246 26043 436 1.319559 5.75327724 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 195 6.61e-45   NTclustered gi|2518974965|ref|XM_057438315.1| 13093 g25418 i0 77.381 2.35550458715596 336 71 77 5 1 334 409 741 PREDICTED: Hydractinia symbiolongicarpus NADH-ubiquinone oxidoreductase subunit 8-like (LOC130622866), mRNA blastn 1027 195 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
4003950 4003950 PRJNA1059246_P_NODE_9084_length_803_cov_5.790411_g7630_i1 PRJNA1059246 9084 803 5.790411 46.49700033 Eunicella cavolini 317547 Cnidaria other_Eukaryota 56.5 0.006   NTclustered gi|2918369540|emb|OZ237722.1| 317547 g7630 i1 92.308 0.0485678704856787 39 3 5 0 317 355 2655701 2655663 Eunicella cavolini genome assembly, chromosome: 6 blastn 39 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
5280176 5280176 PRJNA1059246_P_NODE_67985_length_245_cov_0.895349_g67359_i0 PRJNA1059246 67985 245 0.895349 2.19360505 Nematostella vectensis 45351 Cnidaria other_Eukaryota 62.1 3.67e-5   NTclustered gi|2257888782|ref|XM_001633231.3| 45351 g67359 i0 91.111 0.183673469387755 45 4 18 0 1 45 815 859 PREDICTED: Nematostella vectensis malate dehydrogenase, cytoplasmic (LOC5512984), mRNA blastn 45 62.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis
6114662 6114662 PRJNA1059246_P_NODE_46805_length_304_cov_0.865801_g46179_i0 PRJNA1059246 46805 304 0.865801 2.63203504 root 1 Root_unresolved Root_unresolved 52.8 0.028   NTclustered gi|2917940701|emb|OZ237558.1| 6108 g46179 i0 100 0.184210526315789 28 0 9 0 84 111 820647 820620 Anemonia sulcata genome assembly, chromosome: 4 blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
10380499 10380499 PRJNA1059246_P_NODE_50509_length_288_cov_0.962791_g49883_i0 PRJNA1059246 50509 288 0.962791 2.77283808 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 230 1.1499999999999995e-55   NTclustered gi|2518994037|ref|XM_057448220.1| 13093 g49883 i0 82.759 11.59375 261 41 90 4 1 259 720 978 PREDICTED: Hydractinia symbiolongicarpus 26S proteasome regulatory subunit 7 (LOC130641421), mRNA blastn 3339 230 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
10380604 10380604 PRJNA1059246_P_NODE_59209_length_259_cov_1.569892_g58583_i0 PRJNA1059246 59209 259 1.569892 4.06602028 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 93.5 1.39e-14   NTclustered gi|2782945132|ref|XM_067077193.1| 252671 g58583 i0 75.824 1.26254826254826 182 44 70 0 61 242 1336 1155 PREDICTED: Clytia hemisphaerica dynein assembly factor with WD repeat domains 1-like (LOC136820962), mRNA blastn 327 93.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
13764932 13764932 PRJNA1059246_P_NODE_64531_length_248_cov_1.760000_g63905_i0 PRJNA1059246 64531 248 1.76 4.3648 root 1 Root_unresolved Root_unresolved 54.7 0.006   NTclustered gi|2917940720|emb|OZ237562.1| 6108 g63905 i0 96.875 0.588709677419355 32 1 13 0 5 36 10952311 10952280 Anemonia sulcata genome assembly, chromosome: 8 blastn 146 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
15039130 15039130 PRJNA1059246_P_NODE_34212_length_370_cov_1.272727_g33586_i0 PRJNA1059246 34212 370 1.272727 4.7090899 root 1 Root_unresolved Root_unresolved 60.2 2.1e-4   NTclustered gi|2917940737|emb|OZ237566.1| 6108 g33586 i0 100 4.8972972972973 32 0 10 0 111 142 2159694 2159725 Anemonia sulcata genome assembly, chromosome: 12 blastn 1812 60.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
16313803 16313803 PRJNA1059246_P_NODE_12193_length_681_cov_2.726974_g11615_i0 PRJNA1059246 12193 681 2.726974 18.57069294 Metazoa 33208 Cnidaria other_Eukaryota 58.4 0.001   NTclustered gi|2917940712|emb|OZ237560.1| 6108 g11615 i0 100 0.180616740088106 31 0 5 0 552 582 13669093 13669063 Anemonia sulcata genome assembly, chromosome: 6 blastn 123 58.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
16754028 16754028 PRJNA1059246_P_NODE_41894_length_327_cov_1.023622_g41268_i0 PRJNA1059246 41894 327 1.023622 3.34724394 Nematostella vectensis 45351 Cnidaria other_Eukaryota 65.8 3.95e-6   NTclustered gi|2257878578|ref|XM_032377826.2| 45351 g41268 i0 100 12.8837920489297 35 0 11 0 52 86 628 662 PREDICTED: Nematostella vectensis myb-like protein O (LOC116616023), mRNA blastn 4213 65.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis
18863092 18863092 PRJNA1059246_P_NODE_62815_length_250_cov_0.870056_g62189_i0 PRJNA1059246 62815 250 0.870056 2.17514 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 172 1.67e-38   NTclustered gi|2782876730|ref|XM_067062339.1| 252671 g62189 i0 80.165 54.712 242 39 95 9 3 240 613 849 PREDICTED: Clytia hemisphaerica cytoplasmic aconitate hydratase-like (LOC136805781), mRNA blastn 13678 172 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
22688211 22688211 PRJNA1059246_P_NODE_2118_length_1688_cov_3.342415_g1904_i0 PRJNA1059246 2118 1688 3.342415 56.4199652 Metazoa 33208 Cnidaria other_Eukaryota 56.5 0.013   NTclustered gi|1524882665|ref|XM_027193253.1| 46731 g1904 i0 100 0.106635071090047 30 0 2 0 1385 1414 6377 6406 PREDICTED: Pocillopora damicornis mediator of RNA polymerase II transcription subunit 12-like protein (LOC113676581), transcript variant X1, mRNA blastn 180 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Pocillopora Pocillopora damicornis
24403469 24403469 PRJNA1059246_P_NODE_8140_length_852_cov_6.006418_g7630_i0 PRJNA1059246 8140 852 6.006418 51.17468136 Eunicella cavolini 317547 Cnidaria other_Eukaryota 56.5 0.007   NTclustered gi|2918369540|emb|OZ237722.1| 317547 g7630 i0 92.308 0.123239436619718 39 3 5 0 366 404 2655701 2655663 Eunicella cavolini genome assembly, chromosome: 6 blastn 105 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
25237738 25237738 PRJNA1059246_P_NODE_3900_length_1261_cov_2.595118_g3552_i0 PRJNA1059246 3900 1261 2.595118 32.72443798 Opisthokonta 33154 Cnidaria other_Eukaryota 63.9 5.95e-5   NTclustered gi|2917940735|emb|OZ237565.1| 6108 g3552 i0 95 3.56225218080888 40 2 3 0 1177 1216 12401504 12401465 Anemonia sulcata genome assembly, chromosome: 11 blastn 4492 63.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata

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