RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA1059246" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1059246 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
5279697 5279697 PRJNA1059246_P_NODE_29625_length_403_cov_2.039394_g29000_i0 PRJNA1059246 29625 403 2.039394 8.21875782 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 246 1.11e-77   NR MEK7667743.1 2026742 g29000 i0 85.1 5.95533498759305 134 20 99.8 0 403 2 48 181 MEK7667743.1 Glu/Leu/Phe/Val dehydrogenase [Gemmatimonadota bacterium] diamond 2400 246 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
10380763 10380763 PRJNA1059246_P_NODE_71869_length_241_cov_1.476190_g71243_i0 PRJNA1059246 71869 241 1.47619 3.5576179 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 98.6 4.03e-22   NR HKG91662.1 2026741 g71243 i0 60.8 2.05394190871369 79 30 97.1 1 234 1 143 221 HKG91662.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 495 98.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
11655986 11655986 PRJNA1059246_P_NODE_70090_length_243_cov_0.905882_g69464_i0 PRJNA1059246 70090 243 0.905882 2.20129326 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 103 1.3899999999999998e-23   NR MFN8579726.1 2026741 g69464 i0 65.1 6.97530864197531 83 26 98.8 1 242 3 312 394 MFN8579726.1 PAS domain S-box protein [Gemmatimonadaceae bacterium] diamond 1695 103 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
18029101 18029101 PRJNA1059246_P_NODE_63735_length_249_cov_0.875000_g63109_i0 PRJNA1059246 63735 249 0.875 2.17875 Roseisolibacter sp. H3M3-2 3031323 Bacteria Bacteria 125 2.3e-35   NR WP_275828549.1 3031323 g63109 i0 97.1 2.49397590361446 69 2 83.1 0 208 2 1 69 WP_275828549.1 GlsB/YeaQ/YmgE family stress response membrane protein [Roseisolibacter sp. H3M3-2] diamond 621 125 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Roseisolibacter Roseisolibacter sp. H3M3-2
26718481 26718481 PRJNA1059246_P_NODE_70101_length_243_cov_0.905882_g69475_i0 PRJNA1059246 70101 243 0.905882 2.20129326 Longimicrobiales bacterium 2910168 Bacteria Bacteria 137 1.96e-35   NR HSW30760.1 2910168 g69475 i0 75 2.96296296296296 80 20 98.8 0 1 240 534 613 HSW30760.1 tryptophanase [Longimicrobiales bacterium] diamond 720 137 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
27066891 27066891 PRJNA1059246_P_NODE_42842_length_322_cov_1.546185_g42216_i0 PRJNA1059246 42842 322 1.546185 4.9787157 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 119 5.399999999999999e-31   NR HET7621904.1 2026741 g42216 i0 60.6 3.93167701863354 104 34 96.9 1 321 10 44 140 HET7621904.1 alpha/beta family hydrolase [Gemmatimonadaceae bacterium] diamond 1266 119 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
27224830 27224830 PRJNA1059246_P_NODE_31963_length_385_cov_1.246795_g31337_i0 PRJNA1059246 31963 385 1.246795 4.80016075 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 45.4 0.0199   NR MEX0690837.1 2448054 g31337 i0 26.8 0.958441558441558 123 88 94.3 1 19 381 248 370 MEX0690837.1 type II/IV secretion system protein [Gemmatimonadales bacterium] diamond 369 45.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
28330240 28330240 PRJNA1059246_P_NODE_56166_length_270_cov_1.192893_g55540_i0 PRJNA1059246 56166 270 1.192893 3.2208111 Longimicrobium sp. 2029185 Bacteria Bacteria 77.8 1.13e-15   NR HET7463511.1 2029185 g55540 i0 58.4 3.76666666666667 77 30 85.6 1 1 231 84 158 HET7463511.1 hemerythrin domain-containing protein [Longimicrobium sp.] diamond 1017 77.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
28867060 28867060 PRJNA1059246_P_NODE_67028_length_246_cov_0.890173_g66402_i0 PRJNA1059246 67028 246 0.890173 2.18982558 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 101 8.989999999999999e-23   NR HEY0969364.1 2448054 g66402 i0 66.7 2.97560975609756 81 24 98.8 1 2 244 484 561 HEY0969364.1 ISL3 family transposase [Gemmatimonadales bacterium] diamond 732 101 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
29269136 29269136 PRJNA1059246_P_NODE_64429_length_249_cov_0.875000_g63803_i0 PRJNA1059246 64429 249 0.875 2.17875 Bacteria 2 Bacteria Bacteria 44.3 0.0114   NR HJP57667.1 2448054 g63803 i0 50 0.867469879518072 38 19 45.8 0 244 131 728 765 HJP57667.1 phosphoribosylformylglycinamidine synthase subunit PurL [Gemmatimonadales bacterium] diamond 216 44.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
29340810 29340810 PRJNA1059246_P_NODE_59489_length_258_cov_1.594595_g58863_i0 PRJNA1059246 59489 258 1.594595 4.1140551 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 61.6 1e-8   NR MBA3760570.1 2448054 g58863 i0 47.8 0.779069767441861 67 33 77.9 2 1 201 300 364 MBA3760570.1 Ig-like domain-containing protein [Gemmatimonadales bacterium] diamond 201 61.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
29719301 29719301 PRJNA1059246_P_NODE_54830_length_274_cov_1.532338_g54204_i0 PRJNA1059246 54830 274 1.532338 4.19860612 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 61.6 4.16e-9   NR HSQ30497.1 2026741 g54204 i0 51.6 0.700729927007299 64 27 70.1 1 80 271 13 72 HSQ30497.1 PEP-CTERM sorting domain-containing protein [Gemmatimonadaceae bacterium] diamond 192 61.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
29837583 29837583 PRJNA1059246_P_NODE_29491_length_405_cov_0.927711_g28866_i0 PRJNA1059246 29491 405 0.927711 3.75722955 Bacteria 2 Bacteria Bacteria 135 5.6499999999999995e-37   NR HET7463700.1 2029185 g28866 i0 48.5 3.88888888888889 132 68 97.8 0 8 403 28 159 HET7463700.1 phosphoribosyltransferase [Longimicrobium sp.] diamond 1575 135 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
29972231 29972231 PRJNA1059246_P_NODE_58151_length_263_cov_1.352632_g57525_i0 PRJNA1059246 58151 263 1.352632 3.5574221600000002 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 98.2 1.1199999999999999e-23   NR HZI74644.1 2448054 g57525 i0 77.8 3.59315589353612 63 14 71.9 0 261 73 102 164 HZI74644.1 transposase [Gemmatimonadales bacterium] diamond 945 98.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
30762198 30762198 PRJNA1059246_P_NODE_59614_length_258_cov_1.016216_g58988_i0 PRJNA1059246 59614 258 1.016216 2.62183728 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 76.3 2.87e-14   NR MBA3258251.1 2448054 g58988 i0 50 1.87209302325581 82 37 90.7 2 8 241 203 284 MBA3258251.1 SDR family oxidoreductase [Gemmatimonadales bacterium] diamond 483 76.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
31481246 31481246 PRJNA1059246_P_NODE_47656_length_299_cov_2.384956_g47030_i0 PRJNA1059246 47656 299 2.384956 7.13101844 root 1 Root_unresolved Root_unresolved 97.1 2.17e-21   NR HYR06388.1 2029185 g47030 i0 76.4 7.20401337792642 55 13 55.2 0 185 21 309 363 HYR06388.1 erythromycin esterase family protein [Longimicrobium sp.] diamond 2154 97.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
31575919 31575919 PRJNA1059246_P_NODE_60156_length_256_cov_1.202186_g59530_i0 PRJNA1059246 60156 256 1.202186 3.07759616 Pseudomonadati 3379134 Bacteria Bacteria 77.4 2.35e-14   NR HEX6816518.1 2026741 g59530 i0 48.1 2.7421875 77 40 90.2 0 14 244 332 408 HEX6816518.1 NmrA/HSCARG family protein [Gemmatimonadaceae bacterium] diamond 702 77.8 0.994858611825193 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
31868536 31868536 PRJNA1059246_P_NODE_49497_length_291_cov_1.032110_g48871_i0 PRJNA1059246 49497 291 1.03211 3.0034401 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 85.1 8.35e-17   NR HYR30812.1 2448054 g48871 i0 46.2 4.76288659793814 91 46 93.8 2 278 6 424 511 HYR30812.1 leishmanolysin-related zinc metalloendopeptidase [Gemmatimonadales bacterium] diamond 1386 85.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
31931795 31931795 PRJNA1059246_P_NODE_27317_length_424_cov_1.096866_g26692_i0 PRJNA1059246 27317 424 1.096866 4.65071184 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 195 1.52e-60   NR MCH7932504.1 2026742 g26692 i0 66.9 1.96698113207547 139 45 98.3 1 6 422 6 143 MCH7932504.1 imidazoleglycerol-phosphate dehydratase HisB [Gemmatimonadota bacterium] diamond 834 195 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
32375078 32375078 PRJNA1059246_P_NODE_979_length_2261_cov_4.787020_g880_i0 PRJNA1059246 979 2261 4.78702 108.2345222 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 379 9.17e-120   NR MDB4950421.1 2026742 g880 i0 43.7 4.45422379478107 567 237 74.8 10 502 2193 20 507 MDB4950421.1 Aqualysin 1 [Gemmatimonadota bacterium] diamond 10071 379 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium

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