RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJEB2368" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJEB2368 · 20 ✖

analysis 1

  • diamond · 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
16599709 16599709 PRJEB2368_P_NODE_12434_length_207_cov_1.429412_g12115_i0 PRJEB2368 12434 207 1.429412 2.95888284 root 1 Root_unresolved Root_unresolved 139 5.55e-41   NR WP_416533767.1 573 g12115 i0 98.5 545.898550724638 68 1 98.6 0 205 2 26 93 WP_416533767.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 113001 140 0.992857142857143 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
26906617 26906617 PRJEB2368_P_NODE_8142_length_287_cov_1.720000_g7824_i0 PRJEB2368 8142 287 1.72 4.9364 Pseudomonas aeruginosa 287 Bacteria Bacteria 42.7 0.0268   NR MBW6072887.1 287 g7824 i0 79.2 0.250871080139373 24 5 25.1 0 214 285 32 55 MBW6072887.1 hypothetical protein [Pseudomonas aeruginosa] diamond 72 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
27096325 27096325 PRJEB2368_P_NODE_13982_length_171_cov_0.880597_g13663_i0 PRJEB2368 13982 171 0.880597 1.50582087 Acidocella sp. 50710 Bacteria Bacteria 41.2 0.0496   NR MDE8343359.1 50710 g13663 i0 48.8 0.754385964912281 43 20 71.9 1 48 170 366 408 MDE8343359.1 4-alpha-glucanotransferase [Acidocella sp.] diamond 129 41.2 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Acetobacterales Acidocellaceae Acidocella Acidocella sp.
27184619 27184619 PRJEB2368_P_NODE_11102_length_286_cov_1.297189_g10784_i0 PRJEB2368 11102 286 1.297189 3.70996054 Gammaproteobacteria 1236 Bacteria Bacteria 61.6 5.09e-10   NR WP_404875235.1 573 g10784 i0 100 0.524475524475524 25 0 26.2 0 1 75 66 90 WP_404875235.1 phosphoribosyltransferase, partial [Klebsiella pneumoniae] diamond 150 61.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
27349490 27349490 PRJEB2368_P_NODE_9423_length_287_cov_1.412000_g9105_i0 PRJEB2368 9423 287 1.412 4.05244 Lyticum sinuosum 1332059 Bacteria Bacteria 47 0.00183   NR WP_322498504.1 1332059 g9105 i0 36 0.898954703832753 86 19 89.9 1 28 285 97 146 WP_322498504.1 16S rRNA (cytosine(1402)-N(4))-methyltransferase RsmH [Lyticum sinuosum] diamond 258 47 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales   Lyticum Lyticum sinuosum
27696951 27696951 PRJEB2368_P_NODE_10764_length_286_cov_1.907631_g10446_i0 PRJEB2368 10764 286 1.907631 5.45582466 Pseudomonadota bacterium 1977087 Bacteria Bacteria 82 8.56e-16   NR MES2218504.1 1977087 g10446 i0 49.5 1.99300699300699 95 18 99.7 1 2 286 25 89 MES2218504.1 MFS transporter [Pseudomonadota bacterium] diamond 570 82 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
27728542 27728542 PRJEB2368_P_NODE_7824_length_287_cov_1.848000_g7506_i0 PRJEB2368 7824 287 1.848 5.30376 Candidatus Aquirickettsiella gammari 2016198 Bacteria Bacteria 52.4 2.58e-5   NR RDH40396.1 2016198 g7506 i0 100 0.261324041811847 25 0 26.1 0 287 213 216 240 RDH40396.1 MAG: hypothetical protein CFE62_003980 [Candidatus Aquirickettsiella gammari] diamond 75 52.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Legionellales Coxiellaceae Candidatus Aquirickettsiella Candidatus Aquirickettsiella gammari
27910949 27910949 PRJEB2368_P_NODE_8745_length_287_cov_1.532000_g8427_i0 PRJEB2368 8745 287 1.532 4.39684 Pantoea 53335 Bacteria Bacteria 53.9 7.55e-6   NR WP_159222802.1 472694 g8427 i0 100 0.501742160278746 24 0 25.1 0 285 214 443 466 WP_159222802.1 hypothetical protein [Pantoea brenneri] diamond 144 53.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Erwiniaceae Pantoea Pantoea brenneri
28012538 28012538 PRJEB2368_P_NODE_14425_length_165_cov_0.890625_g14106_i0 PRJEB2368 14425 165 0.890625 1.46953125 Caulobacteraceae bacterium 1978230 Bacteria Bacteria 45.1 0.00195   NR RYG15825.1 1978230 g14106 i0 45.1 1.89090909090909 51 22 92.7 1 11 163 514 558 RYG15825.1 MAG: ATP-binding cassette domain-containing protein, partial [Caulobacteraceae bacterium] diamond 312 45.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Caulobacterales Caulobacteraceae   Caulobacteraceae bacterium
28195157 28195157 PRJEB2368_P_NODE_8446_length_287_cov_1.620000_g8128_i0 PRJEB2368 8446 287 1.62 4.6494 Pseudomonadati 3379134 Bacteria Bacteria 47 1.71e-4   NR WP_163278156.1 548 g8128 i0 91.7 1.00348432055749 24 2 25.1 0 74 3 28 51 WP_163278156.1 phosphoglycerate kinase, partial [Klebsiella aerogenes] diamond 288 47 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella aerogenes
28858302 28858302 PRJEB2368_P_NODE_10488_length_287_cov_1.192000_g10170_i0 PRJEB2368 10488 287 1.192 3.42104 Bacteria 2 Bacteria Bacteria 58.9 7.68e-8   NR OGT06513.1 1798250 g10170 i0 34 2.94773519163763 94 23 98.3 1 3 284 105 159 OGT06513.1 MAG: hypothetical protein A2143_08430 [Gallionellales bacterium RBG_16_57_15] diamond 846 58.9 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales     Gallionellales bacterium RBG_16_57_15
29615865 29615865 PRJEB2368_P_NODE_9810_length_287_cov_1.356000_g9492_i0 PRJEB2368 9810 287 1.356 3.89172 Pseudomonadati 3379134 Bacteria Bacteria 47 0.00138   NR WP_372711477.1 82 g9492 i0 83.3 0.752613240418119 24 4 25.1 0 214 285 27 50 WP_372711477.1 methyltransferase [Hyphomicrobium sp.] diamond 216 47.4 0.991561181434599 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Hyphomicrobiaceae Hyphomicrobium Hyphomicrobium sp.
30216149 30216149 PRJEB2368_P_NODE_9912_length_287_cov_1.336000_g9594_i0 PRJEB2368 9912 287 1.336 3.83432 Pseudomonadati 3379134 Bacteria Bacteria 51.2 6.24e-6   NR WP_342177286.1 38313 g9594 i0 92 0.78397212543554 25 2 26.1 0 286 212 24 48 WP_342177286.1 DUF4199 domain-containing protein, partial [Shewanella algae] diamond 225 51.6 0.992248062015504 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Shewanellaceae Shewanella Shewanella algae
30469347 30469347 PRJEB2368_P_NODE_8893_length_287_cov_1.500000_g8575_i0 PRJEB2368 8893 287 1.5 4.305 root 1 Root_unresolved Root_unresolved 58.9 6.77e-8   NR NBT69645.1 1891241 g8575 i0 92 2.09059233449477 25 2 26.1 0 213 287 153 177 NBT69645.1 hypothetical protein [Betaproteobacteria bacterium] diamond 600 59.3 0.993254637436762 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria       Betaproteobacteria bacterium
30595305 30595305 PRJEB2368_P_NODE_6473_length_299_cov_2.011450_g6155_i0 PRJEB2368 6473 299 2.01145 6.0142355 Gammaproteobacteria 1236 Bacteria Bacteria 57.8 3.61e-7   NR WP_248692574.1 2842347 g6155 i0 80 1.50501672240803 30 6 30.1 0 209 298 140 169 WP_248692574.1 hypothetical protein [Pseudomonas azerbaijanoccidentalis] diamond 450 58.2 0.993127147766323 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas azerbaijanoccidentalis
31455319 31455319 PRJEB2368_P_NODE_9556_length_287_cov_1.392000_g9238_i0 PRJEB2368 9556 287 1.392 3.99504 uncultured Acinetobacter sp. 165433 Bacteria Bacteria 52 3.46e-5   NR WP_288413860.1 165433 g9238 i0 95.8 0.250871080139373 24 1 25.1 0 285 214 238 261 WP_288413860.1 LeoA/HP0731 family dynamin-like GTPase [uncultured Acinetobacter sp.] diamond 72 52 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter uncultured Acinetobacter sp.
31644875 31644875 PRJEB2368_P_NODE_8777_length_287_cov_1.524000_g8459_i0 PRJEB2368 8777 287 1.524 4.37388 unclassified Acinetobacter 196816 Bacteria Bacteria 55.1 1.72e-6   NR WP_241286447.1 196816 g8459 i0 100 0.250871080139373 24 0 25.1 0 285 214 30 53 WP_241286447.1 MULTISPECIES: hypothetical protein [unclassified Acinetobacter] diamond 72 55.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter  
31733311 31733311 PRJEB2368_P_NODE_10517_length_287_cov_1.176000_g10199_i0 PRJEB2368 10517 287 1.176 3.37512 Rickettsiaceae 775 Bacteria Bacteria 48.9 4.11e-4   NR WP_316353976.1 1346319 g10199 i0 36.4 1.8397212543554 88 44 92 1 24 287 270 345 WP_316353976.1 PleD family two-component system response regulator [Candidatus Trichorickettsia mobilis] diamond 528 48.9 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales Rickettsiaceae Candidatus Trichorickettsia Candidatus Trichorickettsia mobilis
32214531 32214531 PRJEB2368_P_NODE_7338_length_287_cov_2.172000_g7020_i0 PRJEB2368 7338 287 2.172 6.23364 Candidatus Fonsibacter lacus 2576439 Bacteria Bacteria 65.9 4.54e-10   NR NBU05781.1 2576439 g7020 i0 50.5 0.993031358885017 95 2 99.3 1 3 287 382 431 NBU05781.1 amino acid permease [Candidatus Fonsibacter lacus] diamond 285 65.9 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Candidatus Pelagibacterales   Candidatus Fonsibacter Candidatus Fonsibacter lacus
32499499 32499499 PRJEB2368_P_NODE_8339_length_287_cov_1.652000_g8021_i0 PRJEB2368 8339 287 1.652 4.74124 Moraxella sp. 479 Bacteria Bacteria 56.2 1.07e-6   NR RKW43120.1 479 g8021 i0 100 0.261324041811847 25 0 26.1 0 285 211 280 304 RKW43120.1 MAG: capsular biosynthesis protein [Moraxella sp.] diamond 75 56.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Moraxella Moraxella 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);;