RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA1025141" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1025141 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
3554720 3554720 PRJNA1025141_P_NODE_5423_length_346_cov_1.084249_g5362_i0 PRJNA1025141 5423 346 1.084249 3.75150154 Bacilli bacterium 1903720 Bacteria Bacteria 139 8.93e-40   NR MCQ2795680.1 1903720 g5362 i0 57.5 0.979768786127168 113 48 98 0 344 6 10 122 MCQ2795680.1 hypothetical protein [Bacilli bacterium] diamond 339 139 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
24388891 24388891 PRJNA1025141_P_NODE_4620_length_378_cov_1.009836_g4559_i0 PRJNA1025141 4620 378 1.009836 3.81718008 Bacillati 1783272 Bacteria Bacteria 199 2.48e-63   NR WP_120188376.1 66863 g4559 i0 75.2 21.3492063492063 125 31 99.2 0 3 377 1 125 WP_120188376.1 nucleoside-diphosphate kinase [Ammoniphilus oxalaticus] diamond 8070 199 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Ammoniphilus Ammoniphilus oxalaticus
27161138 27161138 PRJNA1025141_P_NODE_12382_length_243_cov_0.905882_g12321_i0 PRJNA1025141 12382 243 0.905882 2.20129326 Lachnospiraceae bacterium 3-1 397288 Bacteria Bacteria 42.7 0.0347   NR EOS26174.1 397288 g12321 i0 41.7 0.592592592592593 48 25 55.6 1 63 197 131 178 EOS26174.1 hypothetical protein C806_01390 [Lachnospiraceae bacterium 3-1] diamond 144 42.7 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium 3-1
27761860 27761860 PRJNA1025141_P_NODE_8984_length_258_cov_1.216216_g8923_i0 PRJNA1025141 8984 258 1.216216 3.13783728 Lactococcus paracarnosus 2749962 Bacteria Bacteria 43.1 0.0328   NR WP_243983675.1 2749962 g8923 i0 37.9 0.767441860465116 66 37 72.1 1 33 218 364 429 WP_243983675.1 YhgE/Pip domain-containing protein [Lactococcus paracarnosus] diamond 198 43.1 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Pseudolactococcus Pseudolactococcus paracarnosus
28519482 28519482 PRJNA1025141_P_NODE_1547_length_666_cov_1.569983_g1488_i0 PRJNA1025141 1547 666 1.569983 10.45608678 Eubacteriales bacterium 2831996 Bacteria Bacteria 47.8 0.023   NR MDO4270893.1 2831996 g1488 i0 26.2 2.15315315315315 145 94 63.1 6 552 133 395 531 MDO4270893.1 MMPL family transporter [Eubacteriales bacterium] diamond 1434 47.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Eubacteriales bacterium
29308611 29308611 PRJNA1025141_P_NODE_5169_length_355_cov_1.148936_g5108_i0 PRJNA1025141 5169 355 1.148936 4.0787228 Clostridia bacterium 2044939 Bacteria Bacteria 57.4 9.71e-7   NR MBP5633135.1 2044939 g5108 i0 35.8 2.91549295774648 120 58 93 6 3 332 254 364 MBP5633135.1 NADP-dependent isocitrate dehydrogenase [Clostridia bacterium] diamond 1035 57.4 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
29616256 29616256 PRJNA1025141_P_NODE_4950_length_364_cov_1.402062_g4889_i0 PRJNA1025141 4950 364 1.402062 5.10350568 Bacillati 1783272 Bacteria Bacteria 89.4 2.92e-20   NR MCI5674686.1 1935205 g4889 i0 56 7.06318681318681 84 37 69.2 0 4 255 29 112 MCI5674686.1 50S ribosomal protein L17 [Ezakiella sp.] diamond 2571 89.4 1 Bacteria   Bacillati Bacillota Tissierellia     Ezakiella Ezakiella sp.
29964041 29964041 PRJNA1025141_P_NODE_8591_length_266_cov_1.098446_g8530_i0 PRJNA1025141 8591 266 1.098446 2.92186636 FCB group 1783270 Bacteria Bacteria 91.7 3.08e-19   NR MDD3840751.1 2044939 g8530 i0 49.4 4.7593984962406 83 42 93.6 0 6 254 62 144 MDD3840751.1 neutral/alkaline non-lysosomal ceramidase N-terminal domain-containing protein [Clostridia bacterium] diamond 1266 92.4 0.992424242424242 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
29964042 29964042 PRJNA1025141_P_NODE_9511_length_251_cov_0.865169_g9450_i0 PRJNA1025141 9511 251 0.865169 2.17157419 Bacillati 1783272 Bacteria Bacteria 50.8 6e-5   NR MEE0857333.1 41978 g9450 i0 42.7 2.61752988047809 75 39 84.9 2 27 239 3157 3231 MEE0857333.1 PKD domain-containing protein [Ruminococcus sp.] diamond 657 50.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus sp.
30343635 30343635 PRJNA1025141_P_NODE_5912_length_330_cov_0.898833_g5851_i0 PRJNA1025141 5912 330 0.898833 2.9661489 Bacillati 1783272 Bacteria Bacteria 59.7 1.15e-7   NR WP_209458270.1 937251 g5851 i0 33.9 4.91818181818182 121 41 83.6 3 324 49 172 282 WP_209458270.1 SH3 domain-containing protein [Youngiibacter multivorans] diamond 1623 60.1 0.993344425956739 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Youngiibacter Youngiibacter multivorans
31393992 31393992 PRJNA1025141_P_NODE_396_length_1192_cov_1.445040_g369_i0 PRJNA1025141 396 1192 1.44504 17.2248768 Bacilli bacterium 1903720 Bacteria Bacteria 98.2 7.67e-18   NR MBR4618359.1 1903720 g369 i0 28.7 2.23489932885906 296 182 73 13 898 29 2177 2449 MBR4618359.1 hypothetical protein [Bacilli bacterium] diamond 2664 98.2 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
31457198 31457198 PRJNA1025141_P_NODE_3696_length_423_cov_1.294286_g3635_i0 PRJNA1025141 3696 423 1.294286 5.47482978 Bacillus methanolicus 1471 Bacteria Bacteria 70.9 1.62e-11   NR WP_003351243.1 1471 g3635 i0 35.8 0.971631205673759 137 74 95.7 5 2 406 133 257 WP_003351243.1 carbonic anhydrase [Bacillus methanolicus] diamond 411 70.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus methanolicus
31481153 31481153 PRJNA1025141_P_NODE_6176_length_322_cov_1.558233_g6115_i0 PRJNA1025141 6176 322 1.558233 5.01751026 root 1 Root_unresolved Root_unresolved 74.7 1.44e-14   NR MRB67511.1 1428 g6115 i0 49 7.67701863354037 100 35 93.2 2 23 322 13 96 MRB67511.1 50S ribosomal protein L29 [Bacillus thuringiensis] diamond 2472 74.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus thuringiensis

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