RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1036688" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA1036688 · 6 ✖

analysis 1

  • diamond · 6 ✖

tax_kingdom 0

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
5272546 5272546 PRJNA1036688_P_NODE_9265_length_178_cov_1.361702_g8973_i0 PRJNA1036688 9265 178 1.361702 2.42382956 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 97.4 8.65e-22   NR SPQ94571.1 37360 g8973 i0 77.6 10.752808988764 58 13 97.8 0 174 1 221 278 SPQ94571.1 unnamed protein product [Plasmodiophora brassicae] diamond 1914 97.8 0.995910020449898 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
17585920 17585920 PRJNA1036688_P_NODE_6614_length_223_cov_0.838710_g6322_i0 PRJNA1036688 6614 223 0.83871 1.8703233 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 130 8.95e-34   NR CEO95191.1 37360 g6322 i0 87.8 1.99103139013453 74 9 99.6 0 222 1 242 315 CEO95191.1 hypothetical protein PBRA_003957 [Plasmodiophora brassicae] diamond 444 130 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28709146 28709146 PRJNA1036688_P_NODE_12287_length_150_cov_1.380531_g11995_i0 PRJNA1036688 12287 150 1.380531 2.0707965 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 86.3 6.72e-19   NR CEP01968.1 37360 g11995 i0 81.6 0.98 49 9 98 0 4 150 76 124 CEP01968.1 hypothetical protein PBRA_002233 [Plasmodiophora brassicae] diamond 147 86.3 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29088025 29088025 PRJNA1036688_P_NODE_8448_length_189_cov_0.953947_g8156_i0 PRJNA1036688 8448 189 0.953947 1.80295983 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 80.5 8.47e-16   NR CEO95191.1 37360 g8156 i0 59.7 1.96825396825397 62 25 98.4 0 188 3 413 474 CEO95191.1 hypothetical protein PBRA_003957 [Plasmodiophora brassicae] diamond 372 80.5 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29434895 29434895 PRJNA1036688_P_NODE_9550_length_175_cov_1.369565_g9258_i0 PRJNA1036688 9550 175 1.369565 2.39673875 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 89.7 3.71e-19   NR CEO95191.1 37360 g9258 i0 67.2 0.994285714285714 58 19 99.4 0 1 174 169 226 CEO95191.1 hypothetical protein PBRA_003957 [Plasmodiophora brassicae] diamond 174 89.7 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30983235 30983235 PRJNA1036688_P_NODE_4754_length_282_cov_1.575510_g4462_i0 PRJNA1036688 4754 282 1.57551 4.4429382 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0265   NR CEO99081.1 37360 g4462 i0 60 0.265957446808511 25 10 26.6 0 281 207 118 142 CEO99081.1 hypothetical protein PBRA_007195 [Plasmodiophora brassicae] diamond 75 42.7 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae

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