RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA526367" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA526367 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
27787723 27787723 PRJNA526367_P_NODE_66404_length_150_cov_4.613861_g66194_i0 PRJNA526367 66404 150 4.613861 6.9207915 Scleractinia 6125 Cnidaria other_Eukaryota 55.8 7.19e-8   NR 2GW4_B 196280 g66194 i0 73.8 1.68 42 11 84 0 147 22 68 109 2GW4_B Chain B, Kaede [Trachyphyllia geoffroyi] diamond 252 55.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Trachyphyllia Trachyphyllia geoffroyi
28340673 28340673 PRJNA526367_P_NODE_62426_length_155_cov_2.924528_g62216_i0 PRJNA526367 62426 155 2.924528 4.5330184 Trachyphyllia geoffroyi 196280 Cnidaria other_Eukaryota 50.1 1.8e-6   NR 2GW4_A 196280 g62216 i0 77.8 0.52258064516129 27 6 52.3 0 84 4 3 29 2GW4_A Chain A, Kaede [Trachyphyllia geoffroyi] diamond 81 50.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Trachyphyllia Trachyphyllia geoffroyi
28766297 28766297 PRJNA526367_P_NODE_41227_length_181_cov_1.287879_g41017_i0 PRJNA526367 41227 181 1.287879 2.33106099 Scleractinia 6125 Cnidaria other_Eukaryota 85.1 4.66e-19   NR 2GW4_B 196280 g41017 i0 83.3 1.59116022099448 48 8 79.6 0 31 174 80 127 2GW4_B Chain B, Kaede [Trachyphyllia geoffroyi] diamond 288 85.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Trachyphyllia Trachyphyllia geoffroyi
29004201 29004201 PRJNA526367_P_NODE_48588_length_169_cov_4.233333_g48378_i0 PRJNA526367 48588 169 4.233333 7.15433277 Trachyphyllia geoffroyi 196280 Cnidaria other_Eukaryota 85.1 3.78e-19   NR 2GW4_B 196280 g48378 i0 70.4 0.958579881656805 54 16 95.9 0 6 167 35 88 2GW4_B Chain B, Kaede [Trachyphyllia geoffroyi] diamond 162 85.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Trachyphyllia Trachyphyllia geoffroyi
29256094 29256094 PRJNA526367_P_NODE_57449_length_161_cov_3.919643_g57239_i0 PRJNA526367 57449 161 3.919643 6.31062523 Trachyphyllia geoffroyi 196280 Cnidaria other_Eukaryota 47.8 1.61e-5   NR 2GW4_A 196280 g57239 i0 77.8 0.503105590062112 27 6 50.3 0 79 159 3 29 2GW4_A Chain A, Kaede [Trachyphyllia geoffroyi] diamond 81 47.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Trachyphyllia Trachyphyllia geoffroyi
30330653 30330653 PRJNA526367_P_NODE_49892_length_167_cov_5.466102_g49682_i0 PRJNA526367 49892 167 5.466102 9.12839034 Trachyphyllia geoffroyi 196280 Cnidaria other_Eukaryota 76.6 7.73e-16   NR 2GW4_B 196280 g49682 i0 67.3 0.934131736526946 52 17 93.4 0 161 6 88 139 2GW4_B Chain B, Kaede [Trachyphyllia geoffroyi] diamond 156 76.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Trachyphyllia Trachyphyllia geoffroyi
30488151 30488151 PRJNA526367_P_NODE_37773_length_187_cov_1.847826_g37563_i0 PRJNA526367 37773 187 1.847826 3.45543462 Trachyphyllia geoffroyi 196280 Cnidaria other_Eukaryota 94.7 8.1999999999999994e-23   NR 2GW4_B 196280 g37563 i0 71.2 0.946524064171123 59 17 94.7 0 179 3 34 92 2GW4_B Chain B, Kaede [Trachyphyllia geoffroyi] diamond 177 94.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Trachyphyllia Trachyphyllia geoffroyi
31973960 31973960 PRJNA526367_P_NODE_34718_length_202_cov_4.000000_g34508_i0 PRJNA526367 34718 202 4 8.08 Trachyphyllia geoffroyi 196280 Cnidaria other_Eukaryota 108 5.32e-28   NR 2GW4_B 196280 g34508 i0 76.6 0.95049504950495 64 15 95 0 10 201 30 93 2GW4_B Chain B, Kaede [Trachyphyllia geoffroyi] diamond 192 108 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);;