RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA1016321" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1016321 · 5 ✖

analysis 1

  • diamond · 5 ✖
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
26615398 26615398 PRJNA1016321_P_NODE_24361_length_377_cov_2.220395_g24130_i0 PRJNA1016321 24361 377 2.220395 8.37088915 Scleractinia 6125 Cnidaria other_Eukaryota 183 6.749999999999998e-56   NR ABN41777.1 46748 g24130 i0 64 4.97347480106101 125 45 99.5 0 376 2 16 140 ABN41777.1 green-to-red photoconvertible GFP-like protein [Catalaphyllia jardinei] diamond 1875 183 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Caryophylliidae Catalaphyllia Catalaphyllia jardinei
27098023 27098023 PRJNA1016321_P_NODE_31922_length_320_cov_1.481781_g31691_i0 PRJNA1016321 31922 320 1.481781 4.7416992 Trachyphyllia geoffroyi 196280 Cnidaria other_Eukaryota 48.9 3.61e-5   NR 2GW4_A 196280 g31691 i0 81.5 0.253125 27 5 25.3 0 240 320 3 29 2GW4_A Chain A, Kaede [Trachyphyllia geoffroyi] diamond 81 48.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Trachyphyllia Trachyphyllia geoffroyi
28014232 28014232 PRJNA1016321_P_NODE_37045_length_292_cov_3.954338_g36814_i0 PRJNA1016321 37045 292 3.954338 11.54666696 Trachyphyllia geoffroyi 196280 Cnidaria other_Eukaryota 118 2.07e-31   NR 2GW4_B 196280 g36814 i0 67.4 0.914383561643836 89 29 91.4 0 1 267 73 161 2GW4_B Chain B, Kaede [Trachyphyllia geoffroyi] diamond 267 118 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Trachyphyllia Trachyphyllia geoffroyi
30066383 30066383 PRJNA1016321_P_NODE_57752_length_224_cov_4.344371_g57521_i0 PRJNA1016321 57752 224 4.344371 9.73139104 Trachyphyllia geoffroyi 196280 Cnidaria other_Eukaryota 59.7 7.01e-10   NR 2GW4_A 196280 g57521 i0 66.7 0.683035714285714 51 17 68.3 0 153 1 3 53 2GW4_A Chain A, Kaede [Trachyphyllia geoffroyi] diamond 153 59.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Trachyphyllia Trachyphyllia geoffroyi
31172048 31172048 PRJNA1016321_P_NODE_42075_length_271_cov_2.787879_g41844_i0 PRJNA1016321 42075 271 2.787879 7.55515209 Trachyphyllia geoffroyi 196280 Cnidaria other_Eukaryota 115 1.27e-30   NR 2GW4_B 196280 g41844 i0 75.3 0.896678966789668 81 20 89.7 0 7 249 47 127 2GW4_B Chain B, Kaede [Trachyphyllia geoffroyi] diamond 243 115 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Trachyphyllia Trachyphyllia geoffroyi

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