RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA635397" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA635397 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
4433609 4433609 PRJNA635397_P_NODE_37784_length_257_cov_1.250000_g37330_i0 PRJNA635397 37784 257 1.25 3.2125 root 1 Root_unresolved Root_unresolved 105 2.04e-27   NR OPE72099.1 1392 g37330 i0 68 25.4941634241245 75 24 87.5 0 32 256 17 91 OPE72099.1 hypothetical protein BEU27_30315, partial [Bacillus anthracis] diamond 6552 106 0.990566037735849 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus anthracis
28028616 28028616 PRJNA635397_P_NODE_36685_length_261_cov_1.473404_g36231_i0 PRJNA635397 36685 261 1.473404 3.84558444 Sporolactobacillus terrae 269673 Bacteria Bacteria 115 1.74e-27   NR WP_028976438.1 269673 g36231 i0 58.7 1.05747126436782 92 33 100 1 1 261 205 296 WP_028976438.1 phage tail spike protein [Sporolactobacillus terrae] diamond 276 115 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Sporolactobacillaceae Sporolactobacillus Sporolactobacillus terrae
28861797 28861797 PRJNA635397_P_NODE_45468_length_243_cov_1.623529_g45014_i0 PRJNA635397 45468 243 1.623529 3.94517547 root 1 Root_unresolved Root_unresolved 78.6 3.35e-15   NR WP_184245080.1 74386 g45014 i0 55.2 3.32098765432099 67 30 82.7 0 3 203 222 288 WP_184245080.1 ROK family protein [Gracilibacillus halotolerans] diamond 807 78.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Gracilibacillus Gracilibacillus halotolerans
29165403 29165403 PRJNA635397_P_NODE_23289_length_332_cov_1.243243_g22835_i0 PRJNA635397 23289 332 1.243243 4.12756676 Sporolactobacillus sp. CQH2 1958931 Bacteria Bacteria 168 1.25e-48   NR WP_274400362.1 3023512 g22835 i0 76.4 1.9789156626506 110 26 99.4 0 1 330 72 181 WP_274400362.1 phage portal protein [Sporolactobacillus sp. CQH2019] diamond 657 168 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Sporolactobacillaceae Sporolactobacillus Sporolactobacillus sp. CQH2019
29196870 29196870 PRJNA635397_P_NODE_38889_length_253_cov_1.372222_g38435_i0 PRJNA635397 38889 253 1.372222 3.47172166 Clostridium mediterraneense 1805472 Bacteria Bacteria 42.7 0.0185   NR WP_066870790.1 1805472 g38435 i0 43.2 0.438735177865613 37 21 43.9 0 182 72 60 96 WP_066870790.1 EamA family transporter [Clostridium mediterraneense] diamond 111 42.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium mediterraneense
29303921 29303921 PRJNA635397_P_NODE_40289_length_251_cov_0.865169_g39835_i0 PRJNA635397 40289 251 0.865169 2.17157419 Oikeobacillus 3063783 Bacteria Bacteria 95.9 6.560000000000001e-21   NR WP_307258455.1 1325931 g39835 i0 56.6 5.89243027888446 83 36 99.2 0 249 1 36 118 WP_307258455.1 adenosylcobinamide amidohydrolase [Oikeobacillus pervagus] diamond 1479 95.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Oikeobacillus Oikeobacillus pervagus
29606818 29606818 PRJNA635397_P_NODE_35790_length_264_cov_2.560209_g35336_i0 PRJNA635397 35790 264 2.560209 6.75895176 Candidatus Equicaccousia limihippi 3083095 Bacteria Bacteria 44.7 0.0104   NR MBQ0110736.1 3083095 g35336 i0 38.9 1.21590909090909 54 32 61.4 1 231 70 85 137 MBQ0110736.1 valine--tRNA ligase [Candidatus Equicaccousia limihippi] diamond 321 44.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Acutalibacteraceae Candidatus Equicaccousia Candidatus Equicaccousia limihippi
29745737 29745737 PRJNA635397_P_NODE_43490_length_246_cov_0.901734_g43036_i0 PRJNA635397 43490 246 0.901734 2.21826564 Clostridia 186801 Bacteria Bacteria 47.8 6.52e-4   NR WP_118589447.1 1730 g43036 i0 36.4 3.40243902439024 66 33 80.5 2 198 1 189 245 WP_118589447.1 MULTISPECIES: S41 family peptidase [Eubacterium] diamond 837 48.1 0.993762993762994 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae Eubacterium  
29796494 29796494 PRJNA635397_P_NODE_48331_length_212_cov_4.791367_g47877_i0 PRJNA635397 48331 212 4.791367 10.15769804 Bacillota bacterium 1879010 Bacteria Bacteria 42 0.0449   NR MBQ3199384.1 1879010 g47877 i0 40 0.778301886792453 55 32 76.4 1 9 170 191 245 MBQ3199384.1 homoserine O-succinyltransferase [Bacillota bacterium] diamond 165 42 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
29828123 29828123 PRJNA635397_P_NODE_46451_length_242_cov_0.923077_g45997_i0 PRJNA635397 46451 242 0.923077 2.23384634 Rummeliibacillus sp. 1978528 Bacteria Bacteria 111 1.24e-26   NR HWI49885.1 1978528 g45997 i0 76.6 0.793388429752066 64 15 79.3 0 51 242 258 321 HWI49885.1 hypothetical protein [Rummeliibacillus sp.] diamond 192 111 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Caryophanaceae Rummeliibacillus Rummeliibacillus sp.
30630432 30630432 PRJNA635397_P_NODE_23553_length_330_cov_1.206226_g23099_i0 PRJNA635397 23553 330 1.206226 3.9805458 Bacteria 2 Bacteria Bacteria 47.8 0.00181   NR WP_156233536.1 1353 g23099 i0 42.9 2.34545454545455 49 27 43.6 1 1 144 694 742 WP_156233536.1 peptidase domain-containing ABC transporter [Enterococcus gallinarum] diamond 774 48.1 0.993762993762994 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus gallinarum
31313257 31313257 PRJNA635397_P_NODE_3775_length_1017_cov_5.109110_g3440_i0 PRJNA635397 3775 1017 5.10911 51.9596487 Bacillus sp. AFS 2033496 Bacteria Bacteria 47.8 0.00657   NR WP_098933869.1 2033496 g3440 i0 50 0.123893805309735 42 20 12.1 1 765 887 26 67 WP_098933869.1 hypothetical protein [Bacillus sp. AFS031507] diamond 126 47.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. AFS031507
31503234 31503234 PRJNA635397_P_NODE_46056_length_243_cov_0.864706_g45602_i0 PRJNA635397 46056 243 0.864706 2.10123558 Faecalibacterium prausnitzii 853 Bacteria Bacteria 41.6 0.0133   NR WP_238057239.1 853 g45602 i0 37.9 1.4320987654321 58 34 69.1 1 26 193 5 62 WP_238057239.1 hypothetical protein, partial [Faecalibacterium prausnitzii] diamond 348 41.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Faecalibacterium Faecalibacterium prausnitzii
31629622 31629622 PRJNA635397_P_NODE_34676_length_269_cov_1.188776_g34222_i0 PRJNA635397 34676 269 1.188776 3.19780744 Lederbergia citri 2833580 Bacteria Bacteria 128 2.17e-34   NR WP_213124561.1 2833580 g34222 i0 68.2 1.95167286245353 88 28 98.1 0 267 4 6 93 WP_213124561.1 hypothetical protein [Lederbergia citri] diamond 525 128 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Lederbergia Lederbergia citri
32325970 32325970 PRJNA635397_P_NODE_39599_length_252_cov_0.865922_g39145_i0 PRJNA635397 39599 252 0.865922 2.18212344 Priestia filamentosa 1402861 Bacteria Bacteria 147 4.9e-39   NR WP_048896740.1 1402861 g39145 i0 86.7 0.988095238095238 83 11 98.8 0 250 2 630 712 WP_048896740.1 PHP domain-containing protein [Priestia filamentosa] diamond 249 147 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Priestia Priestia filamentosa
32483925 32483925 PRJNA635397_P_NODE_38579_length_254_cov_1.519337_g38125_i0 PRJNA635397 38579 254 1.519337 3.85911598 Candidatus Merdisoma merdipullorum 2840866 Bacteria Bacteria 169 7.21e-49   NR HIT66949.1 2840866 g38125 i0 98.8 0.992125984251969 84 1 99.2 0 254 3 36 119 HIT66949.1 pyridoxal phosphate-dependent aminotransferase [Candidatus Merdisoma merdipullorum] diamond 252 169 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Candidatus Merdisoma Candidatus Merdisoma merdipullorum

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