RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB65099" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB65099 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
27690693 27690693 PRJEB65099_P_NODE_5484_length_250_cov_0.881356_g5379_i0 PRJEB65099 5484 250 0.881356 2.20339 Bacteria 2 Bacteria Bacteria 144 5.49e-40   NR MBX3316661.1 2026777 g5379 i0 96.2 1.884 79 3 94.8 0 239 3 195 273 MBX3316661.1 periplasmic heavy metal sensor [Phycisphaeraceae bacterium] diamond 471 145 0.993103448275862 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
28013260 28013260 PRJEB65099_P_NODE_5765_length_248_cov_0.891429_g5660_i0 PRJEB65099 5765 248 0.891429 2.21074392 Planctomycetota bacterium 2026780 Bacteria Bacteria 117 1.05e-28   NR MBL8752114.1 2026780 g5660 i0 76.5 0.979838709677419 81 19 98 0 4 246 118 198 MBL8752114.1 hypothetical protein [Planctomycetota bacterium] diamond 243 117 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30191794 30191794 PRJEB65099_P_NODE_6052_length_246_cov_0.901734_g5947_i0 PRJEB65099 6052 246 0.901734 2.21826564 Phycisphaerales bacterium 2052180 Bacteria Bacteria 149 1.23e-42   NR MFN0010158.1 2052180 g5947 i0 95.1 0.98780487804878 81 4 98.8 0 3 245 52 132 MFN0010158.1 BtpA/SgcQ family protein [Phycisphaerales bacterium] diamond 243 149 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
31329413 31329413 PRJEB65099_P_NODE_5436_length_250_cov_0.881356_g5331_i0 PRJEB65099 5436 250 0.881356 2.20339 Gemmataceae bacterium 2052164 Bacteria Bacteria 81.3 1.08e-15   NR HVS37301.1 2052164 g5331 i0 45.1 0.984 82 45 98.4 0 3 248 581 662 HVS37301.1 C39 family peptidase [Gemmataceae bacterium] diamond 246 81.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium

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