RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA1028258" and tax_phylum = "Balneolota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Balneolota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1028258 · 5 ✖

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
27058779 27058779 PRJNA1028258_P_NODE_54142_length_345_cov_2.057971_g53579_i0 PRJNA1028258 54142 345 2.057971 7.09999995 Pseudomonadati 3379134 Bacteria Bacteria 135 2.0599999999999998e-38   NR WP_069130337.1 1812810 g53579 i0 57.9 8.36521739130435 107 45 93 0 24 344 4 110 WP_069130337.1 RidA family protein [Rhodohalobacter halophilus] diamond 2886 135 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Rhodohalobacter Rhodohalobacter halophilus
28511493 28511493 PRJNA1028258_P_NODE_78447_length_291_cov_1.274775_g77884_i0 PRJNA1028258 78447 291 1.274775 3.70959525 Fodinibius 1397106 Bacteria Bacteria 142 2.77e-40   NR WP_265789955.1 1920655 g77884 i0 70.2 5.90721649484536 94 28 96.9 0 1 282 31 124 WP_265789955.1 NAD(P)-dependent oxidoreductase [Fodinibius salicampi] diamond 1719 143 0.993006993006993 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Fodinibius Fodinibius salicampi
31607385 31607385 PRJNA1028258_P_NODE_95696_length_265_cov_1.448980_g95133_i0 PRJNA1028258 95696 265 1.44898 3.839797 Pseudomonadati 3379134 Bacteria Bacteria 83.6 1.84e-16   NR MCC5904689.1 2053516 g95133 i0 51.7 5.90943396226415 87 42 98.5 0 263 3 374 460 MCC5904689.1 Glu/Leu/Phe/Val dehydrogenase [Balneolaceae bacterium] diamond 1566 83.6 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae bacterium
31892029 31892029 PRJNA1028258_P_NODE_111257_length_251_cov_1.642857_g110694_i0 PRJNA1028258 111257 251 1.642857 4.12357107 Gracilimonas 649462 Bacteria Bacteria 113 2.14e-27   NR WP_290963675.1 649462 g110694 i0 69.5 5.77290836653386 82 25 98 0 4 249 47 128 WP_290963675.1 MULTISPECIES: acetyl-CoA C-acyltransferase [Gracilimonas] diamond 1449 114 0.991228070175439 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Gracilimonas  
32619463 32619463 PRJNA1028258_P_NODE_137540_length_234_cov_0.860606_g136977_i0 PRJNA1028258 137540 234 0.860606 2.01381804 Bacteria 2 Bacteria Bacteria 73.2 2.23e-14   NR HKK43881.1 2053516 g136977 i0 57.4 1.38461538461538 54 23 69.2 0 46 207 32 85 HKK43881.1 S4 domain-containing protein [Balneolaceae bacterium] diamond 324 73.2 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae 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);;