RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA1103784" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1103784 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
21888941 21888941 PRJNA1103784_P_NODE_4798_length_266_cov_1.595855_g4743_i0 PRJNA1103784 4798 266 1.595855 4.2449743 Streptococcus pneumoniae 1313 Bacteria Bacteria 156 1.7899999999999995e-47   NR KAF8254224.1 1313 g4743 i0 94.3 0.992481203007519 88 5 99.2 0 264 1 15 102 KAF8254224.1 hypothetical protein BKP31_11290 [Streptococcus pneumoniae] diamond 264 156 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
26750780 26750780 PRJNA1103784_P_NODE_2161_length_362_cov_1.162630_g2106_i0 PRJNA1103784 2161 362 1.16263 4.2087206 Desulfosporosinus sp. 157907 Bacteria Bacteria 47.4 0.00311   NR MDR3540757.1 157907 g2106 i0 29.4 0.903314917127072 109 69 84.5 4 353 48 220 327 MDR3540757.1 hypothetical protein [Desulfosporosinus sp.] diamond 327 47.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Desulfitobacteriaceae Desulfosporosinus Desulfosporosinus sp.
27762926 27762926 PRJNA1103784_P_NODE_2424_length_344_cov_4.195572_g2369_i0 PRJNA1103784 2424 344 4.195572 14.43276768 Priestia flexa 86664 Bacteria Bacteria 53.5 9.15e-6   NR WP_078990296.1 86664 g2369 i0 47.4 0.497093023255814 57 26 46.2 1 314 156 1 57 WP_078990296.1 hypothetical protein [Priestia flexa] diamond 171 53.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Priestia Priestia flexa
28741463 28741463 PRJNA1103784_P_NODE_587_length_622_cov_1.675774_g533_i0 PRJNA1103784 587 622 1.675774 10.42331428 Paenibacillus hamazuiensis 2936508 Bacteria Bacteria 65.5 1.49e-8   NR WP_248928521.1 2936508 g533 i0 26.2 0.882636655948553 183 126 85.9 5 38 571 233 411 WP_248928521.1 hypothetical protein [Paenibacillus hamazuiensis] diamond 549 65.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus hamazuiensis
29246581 29246581 PRJNA1103784_P_NODE_6229_length_248_cov_0.880000_g6174_i0 PRJNA1103784 6229 248 0.88 2.1824 Kroppenstedtia eburnea 714067 Bacteria Bacteria 47.4 7.61e-4   NR WP_380134752.1 714067 g6174 i0 36 1.20967741935484 100 46 99.2 3 248 3 38 137 WP_380134752.1 glycerophosphodiester phosphodiesterase [Kroppenstedtia eburnea] diamond 300 47.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Thermoactinomycetaceae Kroppenstedtia Kroppenstedtia eburnea
29278045 29278045 PRJNA1103784_P_NODE_4309_length_276_cov_1.137931_g4254_i0 PRJNA1103784 4309 276 1.137931 3.14068956 Bacillus mycoides 1405 Bacteria Bacteria 52 1.28e-5   NR WP_235702224.1 1405 g4254 i0 39.7 2.3804347826087 73 41 79.3 1 16 234 95 164 WP_235702224.1 ankyrin repeat domain-containing protein [Bacillus mycoides] diamond 657 52 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus mycoides
29719984 29719984 PRJNA1103784_P_NODE_870_length_528_cov_2.496703_g815_i0 PRJNA1103784 870 528 2.496703 13.18259184 Faecalibacterium prausnitzii 853 Bacteria Bacteria 50.4 0.0011   NR MBS6135079.1 853 g815 i0 60 0.227272727272727 40 15 22.2 1 174 58 70 109 MBS6135079.1 two-component sensor histidine kinase [Faecalibacterium prausnitzii] diamond 120 50.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Faecalibacterium Faecalibacterium prausnitzii
30857489 30857489 PRJNA1103784_P_NODE_7974_length_235_cov_4.308642_g7919_i0 PRJNA1103784 7974 235 4.308642 10.1253087 Candidatus Desulfosporosinus infrequens 2043169 Bacteria Bacteria 42.4 0.00533   NR SPF49774.1 2043169 g7919 i0 60.7 0.357446808510638 28 11 35.7 0 142 225 31 58 SPF49774.1 exported hypothetical protein [Candidatus Desulfosporosinus infrequens] diamond 84 42.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Desulfitobacteriaceae Desulfosporosinus Candidatus Desulfosporosinus infrequens
31299992 31299992 PRJNA1103784_P_NODE_7355_length_243_cov_0.905882_g7300_i0 PRJNA1103784 7355 243 0.905882 2.20129326 Lentilactobacillus buchneri 1581 Bacteria Bacteria 43.5 0.0193   NR WP_136838392.1 1581 g7300 i0 42.9 0.604938271604938 49 25 60.5 1 152 6 220 265 WP_136838392.1 McrB family protein [Lentilactobacillus buchneri] diamond 147 43.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lentilactobacillus Lentilactobacillus buchneri

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