RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA222400" 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

  • PRJNA222400 · 6 ✖

analysis 1

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
28210819 28210819 PRJNA222400_P_NODE_6206_length_180_cov_1.297710_g6173_i0 PRJNA222400 6206 180 1.29771 2.335878 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 47 5.33e-4   NR SPQ98635.1 37360 g6173 i0 41.4 2.93333333333333 58 30 96.7 1 180 7 340 393 SPQ98635.1 unnamed protein product [Plasmodiophora brassicae] diamond 528 47 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29063595 29063595 PRJNA222400_P_NODE_6588_length_175_cov_1.238095_g6555_i0 PRJNA222400 6588 175 1.238095 2.16666625 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 98.6 1.71e-24   NR SPQ97467.1 37360 g6555 i0 77.2 47.8971428571429 57 13 97.7 0 172 2 1 57 SPQ97467.1 unnamed protein product [Plasmodiophora brassicae] diamond 8382 98.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29852918 29852918 PRJNA222400_P_NODE_6011_length_183_cov_1.552239_g5978_i0 PRJNA222400 6011 183 1.552239 2.84059737 Bonamia ostreae 126728 SAR_Eukaryotes SAR_Eukaryotes 45.8 6.87e-4   NR MES1922684.1 126728 g5978 i0 43.3 0.983606557377049 60 34 98.4 0 180 1 50 109 MES1922684.1 hypothetical protein [Bonamia ostreae] diamond 180 45.8 1 Eukaryota Sar   Endomyxa Ascetosporea Haplosporida   Bonamia Bonamia ostreae
32128978 32128978 PRJNA222400_P_NODE_378_length_811_cov_2.206037_g353_i0 PRJNA222400 378 811 2.206037 17.89096007 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 139 2.23e-33   NR CEO95180.1 37360 g353 i0 31.7 0.921085080147966 249 168 91.7 2 68 811 37 284 CEO95180.1 hypothetical protein PBRA_003946 [Plasmodiophora brassicae] diamond 747 139 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32381968 32381968 PRJNA222400_P_NODE_7519_length_168_cov_0.873950_g7486_i0 PRJNA222400 7519 168 0.87395 1.468236 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 53.5 2.13e-6   NR CEP01951.1 37360 g7486 i0 78.8 2.32142857142857 33 7 58.9 0 168 70 387 419 CEP01951.1 hypothetical protein PBRA_002216 [Plasmodiophora brassicae] diamond 390 53.5 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32886401 32886401 PRJNA222400_P_NODE_9060_length_163_cov_0.912281_g9027_i0 PRJNA222400 9060 163 0.912281 1.48701803 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 72.8 5.38e-14   NR CEP02507.1 37360 g9027 i0 73.2 0.754601226993865 41 11 75.5 0 162 40 162 202 CEP02507.1 hypothetical protein PBRA_009091 [Plasmodiophora brassicae] diamond 123 72.8 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);;