RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJNA929952" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 25 ✖

tax_kingdom 1

bioproject 1

  • PRJNA929952 · 25 ✖

analysis 1

  • diamond · 25 ✖

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
3460067 3460067 PRJNA929952_P_NODE_6743_length_472_cov_3.309255_g4348_i1 PRJNA929952 6743 472 3.309255 15.6196836 Neisseriales 206351 Bacteria Bacteria 100 1.0100000000000002e-21   NR WP_022653425.1 190 g4348 i1 47.6 1.29661016949153 103 44 65.5 3 345 37 264 356 WP_022653425.1 porin [Aquaspirillum serpens] diamond 612 100 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Aquaspirillaceae Aquaspirillum Aquaspirillum serpens
3460073 3460073 PRJNA929952_P_NODE_8683_length_403_cov_5.050802_g7423_i0 PRJNA929952 8683 403 5.050802 20.35473206 Ectopseudomonas mendocina 300 Bacteria Bacteria 179 1.0299999999999995e-55   NR AVO52364.1 300 g7423 i0 83.2 0.885856079404467 119 17 88.6 1 26 382 1 116 AVO52364.1 prepilin-type cleavage/methylation domain-containing protein [Ectopseudomonas mendocina] diamond 357 179 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Ectopseudomonas Ectopseudomonas mendocina
6012406 6012406 PRJNA929952_P_NODE_19325_length_221_cov_2.510417_g18031_i0 PRJNA929952 19325 221 2.510417 5.54802157 Gulbenkiania mobilis 397457 Bacteria Bacteria 97.1 4.28e-22   NR WP_132098201.1 397457 g18031 i0 57.5 1.9683257918552 73 31 99.1 0 221 3 42 114 WP_132098201.1 porin [Gulbenkiania mobilis] diamond 435 97.1 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Chromobacteriaceae Gulbenkiania Gulbenkiania mobilis
20035790 20035790 PRJNA929952_P_NODE_5416_length_535_cov_3.114625_g4348_i0 PRJNA929952 5416 535 3.114625 16.66324375 Neisseriales 206351 Bacteria Bacteria 100 1.98e-21   NR WP_022653425.1 190 g4348 i0 43.4 2.66915887850467 122 55 66.2 4 390 37 245 356 WP_022653425.1 porin [Aquaspirillum serpens] diamond 1428 101 0.99009900990099 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Aquaspirillaceae Aquaspirillum Aquaspirillum serpens
26613232 26613232 PRJNA929952_P_NODE_22681_length_172_cov_2.587413_g21387_i0 PRJNA929952 22681 172 2.587413 4.45035036 Plesiomonas shigelloides 703 Bacteria Bacteria 69.7 7.27e-13   NR WP_039046239.1 703 g21387 i0 76.2 0.732558139534884 42 10 73.3 0 45 170 4 45 WP_039046239.1 hypothetical protein [Plesiomonas shigelloides] diamond 126 69.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Plesiomonas Plesiomonas shigelloides
26771760 26771760 PRJNA929952_P_NODE_22421_length_175_cov_2.260274_g21127_i0 PRJNA929952 22421 175 2.260274 3.9554795 Aeromonas 642 Bacteria Bacteria 119 2.0299999999999997e-31   NR WP_193861175.1 642 g21127 i0 100 0.994285714285714 58 0 99.4 0 1 174 58 115 WP_193861175.1 MULTISPECIES: StbB family protein [Aeromonas] diamond 174 119 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Aeromonadaceae Aeromonas  
26803286 26803286 PRJNA929952_P_NODE_9801_length_372_cov_2.402332_g8523_i0 PRJNA929952 9801 372 2.402332 8.93667504 Aeromonas caviae 648 Bacteria Bacteria 74.3 3.4e-13   NR WP_319895134.1 648 g8523 i0 100 0.274193548387097 34 0 27.4 0 372 271 203 236 WP_319895134.1 hypothetical protein [Aeromonas caviae] diamond 102 74.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Aeromonadaceae Aeromonas Aeromonas caviae
27119486 27119486 PRJNA929952_P_NODE_14622_length_272_cov_5.074074_g13328_i0 PRJNA929952 14622 272 5.074074 13.80148128 Candidatus Methylopumilus rimovensis 2588535 Bacteria Bacteria 43.1 0.0169   NR CAH7791386.1 2588535 g13328 i0 46.3 0.992647058823529 67 34 72.8 2 247 50 32 97 CAH7791386.1 hypothetical protein REM17_00479 [Candidatus Methylopumilus rimovensis] diamond 270 43.1 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Methylophilaceae Candidatus Methylopumilus Candidatus Methylopumilus rimovensis
27341171 27341171 PRJNA929952_P_NODE_10923_length_342_cov_3.303514_g9633_i0 PRJNA929952 10923 342 3.303514 11.29801788 Aeromonas veronii 654 Bacteria Bacteria 212 3.0299999999999992e-68   NR WP_257690921.1 654 g9633 i0 100 0.894736842105263 102 0 89.5 0 342 37 59 160 WP_257690921.1 hypothetical protein [Aeromonas veronii] diamond 306 212 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Aeromonadaceae Aeromonas Aeromonas veronii
28604062 28604062 PRJNA929952_P_NODE_10007_length_366_cov_3.370920_g8725_i0 PRJNA929952 10007 366 3.37092 12.3375672 Aeromonas 642 Bacteria Bacteria 181 2.79e-56   NR WP_199416298.1 642 g8725 i0 90.8 0.89344262295082 109 5 89.3 1 366 40 42 145 WP_199416298.1 MULTISPECIES: H-NS family nucleoid-associated regulatory protein [Aeromonas] diamond 327 181 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Aeromonadaceae Aeromonas  
28730341 28730341 PRJNA929952_P_NODE_9347_length_385_cov_3.398876_g8073_i0 PRJNA929952 9347 385 3.398876 13.0856726 Aeromonas 642 Bacteria Bacteria 104 6.270000000000001e-27   NR WP_193861208.1 642 g8073 i0 100 0.405194805194805 52 0 40.5 0 196 351 1 52 WP_193861208.1 MULTISPECIES: hypothetical protein [Aeromonas] diamond 156 104 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Aeromonadaceae Aeromonas  
28761773 28761773 PRJNA929952_P_NODE_10367_length_356_cov_4.428135_g9079_i0 PRJNA929952 10367 356 4.428135 15.7641606 Aeromonas veronii 654 Bacteria Bacteria 197 5.61e-63   NR WP_193861193.1 654 g9079 i0 92.5 0.901685393258427 107 8 90.2 0 22 342 1 107 WP_193861193.1 hypothetical protein [Aeromonas veronii] diamond 321 197 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Aeromonadaceae Aeromonas Aeromonas veronii
30056415 30056415 PRJNA929952_P_NODE_19691_length_216_cov_2.235294_g18397_i0 PRJNA929952 19691 216 2.235294 4.82823504 Crenobacter caeni 2705474 Bacteria Bacteria 100 2.46e-24   NR WP_163317774.1 2705474 g18397 i0 100 0.694444444444444 50 0 69.4 0 150 1 1 50 WP_163317774.1 OmpA family protein [Crenobacter caeni] diamond 150 100 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Neisseriaceae Crenobacter Crenobacter caeni
30467608 30467608 PRJNA929952_P_NODE_13233_length_295_cov_1.815789_g11940_i0 PRJNA929952 13233 295 1.815789 5.35657755 Aeromonas veronii 654 Bacteria Bacteria 161 1.04e-47   NR WP_342401969.1 654 g11940 i0 93.9 0.833898305084746 82 5 83.4 0 48 293 3 84 WP_342401969.1 hypothetical protein [Aeromonas veronii] diamond 246 161 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Aeromonadaceae Aeromonas Aeromonas veronii
30751726 30751726 PRJNA929952_P_NODE_20474_length_202_cov_18.410405_g19180_i0 PRJNA929952 20474 202 18.410405 37.1890181 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 46.6 1.99e-4   NR WP_395588119.1 251699 g19180 i0 43.8 1.08415841584158 73 24 83.2 4 186 19 2 74 WP_395588119.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 219 46.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
31074724 31074724 PRJNA929952_P_NODE_24435_length_154_cov_1.576000_g23141_i0 PRJNA929952 24435 154 1.576 2.42704 Bacteria 2 Bacteria Bacteria 103 4.32e-26   NR WP_193861207.1 642 g23141 i0 100 1.94805194805195 50 0 97.4 0 152 3 102 151 WP_193861207.1 MULTISPECIES: hypothetical protein [Aeromonas] diamond 300 103 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Aeromonadaceae Aeromonas  
31359327 31359327 PRJNA929952_P_NODE_20896_length_196_cov_2.143713_g19602_i0 PRJNA929952 20896 196 2.143713 4.20167748 Aeromonas 642 Bacteria Bacteria 130 7.75e-35   NR WP_080891389.1 642 g19602 i0 92.2 2.93877551020408 64 5 98 0 3 194 12 75 WP_080891389.1 MULTISPECIES: glycosyltransferase [Aeromonas] diamond 576 130 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Aeromonadaceae Aeromonas  
31605222 31605222 PRJNA929952_P_NODE_10156_length_362_cov_2.801802_g8873_i0 PRJNA929952 10156 362 2.801802 10.14252324 Aeromonas 642 Bacteria Bacteria 225 8.67e-74   NR WP_362781805.1 642 g8873 i0 100 0.994475138121547 120 0 99.4 0 1 360 11 130 WP_362781805.1 MULTISPECIES: H-NS family nucleoid-associated regulatory protein [Aeromonas] diamond 360 225 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Aeromonadaceae Aeromonas  
31636710 31636710 PRJNA929952_P_NODE_23896_length_159_cov_1.861538_g22602_i0 PRJNA929952 23896 159 1.861538 2.95984542 Aeromonas veronii 654 Bacteria Bacteria 117 9.44e-31   NR WP_236349790.1 654 g22602 i0 100 3 53 0 100 0 159 1 79 131 WP_236349790.1 hypothetical protein [Aeromonas veronii] diamond 477 117 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Aeromonadaceae Aeromonas Aeromonas veronii
31858097 31858097 PRJNA929952_P_NODE_6397_length_486_cov_9.328228_g5255_i0 PRJNA929952 6397 486 9.328228 45.33518808 Sphingomicrobium sp. 1940456 Bacteria Bacteria 45.4 0.0379   NR HVL78714.1 1940456 g5255 i0 33.3 0.666666666666667 108 57 61.1 3 78 374 53 154 HVL78714.1 FecR domain-containing protein [Sphingomicrobium sp.] diamond 324 45.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomicrobium Sphingomicrobium sp.
31953036 31953036 PRJNA929952_P_NODE_24157_length_156_cov_2.803150_g22863_i0 PRJNA929952 24157 156 2.80315 4.372914 Klebsiella pneumoniae 573 Bacteria Bacteria 48.5 8.18e-6   NR WP_416515521.1 573 g22863 i0 63.9 0.692307692307692 36 13 69.2 0 108 1 25 60 WP_416515521.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 108 48.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
31953038 31953038 PRJNA929952_P_NODE_6777_length_471_cov_2.110860_g5601_i0 PRJNA929952 6777 471 2.11086 9.9421506 Aeromonas 642 Bacteria Bacteria 140 4.68e-37   NR WP_319895168.1 642 g5601 i0 51.4 1.11464968152866 175 57 100 3 471 1 131 295 WP_319895168.1 MULTISPECIES: replication initiation protein [Aeromonas] diamond 525 140 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Aeromonadaceae Aeromonas  
32174796 32174796 PRJNA929952_P_NODE_6098_length_500_cov_7.861996_g4984_i0 PRJNA929952 6098 500 7.861996 39.30998 Aeromonas veronii 654 Bacteria Bacteria 284 6.249999999999998e-96   NR WP_199416285.1 654 g4984 i0 98.7 0.918 153 2 91.8 0 484 26 1 153 WP_199416285.1 hypothetical protein [Aeromonas veronii] diamond 459 284 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Aeromonadaceae Aeromonas Aeromonas veronii
32427786 32427786 PRJNA929952_P_NODE_14599_length_273_cov_1.799180_g13305_i0 PRJNA929952 14599 273 1.79918 4.9117614 Aeromonas caviae 648 Bacteria Bacteria 78.6 9.18e-15   NR WP_301480134.1 648 g13305 i0 97.4 0.417582417582418 38 1 41.8 0 1 114 305 342 WP_301480134.1 type II secretion system F family protein [Aeromonas caviae] diamond 114 78.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Aeromonadaceae Aeromonas Aeromonas caviae
32837635 32837635 PRJNA929952_P_NODE_10260_length_359_cov_3.748485_g8976_i0 PRJNA929952 10260 359 3.748485 13.45706115 Shewanella sp. SNU WT4 2590015 Bacteria Bacteria 46.6 2.51e-4   NR WP_276613173.1 2590015 g8976 i0 63.3 0.250696378830084 30 11 25.1 0 93 4 8 37 WP_276613173.1 hypothetical protein [Shewanella sp. SNU WT4] diamond 90 46.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Shewanellaceae Shewanella Shewanella sp. SNU WT4

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