RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA1011844" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1011844 · 13 ✖

analysis 1

  • blastn · 13 ✖
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
1432254 1432254 PRJNA1011844_P_NODE_60462_length_523_cov_6.677778_g52065_i0 PRJNA1011844 60462 523 6.677778 34.92477894 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 58.4 0.001   NTclustered gi|2782864938|ref|XM_067059763.1| 252671 g52065 i0 97.059 0.0650095602294455 34 1 7 0 228 261 446 413 PREDICTED: Clytia hemisphaerica spliceosome-associated protein CWC15 homolog (LOC136803016), transcript variant X1, mRNA blastn 34 58.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
4830324 4830324 PRJNA1011844_P_NODE_80304_length_398_cov_12.126154_g71780_i0 PRJNA1011844 80304 398 12.126154 48.26209292 root 1 Root_unresolved Root_unresolved 54.7 0.011   NTclustered gi|2812171479|ref|XM_068898505.1| 246305 g71780 i0 100 1.92964824120603 29 0 7 0 145 173 808 780 PREDICTED: Montipora capricornis uncharacterized protein (LOC138052127), mRNA blastn 768 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Montipora Montipora capricornis
6534451 6534451 PRJNA1011844_P_NODE_151146_length_247_cov_3.339080_g142567_i0 PRJNA1011844 151146 247 3.33908 8.2475276 Anemonia sulcata 6108 Cnidaria other_Eukaryota 56.5 0.002   NTclustered gi|2917940756|emb|OZ237571.1| 6108 g142567 i0 89.362 0.919028340080972 47 2 18 2 173 216 1918365 1918411 Anemonia sulcata genome assembly, chromosome: 17 blastn 227 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
11636465 11636465 PRJNA1011844_P_NODE_91890_length_352_cov_4.910394_g83331_i0 PRJNA1011844 91890 352 4.910394 17.28458688 Anemonia sulcata 6108 Cnidaria other_Eukaryota 62.1 5.53e-5   NTclustered gi|2917940687|emb|OZ237555.1| 6108 g83331 i0 97.222 0.181818181818182 36 1 10 0 48 83 27155621 27155656 Anemonia sulcata genome assembly, chromosome: 1 blastn 64 62.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
12909845 12909845 PRJNA1011844_P_NODE_148051_length_249_cov_4.715909_g139472_i0 PRJNA1011844 148051 249 4.715909 11.74261341 Acropora millepora 45264 Cnidaria other_Eukaryota 60.2 1.35e-4   NTclustered gi|2114014007|ref|XM_029339357.2| 45264 g139472 i0 94.872 0.578313253012048 39 1 16 1 17 55 570 533 PREDICTED: Acropora millepora glutamic acid-rich protein-like (LOC114960873), mRNA blastn 144 60.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora
12910572 12910572 PRJNA1011844_P_NODE_33571_length_880_cov_7.838910_g26410_i0 PRJNA1011844 33571 880 7.83891 68.982408 Orbicella faveolata 48498 Cnidaria other_Eukaryota 67.6 3.17e-6   NTclustered gi|1176086936|ref|XM_020758111.1| 48498 g26410 i0 100 4.01818181818182 36 0 4 0 836 871 980 1015 PREDICTED: Orbicella faveolata probable protein phosphatase 2C 21 (LOC110051993), mRNA blastn 3536 67.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Orbicella Orbicella faveolata
14184582 14184582 PRJNA1011844_P_NODE_127852_length_272_cov_3.115578_g119274_i0 PRJNA1011844 127852 272 3.115578 8.47437216 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 52.8 0.025   NTclustered gi|2782826889|ref|XM_067060924.1| 252671 g119274 i0 100 0.102941176470588 28 0 10 0 220 247 1730 1703 PREDICTED: Clytia hemisphaerica microfibril-associated glycoprotein 4-like (LOC136804219), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
14185678 14185678 PRJNA1011844_P_NODE_39552_length_770_cov_11.509326_g31810_i0 PRJNA1011844 39552 770 11.509326 88.6218102 Nematostella vectensis 45351 Cnidaria other_Eukaryota 60.2 4.62e-4   NTclustered gi|2257875693|ref|XM_048727360.1| 45351 g31810 i0 90.909 0.402597402597403 44 4 6 0 608 651 1572 1529 PREDICTED: Nematostella vectensis neural Wiskott-Aldrich syndrome protein (LOC116601421), transcript variant X2, mRNA blastn 310 60.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis
17580090 17580090 PRJNA1011844_P_NODE_67314_length_471_cov_2.253769_g58875_i0 PRJNA1011844 67314 471 2.253769 10.61525199 Opisthokonta 33154 Cnidaria other_Eukaryota 54.7 0.013   NTclustered gi|2917940720|emb|OZ237562.1| 6108 g58875 i0 83.607 3.82802547770701 61 6 20 4 409 467 11872101 11872043 Anemonia sulcata genome assembly, chromosome: 8 blastn 1803 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
17580264 17580264 PRJNA1011844_P_NODE_99134_length_329_cov_6.613281_g90567_i0 PRJNA1011844 99134 329 6.613281 21.75769449 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 100 1.09e-16   NTclustered gi|2689317104|gb|PP410649.1| 44197 g90567 i0 87.5 18.0121580547112 88 10 26 1 225 311 3519 3606 Paramuricea sp. voucher RB-19-112 large subunit ribosomal RNA gene, partial sequence blastn 5926 100 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Plexauridae Paramuricea Paramuricea sp.
18853795 18853795 PRJNA1011844_P_NODE_180835_length_197_cov_3.032258_g172253_i0 PRJNA1011844 180835 197 3.032258 5.97354826 root 1 Root_unresolved Root_unresolved 69.4 1.69e-7   NTclustered gi|2917940693|emb|OZ237556.1| 6108 g172253 i0 95.455 62.238578680203 44 1 22 1 72 114 14353095 14353052 Anemonia sulcata genome assembly, chromosome: 2 blastn 12261 69.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
21403922 21403922 PRJNA1011844_P_NODE_134437_length_264_cov_1.497382_g125859_i0 PRJNA1011844 134437 264 1.497382 3.95308848 Scleractinia 6125 Cnidaria other_Eukaryota 60.2 1.44e-4   NTclustered gi|1176112959|ref|XM_020771867.1| 48498 g125859 i0 100 1.35227272727273 32 0 12 0 124 155 257 288 PREDICTED: Orbicella faveolata V-type proton ATPase 116 kDa subunit a-like (LOC110064766), mRNA blastn 357 60.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Orbicella Orbicella faveolata
21832679 21832679 PRJNA1011844_P_NODE_119758_length_284_cov_1.379147_g111181_i0 PRJNA1011844 119758 284 1.379147 3.91677748 Anemonia sulcata 6108 Cnidaria other_Eukaryota 246 1.1199999999999999e-60   NTclustered gi|2917940731|emb|OZ237564.1| 6108 g111181 i0 84.739 56.1232394366197 249 34 87 4 24 270 9456851 9456605 Anemonia sulcata genome assembly, chromosome: 10 blastn 15939 246 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);;