RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond" and tax_clade = "SAR92 clade"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • SAR92 clade · 17 ✖

analysis 1

  • diamond · 17 ✖
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
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
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);;