RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJEB50765" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJEB50765 · 8 ✖

analysis 1

  • diamond · 8 ✖

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
11597885 11597885 PRJEB50765_P_NODE_450_length_509_cov_2.093220_g427_i0 PRJEB50765 450 509 2.09322 10.6544898 Pseudomonadota bacterium 1977087 Bacteria Bacteria 234 3.66e-76   NR MEL6702562.1 1977087 g427 i0 68.2 5.54027504911591 157 50 92.5 0 7 477 1 157 MEL6702562.1 30S ribosomal protein S17 [Pseudomonadota bacterium] diamond 2820 234 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
26590058 26590058 PRJEB50765_P_NODE_1661_length_230_cov_1.393782_g1637_i0 PRJEB50765 1661 230 1.393782 3.2056986 Colwellia sp. 56799 Bacteria Bacteria 42.7 0.0318   NR MCP4989313.1 56799 g1637 i0 53.8 0.508695652173913 39 18 50.9 0 1 117 325 363 MCP4989313.1 hypothetical protein [Colwellia sp.] diamond 117 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Colwelliaceae Colwellia Colwellia sp.
27381383 27381383 PRJEB50765_P_NODE_1263_length_275_cov_1.302521_g1239_i0 PRJEB50765 1263 275 1.302521 3.58193275 Pseudomonadota bacterium 1977087 Bacteria Bacteria 144 2.9599999999999995e-42   NR MEL6702651.1 1977087 g1239 i0 75.8 0.992727272727273 91 22 99.3 0 274 2 27 117 MEL6702651.1 30S ribosomal protein S11 [Pseudomonadota bacterium] diamond 273 144 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
28517981 28517981 PRJEB50765_P_NODE_2787_length_166_cov_1.496124_g2763_i0 PRJEB50765 2787 166 1.496124 2.48356584 Candidatus Zinderia endosymbiont of Aphrophora alni 3077951 Bacteria Bacteria 90.9 8.4e-20   NR WP_339045084.1 3077951 g2763 i0 74.5 3.97590361445783 55 14 99.4 0 166 2 276 330 WP_339045084.1 elongation factor Tu [Candidatus Zinderia endosymbiont of Aphrophora alni] diamond 660 90.9 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Candidatus Zinderia Candidatus Zinderia endosymbiont of Aphrophora alni
28612648 28612648 PRJEB50765_P_NODE_2427_length_181_cov_1.354167_g2403_i0 PRJEB50765 2427 181 1.354167 2.45104227 Nitrosomonas sp. 42353 Bacteria Bacteria 84.3 3.61e-17   NR HNJ38565.1 42353 g2403 i0 68.3 0.994475138121547 60 19 99.4 0 181 2 1099 1158 HNJ38565.1 reverse transcriptase domain-containing protein [Nitrosomonas sp.] diamond 180 84.3 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Nitrosomonadaceae Nitrosomonas Nitrosomonas sp.
29464717 29464717 PRJEB50765_P_NODE_950_length_336_cov_0.899666_g926_i0 PRJEB50765 950 336 0.899666 3.02287776 Rhodocyclaceae bacterium 1898103 Bacteria Bacteria 44.3 0.0315   NR MCB1955432.1 1898103 g926 i0 43.5 0.616071428571429 69 36 60.7 3 88 291 207 273 MCB1955432.1 SWIM zinc finger family protein [Rhodocyclaceae bacterium] diamond 207 44.3 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Rhodocyclales Rhodocyclaceae   Rhodocyclaceae bacterium
29780818 29780818 PRJEB50765_P_NODE_1631_length_233_cov_1.142857_g1607_i0 PRJEB50765 1631 233 1.142857 2.66285681 Caenispirillum salinarum 859058 Bacteria Bacteria 67 1.12e-12   NR WP_009542739.1 859058 g1607 i0 66 2.02145922746781 53 18 68.2 0 216 58 15 67 WP_009542739.1 YqaE/Pmp3 family membrane protein [Caenispirillum salinarum] diamond 471 67 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodospirillales Novispirillaceae Caenispirillum Caenispirillum salinarum
31012983 31012983 PRJEB50765_P_NODE_2335_length_185_cov_1.567568_g2311_i0 PRJEB50765 2335 185 1.567568 2.9000008 Paracoccaceae bacterium 1904441 Bacteria Bacteria 73.9 1.7e-13   NR GIS52924.1 1904441 g2311 i0 95 0.648648648648649 40 2 64.9 0 120 1 1 40 GIS52924.1 MAG: chaperone protein HtpG [Paracoccaceae bacterium] diamond 120 73.9 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae   Paracoccaceae 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);;