RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "blastn", bioproject = "PRJNA1010780" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1010780 · 20 ✖

analysis 1

  • blastn · 20 ✖

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
2705421 2705421 PRJNA1010780_S_NODE_39703_length_208_cov_1.953757_g38414_i0 PRJNA1010780 39703 208 1.953757 4.06381456 Paenibacillus sp. P36 3342538 Bacteria Bacteria 60.2 1.09e-4   NTclustered gi|2813518016|dbj|AP038372.1| 3342538 g38414 i0 100 0.153846153846154 32 0 15 0 17 48 6323720 6323751 Paenibacillus sp. P36 DNA, complete genome blastn 32 60.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus sp. P36
3981607 3981607 PRJNA1010780_S_NODE_46044_length_186_cov_1.271523_g44755_i0 PRJNA1010780 46044 186 1.271523 2.36503278 Lactobacillus crispatus 47770 Bacteria Bacteria 305 1.11e-78   NTclustered gi|1517399434|gb|CP033426.1| 47770 g44755 i0 96.237 424.586021505376 186 7 100 0 1 186 767653 767838 Lactobacillus crispatus strain CO3MRSI1 chromosome, complete genome blastn 78973 305 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus crispatus
5258097 5258097 PRJNA1010780_S_NODE_52685_length_169_cov_1.298507_g51396_i0 PRJNA1010780 52685 169 1.298507 2.19447683 uncultured Acetobacterium sp. 217139 Bacteria Bacteria 58.4 3.03e-4   NTclustered gi|2907625634|emb|OZ223194.1| 217139 g51396 i0 97.059 0.733727810650888 34 1 20 0 136 169 1716701 1716734 MAG: uncultured Acetobacterium sp. isolate 6abcf8f7-2dc5-46ce-9e35-983ba889e1c3 genome assembly, chromosome: 4 blastn 124 58.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae Acetobacterium uncultured Acetobacterium sp.
6533336 6533336 PRJNA1010780_S_NODE_42426_length_197_cov_4.734568_g41137_i0 PRJNA1010780 42426 197 4.734568 9.32709896 Lysinibacillus fusiformis 28031 Bacteria Bacteria 54.7 0.005   NTclustered gi|1993646579|gb|CP070490.1| 28031 g41137 i0 100 0.50253807106599 29 0 15 0 134 162 599315 599287 Lysinibacillus fusiformis strain NEB1292 chromosome, complete genome blastn 99 54.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Lysinibacillus Lysinibacillus fusiformis
7379139 7379139 PRJNA1010780_S_NODE_55206_length_164_cov_1.263566_g53917_i0 PRJNA1010780 55206 164 1.263566 2.07224824 Staphylococcus 1279 Bacteria Bacteria 298 1.59e-76   NTclustered gi|2482395019|gb|CP094927.1| 1280 g53917 i0 99.39 552.701219512195 164 1 100 0 1 164 969887 970050 Staphylococcus aureus strain 13 chromosome, complete genome blastn 90643 298 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
7807616 7807616 PRJNA1010780_S_NODE_19767_length_407_cov_3.180108_g18479_i0 PRJNA1010780 19767 407 3.180108 12.94303956 Fictibacillus arsenicus 255247 Bacteria Bacteria 52.8 0.039   NTclustered gi|1049088231|gb|CP016761.1| 255247 g18479 i0 100 0.0687960687960688 28 0 7 0 220 247 7577 7604 Fictibacillus arsenicus strain G25-54, complete genome blastn 28 52.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Fictibacillaceae Fictibacillus Fictibacillus arsenicus
7807821 7807821 PRJNA1010780_S_NODE_9427_length_807_cov_10.623057_g8521_i0 PRJNA1010780 9427 807 10.623057 85.72806999 Priestia filamentosa 1402861 Bacteria Bacteria 60.2 4.84e-4   NTclustered gi|2216394118|gb|CP063142.1| 1402861 g8521 i0 86.792 0.065675340768277607 53 7 7 0 746 798 2300913 2300861 Priestia filamentosa strain GN1 chromosome blastn 53 60.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Priestia Priestia filamentosa
10358251 10358251 PRJNA1010780_S_NODE_31089_length_256_cov_4.307692_g29800_i0 PRJNA1010780 31089 256 4.307692 11.02769152 Granulicatella elegans 137732 Bacteria Bacteria 52.8 0.023   NTclustered gi|2127543886|gb|CP085953.1| 137732 g29800 i0 100 0.109375 28 0 11 0 105 132 1058688 1058715 Granulicatella elegans strain FDAARGOS_1559 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Carnobacteriaceae Granulicatella Granulicatella elegans
11204838 11204838 PRJNA1010780_S_NODE_57809_length_159_cov_1.403226_g56520_i0 PRJNA1010780 57809 159 1.403226 2.23112934 Bacteria 2 Bacteria Bacteria 211 2.05e-50   NTclustered gi|1895564784|gb|CP060271.1| 1288 g56520 i0 100 340.094339622641 114 0 72 0 1 114 840064 840177 Staphylococcus xylosus strain DMSX03 chromosome, complete genome blastn 54075 211 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus xylosus
11633757 11633757 PRJNA1010780_S_NODE_38570_length_213_cov_1.915730_g37281_i0 PRJNA1010780 38570 213 1.91573 4.0805049 Virgibacillus sp. SK37 403957 Bacteria Bacteria 52.8 0.019   NTclustered gi|664689340|gb|CP007161.1| 403957 g37281 i0 100 0.131455399061033 28 0 13 0 170 197 1376821 1376794 Virgibacillus sp. SK37, complete genome blastn 28 52.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Virgibacillus Virgibacillus sp. SK37
11633846 11633846 PRJNA1010780_S_NODE_58890_length_157_cov_1.459016_g57601_i0 PRJNA1010780 58890 157 1.459016 2.29065512 Fructobacillus americanaquae 2940302 Bacteria Bacteria 58.4 2.78e-4   NTclustered gi|2260490739|gb|CP097122.1| 2940302 g57601 i0 100 0.929936305732484 31 0 20 0 3 33 424695 424725 Fructobacillus americanaquae strain KI3_B9 chromosome, complete genome blastn 146 58.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Fructobacillus Fructobacillus americanaquae
13754965 13754965 PRJNA1010780_S_NODE_63771_length_150_cov_0.913043_g62482_i0 PRJNA1010780 63771 150 0.913043 1.3695645 Staphylococcus 1279 Bacteria Bacteria 272 8.609999999999998e-69   NTclustered gi|46653|emb|V01282.1| 1280 g62482 i0 99.333 73.7266666666667 150 1 100 0 1 150 164 313 Staphylococcus aureus plasmid pSN2 Includes an unknown gene blastn 11059 272 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
14183649 14183649 PRJNA1010780_S_NODE_10672_length_732_cov_4.922525_g9680_i0 PRJNA1010780 10672 732 4.922525 36.032883 Planococcus lenghuensis 2213202 Bacteria Bacteria 56.5 0.006   NTclustered gi|1147504338|gb|CP019640.1| 2213202 g9680 i0 100 0.040983606557377 30 0 4 0 657 686 3702210 3702181 Planococcus lenghuensis strain Y42 chromosome, complete genome blastn 30 56.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Caryophanaceae Planococcus Planococcus lenghuensis
14183822 14183822 PRJNA1010780_S_NODE_47772_length_181_cov_1.452055_g46483_i0 PRJNA1010780 47772 181 1.452055 2.62821955 Blautia schinkii 180164 Bacteria Bacteria 52.8 0.015   NTclustered gi|2921388309|gb|CP132234.1| 180164 g46483 i0 100 0.154696132596685 28 0 15 0 16 43 1667158 1667131 Blautia schinkii strain DSM 10518 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Blautia Blautia schinkii
15457742 15457742 PRJNA1010780_S_NODE_36353_length_223_cov_3.101064_g35064_i0 PRJNA1010780 36353 223 3.101064 6.91537272 Clostridium tyrobutyricum 1519 Bacteria Bacteria 52.8 0.02   NTclustered gi|1888474878|gb|CP047467.1| 1519 g35064 i0 100 0.753363228699552 28 0 13 0 31 58 912290 912263 Clostridium tyrobutyricum strain L319 chromosome, complete genome blastn 168 52.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium tyrobutyricum
16304052 16304052 PRJNA1010780_S_NODE_43633_length_193_cov_2.443038_g42344_i0 PRJNA1010780 43633 193 2.443038 4.71506334 Staphylococcus 1279 Bacteria Bacteria 52.8 0.017   NTclustered gi|1848626851|gb|CP054017.1| 1292 g42344 i0 100 0.870466321243523 28 0 15 0 25 52 453979 454006 Staphylococcus warneri strain FDAARGOS_754 chromosome, complete genome blastn 168 52.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus warneri
16732036 16732036 PRJNA1010780_S_NODE_35074_length_230_cov_2.117949_g33785_i0 PRJNA1010780 35074 230 2.117949 4.8712827 Erysipelothrix sp. HDW6B 2714929 Bacteria Bacteria 56.5 0.002   NTclustered gi|1821142185|gb|CP049860.1| 2714929 g33785 i0 100 0.130434782608696 30 0 13 0 126 155 640555 640526 Erysipelothrix sp. HDW6B chromosome, complete genome blastn 30 56.5 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae Erysipelothrix Erysipelothrix sp. HDW6B
16732099 16732099 PRJNA1010780_S_NODE_52434_length_169_cov_1.992537_g51145_i0 PRJNA1010780 52434 169 1.992537 3.36738753 Lysinibacillus fusiformis 28031 Bacteria Bacteria 52.8 0.014   NTclustered gi|1708026144|gb|CP041696.1| 28031 g51145 i0 100 0.165680473372781 28 0 17 0 124 151 3814718 3814745 Lysinibacillus fusiformis strain 1226 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Lysinibacillus Lysinibacillus fusiformis
20127980 20127980 PRJNA1010780_S_NODE_17376_length_467_cov_3.180556_g16108_i0 PRJNA1010780 17376 467 3.180556 14.85319652 Staphylococcaceae 90964 Bacteria Bacteria 52.8 0.045   NTclustered gi|1243896256|gb|CP017156.1| 1898474 g16108 i0 100 0.179871520342612 28 0 6 0 330 357 2222577 2222604 Macrococcus sp. IME1552 chromosome, complete genome blastn 84 52.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Macrococcus Macrococcus sp. IME1552
23107492 23107492 PRJNA1010780_S_NODE_52159_length_170_cov_1.503704_g50870_i0 PRJNA1010780 52159 170 1.503704 2.5562968 Paenibacillus dendritiformis 130049 Bacteria Bacteria 62.1 2.36e-5   NTclustered gi|2270634658|emb|OX216966.1| 130049 g50870 i0 92.857 1.8 42 3 25 0 29 70 1253810 1253769 Paenibacillus dendritiformis isolate ena-SAMPLE-TAB-03-06-2022-11:19:07:959-6672 genome assembly, chromosome: 1 blastn 306 62.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus dendritiformis

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