RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA1123686" 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

  • PRJNA1123686 · 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
27006839 27006839 PRJNA1123686_S_NODE_8122_length_200_cov_20.111111_g8090_i0 PRJNA1123686 8122 200 20.111111 40.222222 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 40.4 0.0347   NR WP_252130203.1 1590 g8090 i0 58.6 0.435 29 12 43.5 0 104 190 1 29 WP_252130203.1 hypothetical protein, partial [Lactiplantibacillus plantarum] diamond 87 40.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
27943898 27943898 PRJNA1123686_S_NODE_6505_length_213_cov_48.788043_g6473_i0 PRJNA1123686 6505 213 48.788043 103.91853159 root 1 Root_unresolved Root_unresolved 59.3 2.4e-9   NR WP_252130084.1 1590 g6473 i0 81.8 27.0422535211268 33 6 46.5 0 212 114 65 97 WP_252130084.1 hypothetical protein, partial [Lactiplantibacillus plantarum] diamond 5760 59.7 0.993299832495812 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
29690899 29690899 PRJNA1123686_S_NODE_18590_length_157_cov_15.546875_g18558_i0 PRJNA1123686 18590 157 15.546875 24.40859375 Staphylococcus aureus 1280 Bacteria Bacteria 87 3.9800000000000006e-21   NR QHG77600.1 1280 g18558 i0 76.9 3.89808917197452 52 12 99.4 0 2 157 8 59 QHG77600.1 hypothetical protein EAX85_13930 [Staphylococcus aureus] diamond 612 87 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
30038652 30038652 PRJNA1123686_S_NODE_19651_length_155_cov_2.293651_g19619_i0 PRJNA1123686 19651 155 2.293651 3.55515905 Galactobacillus timonensis 2041840 Bacteria Bacteria 48.9 7.44e-5   NR WP_277018500.1 2041840 g19619 i0 100 0.406451612903226 21 0 40.6 0 1 63 562 582 WP_277018500.1 ABC transporter ATP-binding protein [Galactobacillus timonensis] diamond 63 48.9 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae Galactobacillus Galactobacillus timonensis
30164833 30164833 PRJNA1123686_S_NODE_7752_length_203_cov_13.218391_g7720_i0 PRJNA1123686 7752 203 13.218391 26.83333373 Clostridia bacterium 2044939 Bacteria Bacteria 42.4 0.0304   NR MBQ2991229.1 2044939 g7720 i0 42.6 0.694581280788177 47 27 69.5 0 7 147 252 298 MBQ2991229.1 cadmium-translocating P-type ATPase [Clostridia bacterium] diamond 141 42.4 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
30291843 30291843 PRJNA1123686_S_NODE_7612_length_204_cov_16.325714_g7580_i0 PRJNA1123686 7612 204 16.325714 33.30445656 Exiguobacterium aurantiacum 33987 Bacteria Bacteria 49.7 5.13e-6   NR WP_233005565.1 33987 g7580 i0 51.6 0.941176470588235 64 30 92.6 1 204 16 1 64 WP_233005565.1 hypothetical protein, partial [Exiguobacterium aurantiacum] diamond 192 49.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales   Exiguobacterium Exiguobacterium aurantiacum
30638847 30638847 PRJNA1123686_S_NODE_8753_length_196_cov_12.700599_g8721_i0 PRJNA1123686 8753 196 12.700599 24.89317404 Clostridium sp. CAG:44 1506 Bacteria Bacteria 42.4 0.0262   NR CDE26200.1 1262807 g8721 i0 35.7 0.857142857142857 56 36 85.7 0 12 179 192 247 CDE26200.1 putative uncharacterized protein [Clostridium sp. CAG:440] diamond 168 42.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp. CAG:440
30828502 30828502 PRJNA1123686_S_NODE_13014_length_175_cov_7.109589_g12982_i0 PRJNA1123686 13014 175 7.109589 12.44178075 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 40 0.0475   NR WP_252130024.1 1590 g12982 i0 61.8 1.16571428571429 34 13 58.3 0 67 168 27 60 WP_252130024.1 60S acidic ribosomal protein P2, partial [Lactiplantibacillus plantarum] diamond 204 40 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
31133377 31133377 PRJNA1123686_S_NODE_15855_length_165_cov_6.352941_g15823_i0 PRJNA1123686 15855 165 6.352941 10.48235265 root 1 Root_unresolved Root_unresolved 99 2.09e-25   NR WP_305021979.1 1590 g15823 i0 86.8 24.0727272727273 53 7 96.4 0 3 161 10 62 WP_305021979.1 nucleoside-diphosphate kinase, partial [Lactiplantibacillus plantarum] diamond 3972 100 0.99 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
31260143 31260143 PRJNA1123686_S_NODE_5915_length_219_cov_658.526316_g5883_i0 PRJNA1123686 5915 219 658.526316 1442.17263204 root 1 Root_unresolved Root_unresolved 42.4 0.0217   NR SJR19085.1 1496 g5883 i0 54.3 1.73972602739726 35 16 47.9 0 5 109 73 107 SJR19085.1 Uncharacterised protein [Clostridioides difficile] diamond 381 42.4 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile
31576480 31576480 PRJNA1123686_S_NODE_5916_length_219_cov_643.468421_g5884_i0 PRJNA1123686 5916 219 643.468421 1409.19584199 root 1 Root_unresolved Root_unresolved 42.4 0.0217   NR SJR19085.1 1496 g5884 i0 54.3 1.73972602739726 35 16 47.9 0 5 109 73 107 SJR19085.1 Uncharacterised protein [Clostridioides difficile] diamond 381 42.4 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile
32082466 32082466 PRJNA1123686_S_NODE_358_length_408_cov_80.775726_g328_i0 PRJNA1123686 358 408 80.775726 329.56496208 root 1 Root_unresolved Root_unresolved 84.3 2.74e-17   NR QHG80041.1 1280 g328 i0 56.5 38.0514705882353 115 50 84.6 0 406 62 73 187 QHG80041.1 30S ribosomal protein S13 [Staphylococcus aureus] diamond 15525 85.1 0.990599294947121 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
32430654 32430654 PRJNA1123686_S_NODE_6019_length_218_cov_130.063492_g5987_i0 PRJNA1123686 6019 218 130.063492 283.53841256 root 1 Root_unresolved Root_unresolved 42.7 0.0156   NR SJR19085.1 1496 g5987 i0 54.3 0.963302752293578 35 16 48.2 0 5 109 73 107 SJR19085.1 Uncharacterised protein [Clostridioides difficile] diamond 210 42.7 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile

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