RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1245487" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1245487 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
6728918 6728918 PRJNA1245487_P_NODE_18686_length_256_cov_1.633880_g18348_i0 PRJNA1245487 18686 256 1.63388 4.1827328 Orbicella faveolata 48498 Cnidaria other_Eukaryota 63.9 1.08e-5   NTclustered gi|1176086992|ref|XM_020758141.1| 48498 g18348 i0 86.207 6.203125 58 8 23 0 132 189 1352 1409 PREDICTED: Orbicella faveolata ATPase family AAA domain-containing protein 2-like (LOC110052023), mRNA blastn 1588 63.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Orbicella Orbicella faveolata
13804814 13804814 PRJNA1245487_P_NODE_22751_length_231_cov_4.082278_g22413_i0 PRJNA1245487 22751 231 4.082278 9.43006218 Antennella 308580 Cnidaria other_Eukaryota 117 7.22e-22   NTclustered gi|256674484|gb|FJ550388.1| 308581 g22413 i0 86.239 43.5324675324675 109 14 47 1 1 108 227 119 Antennella ansini voucher MHNG INVE32157 28S ribosomal RNA gene, partial sequence blastn 10056 117 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Halopterididae Antennella Antennella ansini
19477145 19477145 PRJNA1245487_P_NODE_15256_length_289_cov_2.143519_g14918_i0 PRJNA1245487 15256 289 2.143519 6.19476991 Acropora muricata 159855 Cnidaria other_Eukaryota 69.4 2.66e-7   NTclustered gi|2784721347|ref|XR_010872274.1| 159855 g14918 i0 77.966 6.13840830449827 118 21 40 4 2 117 1502 1616 PREDICTED: Acropora muricata large subunit ribosomal RNA (LOC136921301), rRNA blastn 1774 69.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora muricata

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