RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

33 rows where analysis = "diamond", bioproject = "PRJNA1002816" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 33 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1002816 · 33 ✖

analysis 1

  • diamond · 33 ✖

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
1000862 1000862 PRJNA1002816_P_NODE_16661_length_260_cov_3.160428_g16501_i0 PRJNA1002816 16661 260 3.160428 8.2171128 Neisseriales bacterium 2053582 Bacteria Bacteria 127 5.4600000000000004e-36   NR TXI94354.1 2053582 g16501 i0 73.7 0.876923076923077 76 20 87.7 0 228 1 7 82 TXI94354.1 MAG: translation initiation factor IF-5A [Neisseriales bacterium] diamond 228 127 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales     Neisseriales bacterium
3979206 3979206 PRJNA1002816_P_NODE_13704_length_297_cov_0.848214_g13544_i0 PRJNA1002816 13704 297 0.848214 2.51919558 Rickettsiales bacterium 2026788 Bacteria Bacteria 185 5.41e-58   NR MDD2840198.1 2026788 g13544 i0 95.6 0.909090909090909 90 4 90.9 0 295 26 72 161 MDD2840198.1 hypothetical protein [Rickettsiales bacterium] diamond 270 185 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales     Rickettsiales bacterium
5255738 5255738 PRJNA1002816_P_NODE_17165_length_254_cov_2.127072_g17005_i0 PRJNA1002816 17165 254 2.127072 5.40276288 Pseudomonadati 3379134 Bacteria Bacteria 122 9.58e-31   NR WP_005422611.1 668 g17005 i0 66.3 15.4724409448819 83 28 98 0 249 1 218 300 WP_005422611.1 decarboxylating NADP(+)-dependent phosphogluconate dehydrogenase [Aliivibrio fischeri] diamond 3930 123 0.991869918699187 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Aliivibrio Aliivibrio fischeri
18004537 18004537 PRJNA1002816_P_NODE_14455_length_287_cov_1.294393_g14295_i0 PRJNA1002816 14455 287 1.294393 3.71490791 Bacteria 2 Bacteria Bacteria 120 1.79e-30   NR WP_028864512.1 444919 g14295 i0 59.6 24.3031358885017 94 38 98.3 0 287 6 30 123 WP_028864512.1 recombinase RecA [Psychromonas aquimarina] diamond 6975 121 0.991735537190083 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Psychromonadaceae Psychromonas Psychromonas aquimarina
19278586 19278586 PRJNA1002816_P_NODE_7736_length_406_cov_1.777778_g7576_i0 PRJNA1002816 7736 406 1.777778 7.21777868 Rickettsiales bacterium 2026788 Bacteria Bacteria 182 9.11e-57   NR MDD2840319.1 2026788 g7576 i0 98.9 0.687192118226601 93 1 68.7 0 392 114 1 93 MDD2840319.1 30S ribosomal protein S9 [Rickettsiales bacterium] diamond 279 182 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales     Rickettsiales bacterium
26907863 26907863 PRJNA1002816_P_NODE_13322_length_302_cov_1.266376_g13162_i0 PRJNA1002816 13322 302 1.266376 3.82445552 Rickettsiales bacterium 2026788 Bacteria Bacteria 74.7 8.51e-15   NR MDD2840571.1 2026788 g13162 i0 77 0.735099337748344 74 14 70.5 2 301 89 4 77 MDD2840571.1 hypothetical protein [Rickettsiales bacterium] diamond 222 74.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales     Rickettsiales bacterium
26995093 26995093 PRJNA1002816_P_NODE_20402_length_242_cov_0.964497_g20242_i0 PRJNA1002816 20402 242 0.964497 2.33408274 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 43.5 0.0197   NR MDH3666509.1 1904441 g20242 i0 32.8 1.56198347107438 58 39 71.9 0 8 181 151 208 MDH3666509.1 FAD-dependent oxidoreductase [Paracoccaceae bacterium] diamond 378 43.5 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae   Paracoccaceae bacterium
27698248 27698248 PRJNA1002816_P_NODE_18624_length_248_cov_0.880000_g18464_i0 PRJNA1002816 18624 248 0.88 2.1824 Vibrio sinensis 2302434 Bacteria Bacteria 42.4 0.0482   NR WP_120031233.1 2302434 g18464 i0 38.3 0.979838709677419 81 44 96.8 3 9 248 170 245 WP_120031233.1 electron transfer flavoprotein subunit beta/FixA family protein [Vibrio sinensis] diamond 243 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio sinensis
27729820 27729820 PRJNA1002816_P_NODE_6904_length_431_cov_1.927374_g6744_i0 PRJNA1002816 6904 431 1.927374 8.30698194 Rickettsiales bacterium 2026788 Bacteria Bacteria 74.7 4.68e-14   NR MDD2840199.1 2026788 g6744 i0 29.1 0.765661252900232 110 78 76.6 0 416 87 15 124 MDD2840199.1 hypothetical protein [Rickettsiales bacterium] diamond 330 74.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales     Rickettsiales bacterium
27887212 27887212 PRJNA1002816_P_NODE_11885_length_321_cov_3.616935_g11725_i0 PRJNA1002816 11885 321 3.616935 11.61036135 Rickettsiales bacterium 2026788 Bacteria Bacteria 170 6.14e-50   NR MDD2840574.1 2026788 g11725 i0 95.8 0.897196261682243 96 2 87.9 1 40 321 41 136 MDD2840574.1 30S ribosomal protein S5 [Rickettsiales bacterium] diamond 288 170 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales     Rickettsiales bacterium
28132616 28132616 PRJNA1002816_P_NODE_17425_length_251_cov_1.544944_g17265_i0 PRJNA1002816 17425 251 1.544944 3.87780944 Pseudomonadati 3379134 Bacteria Bacteria 90.9 2.29e-21   NR NKB58716.1 1913988 g17265 i0 54.2 9.93227091633466 83 37 99.2 1 250 2 35 116 NKB58716.1 group 1 truncated hemoglobin [Alphaproteobacteria bacterium] diamond 2493 91.3 0.995618838992333 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
28424226 28424226 PRJNA1002816_P_NODE_9426_length_364_cov_3.127148_g9266_i0 PRJNA1002816 9426 364 3.127148 11.38281872 Neisseriales bacterium 2053582 Bacteria Bacteria 145 2.51e-41   NR TXI93525.1 2053582 g9266 i0 58.6 0.956043956043956 116 48 95.6 0 350 3 1 116 TXI93525.1 MAG: hypothetical protein E6Q33_03180 [Neisseriales bacterium] diamond 348 145 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales     Neisseriales bacterium
28550577 28550577 PRJNA1002816_P_NODE_18147_length_249_cov_0.875000_g17987_i0 PRJNA1002816 18147 249 0.875 2.17875 Photobacterium leiognathi 553611 Bacteria Bacteria 41.6 0.024   NR WP_238093234.1 553611 g17987 i0 33.3 0.759036144578313 63 42 75.9 0 214 26 30 92 WP_238093234.1 G5P family DNA-binding protein [Photobacterium leiognathi] diamond 189 41.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Photobacterium Photobacterium leiognathi
28582109 28582109 PRJNA1002816_P_NODE_20007_length_243_cov_1.811765_g19847_i0 PRJNA1002816 20007 243 1.811765 4.40258895 Accumulibacter sp. 2053492 Bacteria Bacteria 43.5 0.0209   NR HOL64632.1 2053492 g19847 i0 51.4 0.45679012345679 37 18 45.7 0 174 64 443 479 HOL64632.1 type VI secretion system membrane subunit TssM [Accumulibacter sp.] diamond 111 43.5 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria     Candidatus Accumulibacter Accumulibacter sp.
28613525 28613525 PRJNA1002816_P_NODE_20027_length_243_cov_1.458824_g19867_i0 PRJNA1002816 20027 243 1.458824 3.54494232 Acinetobacter colistiniresistens 280145 Bacteria Bacteria 62 6.02e-9   NR WP_111828296.1 280145 g19867 i0 50.8 0.753086419753086 61 30 75.3 0 1 183 284 344 WP_111828296.1 NAD(P)-binding domain-containing protein [Acinetobacter colistiniresistens] diamond 183 62 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter colistiniresistens
28739830 28739830 PRJNA1002816_P_NODE_16667_length_260_cov_2.251337_g16507_i0 PRJNA1002816 16667 260 2.251337 5.8534762 Candidatus Skiveiella danica 3386177 Bacteria Bacteria 40.4 0.0455   NR WP_413913154.1 3386177 g16507 i0 43.2 0.426923076923077 37 21 42.7 0 260 150 31 67 WP_413913154.1 hypothetical protein [Candidatus Skiveiella danica] diamond 111 40.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Candidatus Skiveiella Candidatus Skiveiella danica
28834514 28834514 PRJNA1002816_P_NODE_11068_length_334_cov_1.770115_g10908_i0 PRJNA1002816 11068 334 1.770115 5.9121841 Neisseriales bacterium 2053582 Bacteria Bacteria 122 3.9299999999999997e-32   NR TXI93525.1 2053582 g10908 i0 67.4 0.772455089820359 86 28 77.2 0 3 260 45 130 TXI93525.1 MAG: hypothetical protein E6Q33_03180 [Neisseriales bacterium] diamond 258 122 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales     Neisseriales bacterium
29402851 29402851 PRJNA1002816_P_NODE_15149_length_279_cov_1.233010_g14989_i0 PRJNA1002816 15149 279 1.23301 3.4400979 Rickettsiales bacterium 2026788 Bacteria Bacteria 175 3.8e-52   NR MDD2840574.1 2026788 g14989 i0 93.5 1 93 5 98.9 1 279 4 205 297 MDD2840574.1 30S ribosomal protein S5 [Rickettsiales bacterium] diamond 279 175 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales     Rickettsiales bacterium
29805782 29805782 PRJNA1002816_P_NODE_9771_length_358_cov_1.003509_g9611_i0 PRJNA1002816 9771 358 1.003509 3.59256222 root 1 Root_unresolved Root_unresolved 58.9 1.24e-7   NR WP_171518208.1 106590 g9611 i0 66.7 2.19553072625698 36 12 30.2 0 250 357 119 154 WP_171518208.1 hypothetical protein [Cupriavidus necator] diamond 786 58.9 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Cupriavidus Cupriavidus necator
29813227 29813227 PRJNA1002816_P_NODE_19371_length_245_cov_1.470930_g19211_i0 PRJNA1002816 19371 245 1.47093 3.6037785 Rubrivivax gelatinosus 28068 Bacteria Bacteria 41.6 0.0417   NR WP_043811252.1 28068 g19211 i0 42.9 0.685714285714286 56 29 66.1 2 241 80 68 122 WP_043811252.1 VOC family protein [Rubrivivax gelatinosus] diamond 168 41.6 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Sphaerotilaceae Rubrivivax Rubrivivax gelatinosus
30027148 30027148 PRJNA1002816_P_NODE_16611_length_261_cov_1.303191_g16451_i0 PRJNA1002816 16611 261 1.303191 3.40132851 Alphaproteobacteria 28211 Bacteria Bacteria 94.7 8.049999999999999e-23   NR WP_100865521.1 1211806 g16451 i0 59.7 5.3448275862069 67 27 77 0 202 2 1 67 WP_100865521.1 glycine cleavage system protein GcvH [Novosphingobium kunmingense] diamond 1395 94.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Novosphingobium Novosphingobium kunmingense
30880050 30880050 PRJNA1002816_P_NODE_20774_length_241_cov_0.916667_g20614_i0 PRJNA1002816 20774 241 0.916667 2.20916747 Pseudomonadati 3379134 Bacteria Bacteria 81.6 8.85e-18   NR MDH5545920.1 1913989 g20614 i0 62.1 18.4730290456432 66 24 82.2 1 37 234 3 67 MDH5545920.1 group 1 truncated hemoglobin [Gammaproteobacteria bacterium] diamond 4452 82.4 0.990291262135922 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
30887534 30887534 PRJNA1002816_P_NODE_2214_length_765_cov_7.030347_g2073_i0 PRJNA1002816 2214 765 7.030347 53.78215455 Enterobacter hormaechei 158836 Bacteria Bacteria 120 3.21e-30   NR WP_305765769.1 158836 g2073 i0 44.3 1.72549019607843 149 76 57.6 6 716 276 1 144 WP_305765769.1 jacalin family lectin [Enterobacter hormaechei] diamond 1320 120 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Enterobacter Enterobacter hormaechei
30911852 30911852 PRJNA1002816_P_NODE_20094_length_243_cov_0.905882_g19934_i0 PRJNA1002816 20094 243 0.905882 2.20129326 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 90.1 2.52e-20   NR RIL06121.1 1977087 g19934 i0 73.3 5.45679012345679 60 16 74.1 0 242 63 60 119 RIL06121.1 MAG: phage tail protein [Pseudomonadota bacterium] diamond 1326 90.1 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
31203026 31203026 PRJNA1002816_P_NODE_8395_length_388_cov_1.711111_g8235_i0 PRJNA1002816 8395 388 1.711111 6.63911068 Rickettsiales bacterium 2026788 Bacteria Bacteria 211 3.399999999999999e-67   NR MDD2840541.1 2026788 g8235 i0 83.3 0.974226804123711 126 21 97.4 0 379 2 1 126 MDD2840541.1 60S ribosomal protein L6 [Rickettsiales bacterium] diamond 378 211 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales     Rickettsiales bacterium
31361791 31361791 PRJNA1002816_P_NODE_8656_length_381_cov_3.415584_g8496_i0 PRJNA1002816 8656 381 3.415584 13.01337504 Rickettsiales bacterium 2026788 Bacteria Bacteria 151 6.999999999999999e-45   NR MDD2840661.1 2026788 g8496 i0 96.1 0.606299212598425 77 3 60.6 0 232 2 17 93 MDD2840661.1 40S ribosomal protein S19 [Rickettsiales bacterium] diamond 231 151 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales     Rickettsiales bacterium
31614650 31614650 PRJNA1002816_P_NODE_6996_length_428_cov_1.487324_g6836_i0 PRJNA1002816 6996 428 1.487324 6.36574672 Rickettsiales bacterium 2026788 Bacteria Bacteria 169 8.87e-52   NR MDD2840632.1 2026788 g6836 i0 84.9 0.651869158878505 93 14 65.2 0 427 149 1 93 MDD2840632.1 hypothetical protein [Rickettsiales bacterium] diamond 279 169 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales     Rickettsiales bacterium
31772752 31772752 PRJNA1002816_P_NODE_2117_length_785_cov_1.762640_g1979_i0 PRJNA1002816 2117 785 1.76264 13.836724 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 53.5 9.48e-6   NR MBP7729978.1 1913988 g1979 i0 69.2 0.149044585987261 39 12 14.9 0 2 118 22 60 MBP7729978.1 hypothetical protein [Alphaproteobacteria bacterium] diamond 117 53.5 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
31796823 31796823 PRJNA1002816_P_NODE_19677_length_244_cov_1.578947_g19517_i0 PRJNA1002816 19677 244 1.578947 3.85263068 root 1 Root_unresolved Root_unresolved 62.8 2.72e-9   NR WP_149766501.1 34006 g19517 i0 44.3 1.86885245901639 70 38 84.8 1 17 223 6 75 WP_149766501.1 NADPH:quinone oxidoreductase family protein [Paracoccus thiocyanatus] diamond 456 63.2 0.993670886075949 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Paracoccus Paracoccus thiocyanatus
32025946 32025946 PRJNA1002816_P_NODE_10798_length_339_cov_1.157895_g10638_i0 PRJNA1002816 10798 339 1.157895 3.92526405 Rickettsiales bacterium 2026788 Bacteria Bacteria 206 5.66e-65   NR MDD2840498.1 2026788 g10638 i0 95.6 1 113 5 100 0 1 339 129 241 MDD2840498.1 sodium/proton-translocating pyrophosphatase [Rickettsiales bacterium] diamond 339 206 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales     Rickettsiales bacterium
32279244 32279244 PRJNA1002816_P_NODE_18379_length_248_cov_1.760000_g18219_i0 PRJNA1002816 18379 248 1.76 4.3648 Candidatus Riesia sp. 2725488 Bacteria Bacteria 42 0.0342   NR MCB1712798.1 2725488 g18219 i0 34.2 0.883064516129032 73 46 87.1 2 219 4 27 98 MCB1712798.1 hypothetical protein [Candidatus Riesia sp.] diamond 219 42 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Riesia Candidatus Riesia sp.
32342577 32342577 PRJNA1002816_P_NODE_7839_length_403_cov_1.587879_g7679_i0 PRJNA1002816 7839 403 1.587879 6.39915237 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 48.1 0.00212   NR MBV9063220.1 1913988 g7679 i0 30.7 0.655086848635236 88 61 65.5 0 11 274 88 175 MBV9063220.1 protease modulator HflC [Alphaproteobacteria bacterium] diamond 264 48.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
32588108 32588108 PRJNA1002816_P_NODE_19119_length_246_cov_0.890173_g18959_i0 PRJNA1002816 19119 246 0.890173 2.18982558 Pseudomonadota 1224 Bacteria Bacteria 103 1.92e-24   NR WP_207405586.1 94624 g18959 i0 63 6.90243902439024 81 30 98.8 0 4 246 164 244 WP_207405586.1 ornithine cyclodeaminase family protein [Bordetella petrii] diamond 1698 104 0.990384615384615 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Alcaligenaceae Bordetella Bordetella petrii

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