RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA745923" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 32 ✖

tax_kingdom 1

bioproject 1

  • PRJNA745923 · 32 ✖

analysis 1

  • diamond · 32 ✖

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
5828198 5828198 PRJNA745923_S_NODE_1425_length_1746_cov_10.018790_g1258_i0 PRJNA745923 1425 1746 10.01879 174.9280734 Pseudomonas aeruginosa 287 Bacteria Bacteria 524 2.92e-179   NR HEP8424912.1 287 g1258 i0 77.4 1.10996563573883 323 73 55.5 0 992 24 1 323 HEP8424912.1 3-isopropylmalate dehydratase large subunit [Pseudomonas aeruginosa] diamond 1938 524 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
5828258 5828258 PRJNA745923_S_NODE_1745_length_1450_cov_4.970149_g1559_i0 PRJNA745923 1745 1450 4.970149 72.0671605 Pseudomonas sp. Ag1 1197727 Bacteria Bacteria 343 7.65e-114   NR WP_008431820.1 1197727 g1559 i0 100 0.331034482758621 160 0 33.1 0 1042 563 1 160 WP_008431820.1 hypothetical protein [Pseudomonas sp. Ag1] diamond 480 343 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. Ag1
9653134 9653134 PRJNA745923_S_NODE_2188_length_1145_cov_4.540835_g1973_i0 PRJNA745923 2188 1145 4.540835 51.99256075 Pseudomonas sp. Ag1 1197727 Bacteria Bacteria 593 1.4599999999999998e-209   NR WP_008431861.1 1197727 g1973 i0 99.7 0.796506550218341 304 1 79.7 0 232 1143 1 304 WP_008431861.1 replicative DNA helicase [Pseudomonas sp. Ag1] diamond 912 593 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. Ag1
9653406 9653406 PRJNA745923_S_NODE_488_length_3709_cov_45.736498_g204_i1 PRJNA745923 488 3709 45.736498 1696.36671082 Pseudomonas sp. Ag1 1197727 Bacteria Bacteria 341 8.279999999999997e-106   NR WP_008431795.1 1197727 g204 i1 100 0.136694526826638 169 0 13.7 0 3169 2663 1 169 WP_008431795.1 hypothetical protein [Pseudomonas sp. Ag1] diamond 507 341 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. Ag1
13478327 13478327 PRJNA745923_S_NODE_1111_length_2135_cov_83.267686_g442_i1 PRJNA745923 1111 2135 83.267686 1777.7650961 unclassified Pseudomonas 196821 Bacteria Bacteria 1046 0   NR WP_339530219.1 196821 g442 i1 94.4 0.775644028103044 552 31 77.6 0 281 1936 1 552 WP_339530219.1 MULTISPECIES: ATP-binding protein [unclassified Pseudomonas] diamond 1656 1046 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas  
13952778 13952778 PRJNA745923_S_NODE_17111_length_241_cov_1.414141_g16779_i0 PRJNA745923 17111 241 1.414141 3.40807981 Pseudomonas 286 Bacteria Bacteria 116 3.71e-28   NR WP_008431821.1 1197727 g16779 i0 98.4 1.59336099585062 64 1 79.7 0 216 25 874 937 WP_008431821.1 phage tail length tape measure family protein [Pseudomonas sp. Ag1] diamond 384 116 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. Ag1
14753900 14753900 PRJNA745923_S_NODE_772_length_2800_cov_54.185346_g669_i0 PRJNA745923 772 2800 54.185346 1517.189688 Pseudomonas sp. Ag1 1197727 Bacteria Bacteria 1557 0   NR WP_008431821.1 1197727 g669 i0 100 0.938571428571429 876 0 93.9 0 173 2800 1 876 WP_008431821.1 phage tail length tape measure family protein [Pseudomonas sp. Ag1] diamond 2628 1557 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. Ag1
16027327 16027327 PRJNA745923_S_NODE_23393_length_200_cov_4.121019_g23061_i0 PRJNA745923 23393 200 4.121019 8.242038 Pseudomonas 286 Bacteria Bacteria 119 1.17e-30   NR WP_008434584.1 196821 g23061 i0 100 1.74 58 0 87 0 25 198 91 148 WP_008434584.1 MULTISPECIES: FecR domain-containing protein [unclassified Pseudomonas] diamond 348 119 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas  
18576221 18576221 PRJNA745923_S_NODE_13195_length_280_cov_2.037975_g12863_i0 PRJNA745923 13195 280 2.037975 5.70633 Pseudomonas sp. F1 260560 Bacteria Bacteria 161 1.14e-47   NR WP_371318907.1 2738821 g12863 i0 88.6 0.942857142857143 88 10 94.3 0 2 265 82 169 WP_371318907.1 Lar family restriction alleviation protein [Pseudomonas sp. F1002] diamond 264 161 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. F1002
19851721 19851721 PRJNA745923_S_NODE_2176_length_1150_cov_4.439928_g1961_i0 PRJNA745923 2176 1150 4.439928 51.059172 Pseudomonas sp. F1 260560 Bacteria Bacteria 629 6.91e-216   NR WP_177141526.1 2738821 g1961 i0 97.4 0.999130434782609 383 10 99.9 0 2 1150 58 440 WP_177141526.1 host specificity factor TipJ family phage tail protein [Pseudomonas sp. F1002] diamond 1149 629 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. F1002
21127241 21127241 PRJNA745923_S_NODE_1997_length_1260_cov_4.572720_g1792_i0 PRJNA745923 1997 1260 4.57272 57.616272 Pseudomonadota 1224 Bacteria Bacteria 258 3.57e-81   NR HEP8424911.1 287 g1792 i0 74.5 0.766666666666667 161 41 38.3 0 24 506 41 201 HEP8424911.1 3-isopropylmalate dehydratase small subunit [Pseudomonas aeruginosa] diamond 966 259 0.996138996138996 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
21127540 21127540 PRJNA745923_S_NODE_4977_length_501_cov_4.248908_g4652_i0 PRJNA745923 4977 501 4.248908 21.28702908 Pseudomonas yamanorum 515393 Bacteria Bacteria 309 4.94e-103   NR WP_177043928.1 515393 g4652 i0 98.1 0.952095808383233 159 3 95.2 0 1 477 35 193 WP_177043928.1 ROK family protein [Pseudomonas yamanorum] diamond 477 309 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas yamanorum
22402399 22402399 PRJNA745923_S_NODE_518_length_3585_cov_8.333992_g446_i0 PRJNA745923 518 3585 8.333992 298.7736132 Pseudomonas sp. Ag1 1197727 Bacteria Bacteria 1287 0   NR WP_008431817.1 1197727 g446 i0 100 0.548953974895397 656 0 54.9 0 3024 1057 1 656 WP_008431817.1 hypothetical protein [Pseudomonas sp. Ag1] diamond 1968 1287 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. Ag1
23677953 23677953 PRJNA745923_S_NODE_459_length_3867_cov_64.829759_g393_i0 PRJNA745923 459 3867 64.829759 2506.96678053 Pseudomonas lactis 1615674 Bacteria Bacteria 1581 0   NR WP_194289502.1 1615674 g393 i0 99.4 0.614429790535299 792 5 61.4 0 572 2947 1 792 WP_194289502.1 ABC-three component system protein [Pseudomonas lactis] diamond 2376 1581 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas lactis
24150396 24150396 PRJNA745923_S_NODE_1199_length_2018_cov_39.625316_g1046_i0 PRJNA745923 1199 2018 39.625316 799.63887688 Pseudomonas sp. P7779 2738832 Bacteria Bacteria 623 1.4299999999999997e-216   NR WP_256736790.1 2738832 g1046 i0 98.8 0.489098116947473 329 4 48.9 0 2 988 152 480 WP_256736790.1 phage tail protein [Pseudomonas sp. P7779] diamond 987 623 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. P7779
27021146 27021146 PRJNA745923_S_NODE_32602_length_166_cov_1.788618_g32270_i0 PRJNA745923 32602 166 1.788618 2.96910588 Pseudomonas sp. P7779 2738832 Bacteria Bacteria 89.7 3.69e-19   NR WP_178903865.1 2738832 g32270 i0 98.1 0.939759036144578 52 1 94 0 10 165 711 762 WP_178903865.1 phage tail tape measure protein, partial [Pseudomonas sp. P7779] diamond 156 89.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. P7779
27052856 27052856 PRJNA745923_S_NODE_38322_length_153_cov_0.872727_g37990_i0 PRJNA745923 38322 153 0.872727 1.33527231 Yersinia similis 367190 Bacteria Bacteria 40.4 0.0167   NR WP_050104513.1 367190 g37990 i0 47.1 0.666666666666667 34 18 66.7 0 106 5 32 65 WP_050104513.1 hypothetical protein [Yersinia similis] diamond 102 40.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Yersiniaceae Yersinia Yersinia similis
27210603 27210603 PRJNA745923_S_NODE_19002_length_226_cov_1.573770_g18670_i0 PRJNA745923 19002 226 1.57377 3.5567202 Pseudomonas aeruginosa 287 Bacteria Bacteria 85.5 1.26e-19   NR WP_226917202.1 287 g18670 i0 84 6.57079646017699 50 8 66.4 0 52 201 44 93 WP_226917202.1 reverse transcriptase domain-containing protein, partial [Pseudomonas aeruginosa] diamond 1485 85.9 0.9953434225844 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
27590044 27590044 PRJNA745923_S_NODE_18324_length_231_cov_1.531915_g17992_i0 PRJNA745923 18324 231 1.531915 3.53872365 Pseudoalteromonas luteoviolacea 43657 Bacteria Bacteria 42.4 0.0296   NR WP_063369261.1 43657 g17992 i0 35.2 1.42857142857143 54 27 70.1 1 32 193 123 168 WP_063369261.1 heme NO-binding domain-containing protein [Pseudoalteromonas luteoviolacea] diamond 330 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Pseudoalteromonadaceae Pseudoalteromonas Pseudoalteromonas luteoviolacea
27747951 27747951 PRJNA745923_S_NODE_37004_length_155_cov_1.258929_g36672_i0 PRJNA745923 37004 155 1.258929 1.95133995 Pseudomonas sp. Ag1 1197727 Bacteria Bacteria 110 2.11e-26   NR WP_008438641.1 1197727 g36672 i0 100 0.987096774193548 51 0 98.7 0 153 1 481 531 WP_008438641.1 FdhF/YdeP family oxidoreductase [Pseudomonas sp. Ag1] diamond 153 110 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. Ag1
28294360 28294360 PRJNA745923_S_NODE_16166_length_249_cov_2.626214_g15834_i0 PRJNA745923 16166 249 2.626214 6.53927286 Pseudomonas 286 Bacteria Bacteria 155 1.09e-44   NR WP_008434584.1 196821 g15834 i0 100 1.80722891566265 75 0 90.4 0 23 247 1 75 WP_008434584.1 MULTISPECIES: FecR domain-containing protein [unclassified Pseudomonas] diamond 450 155 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas  
28474021 28474021 PRJNA745923_S_NODE_23006_length_202_cov_1.955975_g22674_i0 PRJNA745923 23006 202 1.955975 3.9510695 Pseudomonas sp. F1 260560 Bacteria Bacteria 125 1.46e-34   NR WP_177142213.1 2738821 g22674 i0 100 1.78217821782178 60 0 89.1 0 202 23 14 73 WP_177142213.1 ROK family protein, partial [Pseudomonas sp. F1002] diamond 360 125 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. F1002
28979284 28979284 PRJNA745923_S_NODE_28228_length_180_cov_1.583942_g27896_i0 PRJNA745923 28228 180 1.583942 2.8510956 Pseudomonas sp. Ag1 1197727 Bacteria Bacteria 114 8.83e-30   NR WP_008438665.1 1197727 g27896 i0 90.7 0.9 54 5 90 0 2 163 154 207 WP_008438665.1 ammonia-forming cytochrome c nitrite reductase subunit c552 [Pseudomonas sp. Ag1] diamond 162 114 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. Ag1
29074032 29074032 PRJNA745923_S_NODE_40028_length_150_cov_2.242991_g39696_i0 PRJNA745923 40028 150 2.242991 3.3644865 Sphingomonas sp. TF3 2495580 Bacteria Bacteria 76.6 6.97e-17   NR WP_126849552.1 2495580 g39696 i0 93.9 1.96 49 3 98 0 149 3 20 68 WP_126849552.1 hypothetical protein [Sphingomonas sp. TF3] diamond 294 76.6 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas sp. TF3
29294839 29294839 PRJNA745923_S_NODE_23469_length_200_cov_1.961783_g23137_i0 PRJNA745923 23469 200 1.961783 3.923566 Escherichia coli 562 Bacteria Bacteria 57.8 5.17e-9   NR WP_332125380.1 562 g23137 i0 84.2 0.57 38 6 57 0 24 137 7 44 WP_332125380.1 hypothetical protein, partial [Escherichia coli] diamond 114 57.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
29768354 29768354 PRJNA745923_S_NODE_3051_length_805_cov_2.895013_g2787_i0 PRJNA745923 3051 805 2.895013 23.30485465 Pseudomonas sp. F1 260560 Bacteria Bacteria 537 3.0799999999999986e-182   NR WP_177141526.1 2738821 g2787 i0 98.5 1.99751552795031 268 4 99.9 0 2 805 436 703 WP_177141526.1 host specificity factor TipJ family phage tail protein [Pseudomonas sp. F1002] diamond 1608 537 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. F1002
30021336 30021336 PRJNA745923_S_NODE_35571_length_158_cov_1.669565_g35239_i0 PRJNA745923 35571 158 1.669565 2.6379127000000002 Bosea sp. BK6 2512180 Bacteria Bacteria 41.2 0.00782   NR WP_131858866.1 2512180 g35239 i0 39.2 0.968354430379747 51 27 89.2 1 9 149 20 70 WP_131858866.1 hypothetical protein [Bosea sp. BK604] diamond 153 41.2 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Boseaceae Bosea Bosea sp. BK604
30379052 30379052 PRJNA745923_S_NODE_14032_length_270_cov_1.991189_g13700_i0 PRJNA745923 14032 270 1.991189 5.3762103 Pseudomonas 286 Bacteria Bacteria 84.7 1.55e-17   NR WP_078738184.1 294 g13700 i0 97.6 0.944444444444444 42 1 46.7 0 122 247 1 42 WP_078738184.1 SCO family protein [Pseudomonas fluorescens] diamond 255 84.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas fluorescens
31411637 31411637 PRJNA745923_S_NODE_4136_length_588_cov_6.051376_g3825_i0 PRJNA745923 4136 588 6.051376 35.58209088 Ralstonia 48736 Bacteria Bacteria 258 5.44e-81   NR WP_021193777.1 48736 g3825 i0 90.1 1.44897959183673 142 14 72.4 0 15 440 324 465 WP_021193777.1 MULTISPECIES: 3-isopropylmalate dehydratase large subunit [Ralstonia] diamond 852 258 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Ralstonia  
32582224 32582224 PRJNA745923_S_NODE_40099_length_150_cov_1.794393_g39767_i0 PRJNA745923 40099 150 1.794393 2.6915895 Pseudomonas fluorescens 294 Bacteria Bacteria 64.3 3.44e-11   NR OPB01062.1 294 g39767 i0 97 0.66 33 1 66 0 3 101 126 158 OPB01062.1 cytochrome C [Pseudomonas fluorescens] diamond 99 64.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas fluorescens
32644720 32644720 PRJNA745923_S_NODE_6740_length_410_cov_3.029973_g6408_i0 PRJNA745923 6740 410 3.029973 12.4228893 Pseudomonas sp. Root569 1736566 Bacteria Bacteria 177 1.66e-48   NR WP_056845383.1 1736566 g6408 i0 76.6 1.00243902439024 137 31 99.5 1 410 3 819 955 WP_056845383.1 phage tail tape measure protein [Pseudomonas sp. Root569] diamond 411 177 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. Root569
32644721 32644721 PRJNA745923_S_NODE_7200_length_395_cov_3.306818_g6868_i0 PRJNA745923 7200 395 3.306818 13.0619311 Pseudomonas sp. Root569 1736566 Bacteria Bacteria 162 1.8199999999999993e-46   NR WP_056845389.1 1736566 g6868 i0 83.7 0.69873417721519 92 15 69.9 0 3 278 201 292 WP_056845389.1 baseplate assembly protein [Pseudomonas sp. Root569] diamond 276 162 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. Root569

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