RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1166865" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1166865 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
1587888 1587888 PRJNA1166865_P_NODE_56422_length_294_cov_1.393665_g56181_i0 PRJNA1166865 56422 294 1.393665 4.0973751 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 226 1.52e-54   NTclustered gi|2782892753|ref|XM_067066664.1| 252671 g56181 i0 84.581 40.0204081632653 227 35 77 0 1 227 1367 1141 PREDICTED: Clytia hemisphaerica tubulin alpha-1 chain-like (LOC136810090), mRNA blastn 11766 226 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
2864838 2864838 PRJNA1166865_P_NODE_90023_length_243_cov_1.552941_g89782_i0 PRJNA1166865 90023 243 1.552941 3.77364663 Actinia tenebrosa 6105 Cnidaria other_Eukaryota 215 2.64e-51   NTclustered gi|1778056721|ref|XM_031709773.1| 6105 g89782 i0 82.716 99.4897119341564 243 40 99 2 2 243 1832 1591 PREDICTED: Actinia tenebrosa dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit STT3A-like (LOC116300817), mRNA blastn 24176 215 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
7417506 7417506 PRJNA1166865_P_NODE_62846_length_279_cov_1.495146_g62605_i0 PRJNA1166865 62846 279 1.495146 4.17145734 Montipora 46703 Cnidaria other_Eukaryota 52.8 0.026   NTclustered gi|2812191091|ref|XM_068862192.1| 246305 g62605 i0 100 0.200716845878136 28 0 10 0 115 142 3525 3498 PREDICTED: Montipora capricornis serine/threonine-protein kinase Nek1-like (LOC138015227), mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Montipora Montipora capricornis
9241895 9241895 PRJNA1166865_P_NODE_87428_length_245_cov_0.895349_g87187_i0 PRJNA1166865 87428 245 0.895349 2.19360505 Anemonia sulcata 6108 Cnidaria other_Eukaryota 60.2 1.32e-4   NTclustered gi|2917940712|emb|OZ237560.1| 6108 g87187 i0 92.683 2.12244897959184 41 3 17 0 89 129 7482046 7482086 Anemonia sulcata genome assembly, chromosome: 6 blastn 520 60.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
10516848 10516848 PRJNA1166865_P_NODE_54629_length_299_cov_1.353982_g54388_i0 PRJNA1166865 54629 299 1.353982 4.04840618 Xenia sp. Carnegie-2017 2897299 Cnidaria other_Eukaryota 52.8 0.028   NTclustered gi|2202607359|ref|XM_046983834.1| 2897299 g54388 i0 100 0.0936454849498328 28 0 9 0 174 201 1507 1480 PREDICTED: Xenia sp. Carnegie-2017 cytosolic phospholipase A2-like (LOC124433961), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Xeniidae Xenia Xenia sp. Carnegie-2017
10516867 10516867 PRJNA1166865_P_NODE_55189_length_297_cov_2.053571_g54948_i0 PRJNA1166865 55189 297 2.053571 6.09910587 Hydra vulgaris 6087 Cnidaria other_Eukaryota 62.1 4.58e-5   NTclustered gi|2744847315|ref|XM_065791144.1| 6087 g54948 i0 91.304 0.427609427609428 46 3 15 1 53 97 631 586 PREDICTED: Hydra vulgaris dnaJ homolog subfamily B member 4 (LOC100214993), transcript variant X2, mRNA blastn 127 62.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
25265972 25265972 PRJNA1166865_P_NODE_91500_length_243_cov_0.905882_g91259_i0 PRJNA1166865 91500 243 0.905882 2.20129326 Metazoa 33208 Cnidaria other_Eukaryota 52.8 0.022   NTclustered gi|1005464812|ref|XM_015913940.1| 70779 g91259 i0 100 0.230452674897119 28 0 12 0 10 37 3312 3285 PREDICTED: Acropora digitifera uncharacterized LOC107347946 (LOC107347946), mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera

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