RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

29 rows where tax_clade = "SAR92 clade", tax_kingdom = "Pseudomonadati" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 29 ✖

tax_phylum 1

tax_kingdom 1

  • Pseudomonadati · 29 ✖

tax_clade 1

  • SAR92 clade · 29 ✖
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
614910 614910 PRJNA641707_P_NODE_282561_length_169_cov_6.091667_g279898_i0 PRJNA641707 282561 169 6.091667 10.29491723 SAR92 clade bacterium H455 2974818 Bacteria Bacteria 89.8 1.08e-13   NTclustered gi|2293304500|gb|CP103416.1| 2974818 g279898 i0 88.889 0.42603550295858 72 8 43 0 2 73 64280 64351 SAR92 clade bacterium H455 chromosome blastn 72 89.8 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   SAR92 clade bacterium H455
1073509 1073509 PRJNA371613_P_NODE_2021_length_418_cov_84.015748_g1846_i0 PRJNA371613 2021 418 84.015748 351.18582664 Cellvibrionales 1706369 Bacteria Bacteria 425 2.06e-114   NTclustered gi|14334237|gb|AY033301.1| 159788 g1846 i0 85.308 289.978468899522 422 50 99 11 1 417 2008 2422 Uncultured gamma proteobacterium MB11B11 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 121211 425 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   uncultured gamma proteobacterium MB11B11
2037911 2037911 PRJNA781427_P_NODE_90842_length_244_cov_0.900585_g89958_i0 PRJNA781427 90842 244 0.900585 2.1974274 SAR92 clade bacterium H455 2974818 Bacteria Bacteria 401 1.8999999999999998e-107   NTclustered gi|2293304500|gb|CP103416.1| 2974818 g89958 i0 96.311 1.86065573770492 244 9 100 0 1 244 839540 839783 SAR92 clade bacterium H455 chromosome blastn 454 401 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   SAR92 clade bacterium H455
2198828 2198828 PRJNA944150_P_NODE_18382_length_206_cov_2.394904_g18131_i0 PRJNA944150 18382 206 2.394904 4.93350224 SAR92 clade bacterium H455 2974818 Bacteria Bacteria 165 2.22e-36   NTclustered gi|2293304500|gb|CP103416.1| 2974818 g18131 i0 81.373 13.4757281553398 204 36 99 2 4 206 1946589 1946387 SAR92 clade bacterium H455 chromosome blastn 2776 165 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   SAR92 clade bacterium H455
6015162 6015162 PRJNA937226_S_NODE_2325_length_405_cov_12.134831_g2198_i0 PRJNA937226 2325 405 12.134831 49.14606555 uncultured gamma proteobacterium MB11B11 159788 Bacteria Bacteria 429 1.5399999999999996e-115   NTclustered gi|14334237|gb|AY033301.1| 159788 g2198 i0 86.07 203.804938271605 402 53 99 3 6 405 2422 2022 Uncultured gamma proteobacterium MB11B11 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 82541 429 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   uncultured gamma proteobacterium MB11B11
11534879 11534879 PRJEB36940_P_NODE_11290_length_262_cov_1.666667_g11161_i0 PRJEB36940 11290 262 1.666667 4.36666754 SAR92 clade bacterium H455 2974818 Bacteria Bacteria 370 5.81e-98   NTclustered gi|2293304500|gb|CP103416.1| 2974818 g11161 i0 92.308 342.935114503817 260 20 99 0 3 262 2636444 2636703 SAR92 clade bacterium H455 chromosome blastn 89849 370 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   SAR92 clade bacterium H455
11755143 11755143 PRJNA1120771_S_NODE_24030_length_243_cov_2.820000_g23630_i0 PRJNA1120771 24030 243 2.82 6.8526 uncultured gamma proteobacterium MB11B11 159788 Bacteria Bacteria 239 1.57e-58   NTclustered gi|14334237|gb|AY033301.1| 159788 g23630 i0 85.47 309.765432098765 234 29 96 4 1 233 2103 2332 Uncultured gamma proteobacterium MB11B11 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 75273 239 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   uncultured gamma proteobacterium MB11B11
17191331 17191331 PRJNA641707_P_NODE_217154_length_194_cov_4.179310_g214491_i0 PRJNA641707 217154 194 4.17931 8.1078614000000009 SAR92 clade bacterium H455 2974818 Bacteria Bacteria 241 3.3300000000000007e-59   NTclustered gi|2293304500|gb|CP103416.1| 2974818 g214491 i0 89.84 392.577319587629 187 19 96 0 3 189 2636538 2636724 SAR92 clade bacterium H455 chromosome blastn 76160 241 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   SAR92 clade bacterium H455
18279893 18279893 PRJNA431371_P_NODE_30275_length_246_cov_0.890173_g30202_i0 PRJNA431371 30275 246 0.890173 2.18982558 Gammaproteobacteria bacterium LSUCC 1913989 Bacteria Bacteria 73.9 3.83e-13   NR TFH68789.1 2559237 g30202 i0 51.5 1.71951219512195 66 30 80.5 1 242 45 80 143 TFH68789.1 hypothetical protein E3W66_02220 [Gammaproteobacteria bacterium LSUCC0057] diamond 423 73.9 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   Gammaproteobacteria bacterium LSUCC0057
19282426 19282426 PRJNA1011844_P_NODE_27056_length_1033_cov_9.108333_g20778_i0 PRJNA1011844 27056 1033 9.108333 94.08907989 Pseudomonadati 3379134 Bacteria Bacteria 186 8.17e-54   NR KRP19166.1 1655625 g20778 i0 38.7 4.8325266214908 279 102 81 5 874 38 3 212 KRP19166.1 MAG: hypothetical protein ABS23_05125 [SAR92 bacterium BACL16 MAG-120619-bin48] diamond 4992 187 0.994652406417112 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   SAR92 bacterium BACL16 MAG-120619-bin48
21223770 21223770 PRJNA827593_P_NODE_66537_length_243_cov_0.905882_g66238_i0 PRJNA827593 66537 243 0.905882 2.20129326 Gammaproteobacteria bacterium LSUCC 1913989 Bacteria Bacteria 110 3.5e-26   NR TFH67381.1 2559237 g66238 i0 71.3 1.93827160493827 80 23 98.8 0 242 3 385 464 TFH67381.1 carbohydrate kinase [Gammaproteobacteria bacterium LSUCC0057] diamond 471 110 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   Gammaproteobacteria bacterium LSUCC0057
21643955 21643955 PRJNA888821_P_NODE_27637_length_280_cov_8.101449_g27555_i0 PRJNA888821 27637 280 8.101449 22.6840572 Gammaproteobacteria 1236 Bacteria Bacteria 261 3.94e-65   NTclustered gi|14334237|gb|AY033301.1| 159788 g27555 i0 85.271 469.246428571429 258 33 92 4 24 280 2332 2079 Uncultured gamma proteobacterium MB11B11 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 131389 261 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   uncultured gamma proteobacterium MB11B11
22066362 22066362 PRJNA330616_P_NODE_9858_length_264_cov_1.423256_g9449_i0 PRJNA330616 9858 264 1.423256 3.75739584 SAR92 clade bacterium H455 2974818 Bacteria Bacteria 220 6.25e-53   NTclustered gi|2293304500|gb|CP103416.1| 2974818 g9449 i0 90.909 8.68560606060606 165 14 63 1 48 212 1034623 1034460 SAR92 clade bacterium H455 chromosome blastn 2293 220 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   SAR92 clade bacterium H455
24827670 24827670 PRJNA630162_P_NODE_114020_length_177_cov_2.960938_g112497_i0 PRJNA630162 114020 177 2.960938 5.24086026 SAR92 clade bacterium H455 2974818 Bacteria Bacteria 95.3 2.45e-15   NTclustered gi|2293304500|gb|CP103416.1| 2974818 g112497 i0 87.654 8.46892655367232 81 10 46 0 2 82 2635047 2635127 SAR92 clade bacterium H455 chromosome blastn 1499 95.3 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   SAR92 clade bacterium H455
26463081 26463081 PRJEB14175_P_NODE_59168_length_482_cov_104.320665_g56915_i0 PRJEB14175 59168 482 104.320665 502.8256053 SAR92 clade bacterium H455 2974818 Bacteria Bacteria 599 1.3399999999999997e-166   NTclustered gi|2293304500|gb|CP103416.1| 2974818 g56915 i0 90.217 369.46887966805 460 43 95 2 25 482 2636724 2636265 SAR92 clade bacterium H455 chromosome blastn 178084 599 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   SAR92 clade bacterium H455
27300322 27300322 PRJNA560932_P_NODE_49623_length_258_cov_1.248649_g49267_i0 PRJNA560932 49623 258 1.248649 3.22151442 SAR92 bacterium MED-G29 1986232 Bacteria Bacteria 110 3.45e-26   NR CAI8385950.1 1986232 g49267 i0 62.9 2.02325581395349 89 29 100 2 258 1 347 434 CAI8385950.1 MAG: 5-methylthioadenosine/S-adenosylhomocysteine deaminase [SAR92 bacterium MED-G29] diamond 522 110 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   SAR92 bacterium MED-G29
28344687 28344687 PRJNA662254_P_NODE_55346_length_246_cov_0.890173_g54695_i0 PRJNA662254 55346 246 0.890173 2.18982558 SAR92 clade bacterium H231 2975451 Bacteria Bacteria 103 4.35e-25   NR MCT2533595.1 2975451 g54695 i0 61.4 0.853658536585366 70 27 85.4 0 3 212 188 257 MCT2533595.1 FkbM family methyltransferase [SAR92 clade bacterium H231] diamond 210 103 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   SAR92 clade bacterium H231
28649785 28649785 PRJNA1148190_P_NODE_123547_length_475_cov_0.957711_g112384_i0 PRJNA1148190 123547 475 0.957711 4.54912725 SAR92 clade bacterium H921 2975452 Bacteria Bacteria 55.1 5.06e-7   NR MCT2531055.1 2975452 g112384 i0 46.8 0.391578947368421 62 26 38.5 2 349 167 1 56 MCT2531055.1 hypothetical protein [SAR92 clade bacterium H921] diamond 186 55.1 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   SAR92 clade bacterium H921
28693325 28693325 PRJNA690592_S_NODE_4247_length_1275_cov_3.552413_g3799_i0 PRJNA690592 4247 1275 3.552413 45.29326575 SAR92 bacterium MED-G29 1986232 Bacteria Bacteria 125 1.5600000000000002e-27   NR CAI8305645.1 1986232 g3799 i0 25.8 1.85882352941176 396 278 91.3 8 44 1207 64 451 CAI8305645.1 MAG: Aldehyde dehydrogenase [SAR92 bacterium MED-G29] diamond 2370 125 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   SAR92 bacterium MED-G29
29051034 29051034 PRJNA558770_P_NODE_151988_length_234_cov_6.276382_g149983_i0 PRJNA558770 151988 234 6.276382 14.68673388 Bacteria 2 Bacteria Bacteria 44.7 0.00637   NR KRO90218.1 1655626 g149983 i0 79.2 3.6025641025641 24 5 30.8 0 73 2 206 229 KRO90218.1 MAG: elongation factor Ts [SAR92 bacterium BACL26 MAG-121220-bin70] diamond 843 44.7 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   SAR92 bacterium BACL26 MAG-121220-bin70
29513877 29513877 PRJNA690592_S_NODE_4350_length_1263_cov_3.818487_g3799_i1 PRJNA690592 4350 1263 3.818487 48.22749081 SAR92 bacterium MED-G29 1986232 Bacteria Bacteria 125 2e-27   NR CAI8305645.1 1986232 g3799 i1 25.8 0.94061757719715 396 278 92.2 8 32 1195 64 451 CAI8305645.1 MAG: Aldehyde dehydrogenase [SAR92 bacterium MED-G29] diamond 1188 125 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   SAR92 bacterium MED-G29
30313311 30313311 PRJNA1237347_P_NODE_426372_length_269_cov_1.102041_g419799_i0 PRJNA1237347 426372 269 1.102041 2.96449029 Bacteria 2 Bacteria Bacteria 107 8.14e-28   NR EAS47412.1 314287 g419799 i0 60.2 9.1449814126394 83 31 92.6 1 19 267 22 102 EAS47412.1 hypothetical protein GB2207_01372 [gamma proteobacterium HTCC2207] diamond 2460 107 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   gamma proteobacterium HTCC2207
30998844 30998844 PRJNA690592_S_NODE_21854_length_640_cov_3.111111_g20877_i0 PRJNA690592 21854 640 3.111111 19.9111104 SAR92 bacterium MED-G29 1986232 Bacteria Bacteria 51.6 0.00105   NR CAI8350037.1 1986232 g20877 i0 29.1 0.5484375 117 73 54.4 3 425 78 88 195 CAI8350037.1 MAG: Aminopeptidase N [SAR92 bacterium MED-G29] diamond 351 51.6 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   SAR92 bacterium MED-G29
31322097 31322097 PRJEB11523_P_NODE_1555_length_455_cov_28.051724_g1477_i0 PRJEB11523 1555 455 28.051724 127.6353442 Pseudomonadota 1224 Bacteria Bacteria 144 1.19e-38   NR KRO90398.1 1655626 g1477 i0 51.8 39.8637362637363 137 65 90.3 1 17 427 26 161 KRO90398.1 MAG: tRNA modification GTPase MnmE, partial [SAR92 bacterium BACL26 MAG-121220-bin70] diamond 18138 145 0.993103448275862 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   SAR92 bacterium BACL26 MAG-121220-bin70
31469402 31469402 PRJNA556992_P_NODE_836176_length_244_cov_1.491228_g833986_i0 PRJNA556992 836176 244 1.491228 3.63859632 SAR92 clade bacterium H455 2974818 Bacteria Bacteria 107 1.17e-27   NR UVW33972.1 2974818 g833986 i0 68.5 2.77868852459016 73 23 89.8 0 219 1 6 78 UVW33972.1 hypothetical protein NYF23_07965 [SAR92 clade bacterium H455] diamond 678 107 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   SAR92 clade bacterium H455
32885594 32885594 PRJNA1237347_P_NODE_386280_length_285_cov_2.268868_g379707_i0 PRJNA1237347 386280 285 2.268868 6.4662738 SAR92 clade bacterium H921 2975452 Bacteria Bacteria 69.7 1.78e-11   NR MCT2529775.1 2975452 g379707 i0 46.8 0.831578947368421 79 41 82.1 1 234 1 3 81 MCT2529775.1 CoA transferase [SAR92 clade bacterium H921] diamond 237 69.7 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   SAR92 clade bacterium H921
32915483 32915483 PRJNA1233465d_S_NODE_100337_length_182_cov_1.593985_g99226_i0 PRJNA1233465 100337 182 1.593985 2.9010527 SAR92 clade bacterium H231 2975451 Bacteria Bacteria 47 5.24e-4   NR MCT2533594.1 2975451 g99226 i0 47.2 0.873626373626374 53 28 87.4 0 164 6 156 208 MCT2533594.1 lipopolysaccharide biosynthesis protein [SAR92 clade bacterium H231] diamond 159 47 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   SAR92 clade bacterium H231
33099284 33099284 PRJEB20058_P_NODE_68734_length_503_cov_3.807692_g65964_i0 PRJEB20058 68734 503 3.807692 19.15269076 Gammaproteobacteria bacterium LSUCC 1913989 Bacteria Bacteria 88.6 1.36e-18   NR TFH67405.1 2559237 g65964 i0 49.5 1.83697813121272 103 52 61.4 0 482 174 72 174 TFH67405.1 Fe-S protein assembly co-chaperone HscB [Gammaproteobacteria bacterium LSUCC0057] diamond 924 88.6 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   Gammaproteobacteria bacterium LSUCC0057
33104824 33104824 PRJNA1233465f_S_NODE_224742_length_169_cov_2.233333_g222462_i0 PRJNA1233465 224742 169 2.233333 3.77433277 SAR92 clade bacterium H231 2975451 Bacteria Bacteria 45.8 0.00109   NR MCT2533594.1 2975451 g222462 i0 47.2 0.940828402366864 53 28 94.1 0 164 6 156 208 MCT2533594.1 lipopolysaccharide biosynthesis protein [SAR92 clade bacterium H231] diamond 159 45.8 1 Bacteria SAR92 clade Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae   SAR92 clade bacterium H231

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