RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA741997" and tax_phylum = "Balneolota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Balneolota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA741997 · 6 ✖

analysis 1

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
7576042 7576042 PRJNA741997_P_NODE_34106_length_372_cov_1.545151_g32986_i0 PRJNA741997 34106 372 1.545151 5.74796172 Cyclonatronum sp. 3024185 Bacteria Bacteria 165 4.439999999999999e-48   NR WP_363320519.1 3024185 g32986 i0 64.5 4 124 44 100 0 372 1 91 214 WP_363320519.1 3-hydroxybutyryl-CoA dehydrogenase [Cyclonatronum sp.] diamond 1488 165 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Cyclonatronaceae Cyclonatronum Cyclonatronum sp.
27115561 27115561 PRJNA741997_P_NODE_85622_length_243_cov_0.905882_g84502_i0 PRJNA741997 85622 243 0.905882 2.20129326 Balneolaceae bacterium 2053516 Bacteria Bacteria 61.2 1.12e-8   NR MDZ7715711.1 2053516 g84502 i0 56.9 0.62962962962963 51 22 63 0 89 241 506 556 MDZ7715711.1 bifunctional aspartate kinase/diaminopimelate decarboxylase [Balneolaceae bacterium] diamond 153 61.2 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae bacterium
27220411 27220411 PRJNA741997_P_NODE_22082_length_482_cov_1.063570_g20964_i0 PRJNA741997 22082 482 1.06357 5.1264074 Pseudomonadati 3379134 Bacteria Bacteria 149 5.62e-43   NR WP_069130337.1 1812810 g20964 i0 56.9 4.54979253112033 123 53 76.6 0 457 89 4 126 WP_069130337.1 RidA family protein [Rhodohalobacter halophilus] diamond 2193 150 0.993333333333333 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Rhodohalobacter Rhodohalobacter halophilus
27305550 27305550 PRJNA741997_P_NODE_69263_length_256_cov_1.683060_g68143_i0 PRJNA741997 69263 256 1.68306 4.3086336 Balneolaceae bacterium 2053516 Bacteria Bacteria 48.9 2.51e-4   NR MCC5914975.1 2053516 g68143 i0 35.7 2.84765625 84 53 98.4 1 3 254 100 182 MCC5914975.1 alpha/beta hydrolase [Balneolaceae bacterium] diamond 729 48.9 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae bacterium
31569785 31569785 PRJNA741997_P_NODE_82136_length_245_cov_0.953488_g81016_i0 PRJNA741997 82136 245 0.953488 2.3360456 Balneolaceae bacterium 2053516 Bacteria Bacteria 63.5 1.72e-9   NR HLR90541.1 2053516 g81016 i0 37.8 1.00408163265306 82 50 99.2 1 1 243 39 120 HLR90541.1 aminopeptidase P family protein [Balneolaceae bacterium] diamond 246 63.5 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae bacterium
32644508 32644508 PRJNA741997_P_NODE_42900_length_331_cov_1.895349_g41780_i0 PRJNA741997 42900 331 1.895349 6.27360519 Balneola sp. 2024824 Bacteria Bacteria 89 1.44e-18   NR MBO6622983.1 2024824 g41780 i0 44.7 2.06646525679758 114 58 98.8 2 4 330 6 119 MBO6622983.1 TIGR01777 family oxidoreductase [Balneola sp.] diamond 684 89 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Balneola Balneola sp.

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