RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJEB6097" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJEB6097 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
2675646 2675646 PRJEB6097_S_NODE_143_length_536_cov_23544.139721_g89_i0 PRJEB6097 143 536 23544.139721 126196.58890456 Undibacterium luofuense 2828733 Bacteria Bacteria 184 4.049999999999999e-55   NR WP_329604620.1 2828733 g89 i0 94.2 0.576492537313433 103 6 57.6 0 536 228 48 150 WP_329604620.1 DUF3106 domain-containing protein [Undibacterium luofuense] diamond 309 184 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium luofuense
2675673 2675673 PRJEB6097_S_NODE_6323_length_163_cov_2.070312_g6269_i0 PRJEB6097 6323 163 2.070312 3.37460856 Undibacterium luofuense 2828733 Bacteria Bacteria 99 2.4299999999999994e-24   NR WP_212689400.1 2828733 g6269 i0 100 0.993865030674847 54 0 99.4 0 163 2 133 186 WP_212689400.1 phasin family protein [Undibacterium luofuense] diamond 162 99 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium luofuense
10328608 10328608 PRJEB6097_S_NODE_1149_length_348_cov_8.156550_g1095_i0 PRJEB6097 1149 348 8.15655 28.384794 Undibacterium luofuense 2828733 Bacteria Bacteria 198 1.57e-62   NR WP_212687423.1 2828733 g1095 i0 96.3 0.939655172413793 109 4 94 0 347 21 73 181 WP_212687423.1 ribosome recycling factor [Undibacterium luofuense] diamond 327 198 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium luofuense
12879224 12879224 PRJEB6097_S_NODE_591_length_413_cov_30513.613757_g537_i0 PRJEB6097 591 413 30513.613757 126021.22481641 Undibacterium squillarum 1131567 Bacteria Bacteria 116 9.36e-30   NR WP_189359187.1 1131567 g537 i0 95.5 0.479418886198547 66 3 47.9 0 3 200 62 127 WP_189359187.1 hypothetical protein [Undibacterium squillarum] diamond 198 116 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium squillarum
20526525 20526525 PRJEB6097_S_NODE_5557_length_200_cov_1.454545_g5503_i0 PRJEB6097 5557 200 1.454545 2.90909 Undibacterium luofuense 2828733 Bacteria Bacteria 89.7 4.55e-19   NR WP_212688280.1 2828733 g5503 i0 89.8 0.735 49 5 73.5 0 151 5 1 49 WP_212688280.1 23S rRNA (uracil(1939)-C(5))-methyltransferase RlmD [Undibacterium luofuense] diamond 147 89.7 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium luofuense
26685313 26685313 PRJEB6097_S_NODE_6161_length_168_cov_2.661654_g6107_i0 PRJEB6097 6161 168 2.661654 4.47157872 Undibacterium squillarum 1131567 Bacteria Bacteria 71.6 8.96e-13   NR WP_373295317.1 1131567 g6107 i0 100 0.785714285714286 44 0 78.6 0 168 37 82 125 WP_373295317.1 RNA polymerase sigma factor RpoD [Undibacterium squillarum] diamond 132 71.6 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium squillarum
26812144 26812144 PRJEB6097_S_NODE_6681_length_153_cov_1.016949_g6627_i0 PRJEB6097 6681 153 1.016949 1.55593197 Undibacterium luofuense 2828733 Bacteria Bacteria 62 2.88e-11   NR WP_212689901.1 2828733 g6627 i0 100 0.588235294117647 30 0 58.8 0 1 90 27 56 WP_212689901.1 MotA/TolQ/ExbB proton channel family protein, partial [Undibacterium luofuense] diamond 90 62 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium luofuense
27879699 27879699 PRJEB6097_S_NODE_6325_length_163_cov_1.765625_g6271_i0 PRJEB6097 6325 163 1.765625 2.87796875 Undibacterium 401469 Bacteria Bacteria 74.3 5.19e-14   NR WP_374519713.1 1131567 g6271 i0 91.1 2.48466257668712 45 4 82.8 0 163 29 42 86 WP_374519713.1 D-glycero-beta-D-manno-heptose-7-phosphate kinase [Undibacterium squillarum] diamond 405 74.3 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium squillarum
29086462 29086462 PRJEB6097_S_NODE_2408_length_284_cov_3.000000_g2354_i0 PRJEB6097 2408 284 3 8.52 Undibacterium luofuense 2828733 Bacteria Bacteria 140 1.88e-37   NR WP_212688285.1 2828733 g2354 i0 92.1 0.802816901408451 76 6 80.3 0 2 229 343 418 WP_212688285.1 flavodoxin-dependent (E)-4-hydroxy-3-methylbut-2-enyl-diphosphate synthase [Undibacterium luofuense] diamond 228 140 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium luofuense
31234118 31234118 PRJEB6097_S_NODE_6815_length_150_cov_1.104348_g6761_i0 PRJEB6097 6815 150 1.104348 1.656522 Undibacterium squillarum 1131567 Bacteria Bacteria 50.4 2.04e-5   NR WP_373295317.1 1131567 g6761 i0 100 0.52 26 0 52 0 73 150 57 82 WP_373295317.1 RNA polymerase sigma factor RpoD [Undibacterium squillarum] diamond 78 50.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium squillarum
31866722 31866722 PRJEB6097_S_NODE_1757_length_310_cov_6.265455_g1703_i0 PRJEB6097 1757 310 6.265455 19.4229105 Undibacterium luofuense 2828733 Bacteria Bacteria 96.3 2.9099999999999996e-23   NR WP_212688905.1 2828733 g1703 i0 98.8 0.82258064516129 85 1 82.3 0 295 41 7 91 WP_212688905.1 hypothetical protein [Undibacterium luofuense] diamond 255 96.3 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium luofuense

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