RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA799842", tax_clade = "Sar" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA799842 · 3 ✖

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
8446237 8446237 PRJNA799842_P_NODE_126367_length_260_cov_1.235294_g124794_i0 PRJNA799842 126367 260 1.235294 3.2117644 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 139 4.52e-36   NR CEO98303.1 37360 g124794 i0 80 10.8346153846154 85 17 98.1 0 260 6 124 208 CEO98303.1 hypothetical protein PBRA_006417 [Plasmodiophora brassicae] diamond 2817 139 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
8447419 8447419 PRJNA799842_P_NODE_191127_length_233_cov_2.406250_g189554_i0 PRJNA799842 191127 233 2.40625 5.6065625 Haplosporidium littoralis 1296328 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.002   NTclustered gi|605052145|gb|KJ150289.1| 1296328 g189554 i0 96.97 0.141630901287554 33 1 14 0 127 159 5154 5186 Haplosporidium littoralis small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 33 56.5 1 Eukaryota Sar   Endomyxa Ascetosporea Haplosporida Haplosporidiidae Haplosporidium Haplosporidium littoralis
16096952 16096952 PRJNA799842_P_NODE_22293_length_632_cov_2.749553_g20767_i0 PRJNA799842 22293 632 2.749553 17.37717496 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 225 1.56e-71   NR CEO98730.1 37360 g20767 i0 61.3 2.68670886075949 186 69 87.8 2 602 48 1 184 CEO98730.1 hypothetical protein PBRA_006844 [Plasmodiophora brassicae] diamond 1698 225 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);;