RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJEB81327", tax_clade = "Sar" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 4 ✖

tax_clade 1

bioproject 1

  • PRJEB81327 · 4 ✖

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
2690095 2690095 PRJEB81327_P_NODE_5163_length_640_cov_1.557319_g4587_i0 PRJEB81327 5163 640 1.557319 9.9668416 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 231 6.07e-70   NR CEO96295.1 37360 g4587 i0 74.1 4.1625 147 38 68.9 0 572 132 330 476 CEO96295.1 hypothetical protein PBRA_004966 [Plasmodiophora brassicae] diamond 2664 231 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
24365939 24365939 PRJEB81327_P_NODE_58820_length_244_cov_1.514620_g58212_i0 PRJEB81327 58820 244 1.51462 3.6956728 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 103 1.76e-25   NR CEP02281.1 37360 g58212 i0 79.7 14.3606557377049 64 13 78.7 0 244 53 67 130 CEP02281.1 hypothetical protein PBRA_008865 [Plasmodiophora brassicae] diamond 3504 103 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31329790 31329790 PRJEB81327_P_NODE_64336_length_241_cov_1.601190_g63728_i0 PRJEB81327 64336 241 1.60119 3.8588679 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 97.4 7.429999999999998e-24   NR CEO98954.1 37360 g63728 i0 62.8 0.970954356846473 78 29 97.1 0 238 5 3 80 CEO98954.1 hypothetical protein PBRA_007068 [Plasmodiophora brassicae] diamond 234 97.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32808201 32808201 PRJEB81327_P_NODE_40800_length_260_cov_1.342246_g40192_i0 PRJEB81327 40800 260 1.342246 3.4898396 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 45.1 6.36e-4   NR CEO97978.1 37360 g40192 i0 39.1 1.07307692307692 46 28 53.1 0 45 182 12 57 CEO97978.1 hypothetical protein PBRA_006092 [Plasmodiophora brassicae] diamond 279 45.1 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);;