RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA1068830" and tax_phylum = "Deferribacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Deferribacterota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1068830 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
26624104 26624104 PRJNA1068830_P_NODE_73101_length_253_cov_0.866667_g72398_i0 PRJNA1068830 73101 253 0.866667 2.19266751 Mucispirillum sp. 1965235 Bacteria Bacteria 149 3.2599999999999995e-42   NR MDT3693523.1 1965235 g72398 i0 86.9 1.99209486166008 84 11 99.6 0 2 253 142 225 MDT3693523.1 biotin synthase BioB [Mucispirillum sp.] diamond 504 149 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Mucispirillaceae Mucispirillum Mucispirillum sp.
26655577 26655577 PRJNA1068830_P_NODE_73761_length_252_cov_0.871508_g73058_i0 PRJNA1068830 73761 252 0.871508 2.19620016 Mucispirillum schaedleri 248039 Bacteria Bacteria 84.3 6.37e-18   NR WP_023276168.1 248039 g73058 i0 88.9 0.535714285714286 45 5 53.6 0 136 2 135 179 WP_023276168.1 MBL fold metallo-hydrolase [Mucispirillum schaedleri] diamond 135 84.3 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Mucispirillaceae Mucispirillum Mucispirillum schaedleri
27225196 27225196 PRJNA1068830_P_NODE_72963_length_253_cov_0.866667_g72260_i0 PRJNA1068830 72963 253 0.866667 2.19266751 Mucispirillum sp. 1965235 Bacteria Bacteria 109 1.02e-25   NR MDE7314826.1 1965235 g72260 i0 68.7 0.984189723320158 83 21 98.4 1 4 252 420 497 MDE7314826.1 ankyrin repeat domain-containing protein [Mucispirillum sp.] diamond 249 109 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Mucispirillaceae Mucispirillum Mucispirillum sp.
27288569 27288569 PRJNA1068830_P_NODE_82763_length_246_cov_0.901734_g82060_i0 PRJNA1068830 82763 246 0.901734 2.21826564 Mucispirillum schaedleri 248039 Bacteria Bacteria 50.1 1.04e-4   NR WP_023275727.1 248039 g82060 i0 96 0.304878048780488 25 1 30.5 0 172 246 1 25 WP_023275727.1 RelA/SpoT family protein [Mucispirillum schaedleri] diamond 75 50.1 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Mucispirillaceae Mucispirillum Mucispirillum schaedleri
27478129 27478129 PRJNA1068830_P_NODE_72903_length_253_cov_0.866667_g72200_i0 PRJNA1068830 72903 253 0.866667 2.19266751 Mucispirillum schaedleri 248039 Bacteria Bacteria 154 9.84e-45   NR WP_023274954.1 248039 g72200 i0 91.6 0.984189723320158 83 7 98.4 0 3 251 34 116 WP_023274954.1 GTP cyclohydrolase FolE2 [Mucispirillum schaedleri] diamond 249 154 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Mucispirillaceae Mucispirillum Mucispirillum schaedleri
27762573 27762573 PRJNA1068830_P_NODE_76864_length_250_cov_0.881356_g76161_i0 PRJNA1068830 76864 250 0.881356 2.20339 Mucispirillum schaedleri 248039 Bacteria Bacteria 143 3.5299999999999995e-42   NR WP_023275958.1 248039 g76161 i0 86.8 0.912 76 10 91.2 0 3 230 39 114 WP_023275958.1 GIY-YIG nuclease family protein [Mucispirillum schaedleri] diamond 228 143 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Mucispirillaceae Mucispirillum Mucispirillum schaedleri
27880173 27880173 PRJNA1068830_P_NODE_82425_length_246_cov_0.901734_g81722_i0 PRJNA1068830 82425 246 0.901734 2.21826564 Mucispirillum 248038 Bacteria Bacteria 132 1.53e-33   NR WP_023275924.1 248039 g81722 i0 78.8 1.96341463414634 80 17 97.6 0 241 2 291 370 WP_023275924.1 zincin-like metallopeptidase domain-containing protein [Mucispirillum schaedleri] diamond 483 132 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Mucispirillaceae Mucispirillum Mucispirillum schaedleri
28520195 28520195 PRJNA1068830_P_NODE_56227_length_290_cov_1.801843_g55524_i0 PRJNA1068830 56227 290 1.801843 5.2253447 Mucispirillum sp. 1965235 Bacteria Bacteria 77.8 1.6e-14   NR MDT3693525.1 1965235 g55524 i0 95 0.827586206896552 40 2 41.4 0 122 3 1 40 MDT3693525.1 biotin--[acetyl-CoA-carboxylase] ligase [Mucispirillum sp.] diamond 240 77.8 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Mucispirillaceae Mucispirillum Mucispirillum sp.
30541253 30541253 PRJNA1068830_P_NODE_83913_length_245_cov_0.906977_g83210_i0 PRJNA1068830 83913 245 0.906977 2.22209365 Mucispirillum sp. 1965235 Bacteria Bacteria 155 2.13e-45   NR MDE7034454.1 1965235 g83210 i0 100 0.991836734693878 81 0 99.2 0 245 3 62 142 MDE7034454.1 type IVB secretion system protein IcmH/DotU [Mucispirillum sp.] diamond 243 155 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Mucispirillaceae Mucispirillum Mucispirillum sp.
31299613 31299613 PRJNA1068830_P_NODE_36415_length_372_cov_1.043478_g35712_i0 PRJNA1068830 36415 372 1.043478 3.88173816 Mucispirillum schaedleri 248039 Bacteria Bacteria 125 1.71e-32   NR WP_242347160.1 248039 g35712 i0 92.4 1 66 5 53.2 0 174 371 1 66 WP_242347160.1 hypothetical protein [Mucispirillum schaedleri] diamond 372 125 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Mucispirillaceae Mucispirillum Mucispirillum schaedleri
31363057 31363057 PRJNA1068830_P_NODE_68476_length_261_cov_1.244681_g67773_i0 PRJNA1068830 68476 261 1.244681 3.24861741 Mucispirillum sp. 1965235 Bacteria Bacteria 132 2.6799999999999993e-34   NR MCI6474951.1 1965235 g67773 i0 80.2 0.988505747126437 86 17 98.9 0 260 3 78 163 MCI6474951.1 glucosyltransferase domain-containing protein [Mucispirillum sp.] diamond 258 132 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Mucispirillaceae Mucispirillum Mucispirillum sp.
31615941 31615941 PRJNA1068830_P_NODE_54556_length_295_cov_1.463964_g53853_i0 PRJNA1068830 54556 295 1.463964 4.3186938 Mucispirillum sp. 1965235 Bacteria Bacteria 137 1.68e-35   NR MDT3694496.1 1965235 g53853 i0 76.5 0.864406779661017 85 20 86.4 0 295 41 434 518 MDT3694496.1 hypothetical protein [Mucispirillum sp.] diamond 255 137 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Mucispirillaceae Mucispirillum Mucispirillum sp.
31963832 31963832 PRJNA1068830_P_NODE_75818_length_251_cov_0.876404_g75115_i0 PRJNA1068830 75818 251 0.876404 2.19977404 Mucispirillum sp. 1965235 Bacteria Bacteria 48.1 7.87e-5   NR MDT3694518.1 1965235 g75115 i0 78.6 0.334661354581673 28 6 33.5 0 11 94 72 99 MDT3694518.1 hypothetical protein [Mucispirillum sp.] diamond 84 48.1 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Mucispirillaceae Mucispirillum Mucispirillum sp.
32217100 32217100 PRJNA1068830_P_NODE_51178_length_306_cov_1.158798_g50475_i0 PRJNA1068830 51178 306 1.158798 3.54592188 Mucispirillum sp. 1965235 Bacteria Bacteria 152 2.13e-43   NR MDE7315044.1 1965235 g50475 i0 90.7 0.843137254901961 86 8 84.3 0 48 305 1 86 MDE7315044.1 IS3 family transposase [Mucispirillum sp.] diamond 258 152 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Mucispirillaceae Mucispirillum Mucispirillum sp.
32406965 32406965 PRJNA1068830_P_NODE_72899_length_253_cov_0.866667_g72196_i0 PRJNA1068830 72899 253 0.866667 2.19266751 Mucispirillum sp. 1965235 Bacteria Bacteria 153 1.3599999999999999e-43   NR MDE7315764.1 1965235 g72196 i0 98.6 0.853754940711462 72 1 85.4 0 2 217 246 317 MDE7315764.1 hypothetical protein [Mucispirillum sp.] diamond 216 153 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Mucispirillaceae Mucispirillum Mucispirillum sp.
32627908 32627908 PRJNA1068830_P_NODE_83860_length_245_cov_0.906977_g83157_i0 PRJNA1068830 83860 245 0.906977 2.22209365 Mucispirillum sp. 1965235 Bacteria Bacteria 48.1 7.65e-5   NR MDE7314310.1 1965235 g83157 i0 52.7 0.673469387755102 55 25 66.1 1 162 1 11 65 MDE7314310.1 hypothetical protein [Mucispirillum sp.] diamond 165 48.1 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Mucispirillaceae Mucispirillum Mucispirillum sp.
32879939 32879939 PRJNA1068830_P_NODE_80880_length_247_cov_0.896552_g80177_i0 PRJNA1068830 80880 247 0.896552 2.21448344 Mucispirillum sp. 1965235 Bacteria Bacteria 58.5 5.1e-8   NR MDE7170140.1 1965235 g80177 i0 79.5 0.473684210526316 39 8 47.4 0 131 247 1 39 MDE7170140.1 IS1595 family transposase [Mucispirillum sp.] diamond 117 58.5 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Mucispirillaceae Mucispirillum Mucispirillum sp.

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