RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA825466" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA825466 · 4 ✖

analysis 1

  • diamond · 4 ✖

tax_clade 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
26801210 26801210 PRJNA825466_P_NODE_13161_length_268_cov_1.815385_g13060_i0 PRJNA825466 13161 268 1.815385 4.8652318 Myxococcota bacterium 2818507 Bacteria Bacteria 55.1 2.33e-6   NR MEW5847593.1 2818507 g13060 i0 37.3 0.92910447761194 83 45 92.9 3 263 15 350 425 MEW5847593.1 hypothetical protein [Myxococcota bacterium] diamond 249 55.1 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
30347979 30347979 PRJNA825466_P_NODE_14112_length_263_cov_1.415789_g14011_i0 PRJNA825466 14112 263 1.415789 3.72352507 Pseudomonadati 3379134 Bacteria Bacteria 65.1 6.28e-10   NR MBE2250638.1 1929279 g14011 i0 42.9 5.57794676806084 77 42 87.8 1 262 32 127 201 MBE2250638.1 hypothetical protein [Myxococcus sp.] diamond 1467 65.5 0.993893129770992 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Myxococcus Myxococcus sp.
30875938 30875938 PRJNA825466_P_NODE_15334_length_256_cov_1.377049_g15233_i0 PRJNA825466 15334 256 1.377049 3.52524544 Minicystis sp. 1971901 Bacteria Bacteria 65.5 2.44e-10   NR MFT3769745.1 1971901 g15233 i0 47.7 0.76171875 65 32 73.8 1 67 255 4 68 MFT3769745.1 hypothetical protein [Minicystis sp.] diamond 195 65.5 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Minicystis Minicystis sp.
31643201 31643201 PRJNA825466_P_NODE_24176_length_245_cov_0.895349_g24075_i0 PRJNA825466 24176 245 0.895349 2.19360505 Myxococcia 32015 Bacteria Bacteria 43.5 0.0208   NR MBN1609152.1 2268199 g24075 i0 54.1 1.04081632653061 37 16 45.3 1 231 121 396 431 MBN1609152.1 hypothetical protein [Polyangiaceae bacterium] diamond 255 43.5 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae 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);;