RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA454503" 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

  • PRJNA454503 · 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
20843666 20843666 PRJNA454503_P_NODE_11197_length_336_cov_1.621818_g10868_i0 PRJNA454503 11197 336 1.621818 5.44930848 Agalma elegans 316166 Cnidaria other_Eukaryota 137 1.2999999999999998e-38   NR AAZ83740.1 316166 g10868 i0 82.4 1.51785714285714 85 15 75.9 0 5 259 89 173 AAZ83740.1 elongation factor 1 alpha, partial [Agalma elegans] diamond 510 137 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Siphonophorae Agalmatidae Agalma Agalma elegans
26902686 26902686 PRJNA454503_P_NODE_55661_length_211_cov_0.866667_g55332_i0 PRJNA454503 55661 211 0.866667 1.82866737 Metazoa 33208 Cnidaria other_Eukaryota 110 4.81e-26   NR KAK2549642.1 6130 g55332 i0 82.9 8.95734597156398 70 12 99.5 0 210 1 543 612 KAK2549642.1 Polycystin-2 [Acropora cervicornis] diamond 1890 110 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora cervicornis
27802832 27802832 PRJNA454503_P_NODE_7804_length_402_cov_2.281525_g7475_i0 PRJNA454503 7804 402 2.281525 9.1717305 Pocillopora damicornis 46731 Cnidaria other_Eukaryota 94.4 2.13e-22   NR XP_027042795.1 46731 g7475 i0 51.8 0.619402985074627 83 40 61.9 0 319 71 1 83 XP_027042795.1 migration and invasion enhancer 1-like, partial [Pocillopora damicornis] diamond 249 94.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Pocillopora Pocillopora damicornis
30218630 30218630 PRJNA454503_P_NODE_21592_length_262_cov_2.537313_g21263_i0 PRJNA454503 21592 262 2.537313 6.64776006 Metazoa 33208 Cnidaria other_Eukaryota 67 1.34e-10   NR XP_047144239.1 6087 g21263 i0 63.4 2.32442748091603 41 15 46.9 0 140 262 418 458 XP_047144239.1 uncharacterized protein LOC124817853 [Hydra vulgaris] diamond 609 67.4 0.99406528189911 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
30644700 30644700 PRJNA454503_P_NODE_83413_length_202_cov_2.304965_g83084_i0 PRJNA454503 83413 202 2.304965 4.6560293 Desmophyllum pertusum 174260 Cnidaria other_Eukaryota 123 3.5e-31   NR KAJ7383681.1 174260 g83084 i0 82.1 3.98019801980198 67 12 99.5 0 201 1 388 454 KAJ7383681.1 Elongation factor 1-alpha 1 [Desmophyllum pertusum] diamond 804 123 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Caryophylliidae Desmophyllum Desmophyllum pertusum

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