RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA1111077" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 21 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1111077 · 21 ✖

analysis 1

  • diamond · 21 ✖
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
11693290 11693290 PRJNA1111077_P_NODE_22610_length_278_cov_1.843902_g22389_i0 PRJNA1111077 22610 278 1.843902 5.12604756 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 142 6.46e-39   NR HEX5632232.1 2448054 g22389 i0 72.8 4.96402877697842 92 25 99.3 0 2 277 116 207 HEX5632232.1 ABC transporter permease [Gemmatimonadales bacterium] diamond 1380 142 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
12968370 12968370 PRJNA1111077_P_NODE_17451_length_298_cov_2.728889_g17230_i0 PRJNA1111077 17451 298 2.728889 8.13208922 Gemmatimonadaceae 219687 Bacteria Bacteria 93.2 1.15e-20   NR WP_284349959.1 2014610 g17230 i0 74.2 2.60738255033557 66 16 66.4 1 4 201 190 254 WP_284349959.1 rhomboid family intramembrane serine protease [Roseisolibacter agri] diamond 777 93.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Roseisolibacter Roseisolibacter agri
21891462 21891462 PRJNA1111077_P_NODE_22138_length_280_cov_1.231884_g21917_i0 PRJNA1111077 22138 280 1.231884 3.4492752 Gemmatimonas aurantiaca 173480 Bacteria Bacteria 165 2.9e-47   NR WP_015895283.1 173480 g21917 i0 86 2.98928571428571 93 13 99.6 0 2 280 118 210 WP_015895283.1 ABC transporter permease [Gemmatimonas aurantiaca] diamond 837 165 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas aurantiaca
24440777 24440777 PRJNA1111077_P_NODE_31740_length_249_cov_0.875000_g31519_i0 PRJNA1111077 31740 249 0.875 2.17875 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 135 1.78e-38   NR MDQ6718247.1 2026742 g31519 i0 75.3 4.06024096385542 81 19 96.4 1 9 248 28 108 MDQ6718247.1 YbhB/YbcL family Raf kinase inhibitor-like protein [Gemmatimonadota bacterium] diamond 1011 135 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
27257412 27257412 PRJNA1111077_P_NODE_25063_length_270_cov_1.101523_g24842_i0 PRJNA1111077 25063 270 1.101523 2.9741121 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 89 1.74e-18   NR HEX7595854.1 2026741 g24842 i0 51.9 1.77777777777778 81 39 90 0 1 243 101 181 HEX7595854.1 N-methyl-L-tryptophan oxidase [Gemmatimonadaceae bacterium] diamond 480 89 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
27288996 27288996 PRJNA1111077_P_NODE_14623_length_310_cov_6.911392_g14402_i0 PRJNA1111077 14623 310 6.911392 21.4253152 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 49.7 2.23e-5   NR MBA3579928.1 2026741 g14402 i0 44 1.5 50 28 48.4 0 310 161 24 73 MBA3579928.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 465 49.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
28511730 28511730 PRJNA1111077_P_NODE_14547_length_310_cov_12.189873_g14326_i0 PRJNA1111077 14547 310 12.189873 37.7886063 Bacteria 2 Bacteria Bacteria 94 3.34e-21   NR HTE45677.1 2026741 g14326 i0 89.8 3.31935483870968 49 5 47.4 0 162 308 25 73 HTE45677.1 cation:proton antiporter [Gemmatimonadaceae bacterium] diamond 1029 94 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
28804433 28804433 PRJNA1111077_P_NODE_22328_length_279_cov_1.621359_g22107_i0 PRJNA1111077 22328 279 1.621359 4.52359161 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 127 7.2e-32   NR HKP27775.1 2448054 g22107 i0 79.3 0.989247311827957 92 18 98.9 1 4 279 543 633 HKP27775.1 DEAD/DEAH box helicase [Gemmatimonadales bacterium] diamond 276 127 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
28836168 28836168 PRJNA1111077_P_NODE_31748_length_249_cov_0.875000_g31527_i0 PRJNA1111077 31748 249 0.875 2.17875 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 153 6.9399999999999985e-43   NR HVK01152.1 2448054 g31527 i0 100 1.95180722891566 81 0 97.6 0 247 5 5 85 HVK01152.1 HAMP domain-containing sensor histidine kinase [Gemmatimonadales bacterium] diamond 486 153 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
28954046 28954046 PRJNA1111077_P_NODE_31208_length_249_cov_2.329545_g30987_i0 PRJNA1111077 31208 249 2.329545 5.80056705 Pseudomonadati 3379134 Bacteria Bacteria 96.7 2.1e-22   NR HEU4562159.1 2029185 g30987 i0 58.5 2 82 34 98.8 0 3 248 142 223 HEU4562159.1 FkbM family methyltransferase [Longimicrobium sp.] diamond 498 96.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
29341523 29341523 PRJNA1111077_P_NODE_27289_length_261_cov_3.962766_g27068_i0 PRJNA1111077 27289 261 3.962766 10.34281926 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 136 5.399999999999999e-38   NR MDQ6737302.1 2026742 g27068 i0 82.1 3.67816091954023 78 14 89.7 0 257 24 93 170 MDQ6737302.1 FAD-binding protein [Gemmatimonadota bacterium] diamond 960 136 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30004667 30004667 PRJNA1111077_P_NODE_19671_length_288_cov_1.367442_g19450_i0 PRJNA1111077 19671 288 1.367442 3.93823296 Longimicrobium sp. 2029185 Bacteria Bacteria 47.8 0.00107   NR HEV7587256.1 2029185 g19450 i0 60 0.364583333333333 35 14 36.5 0 105 1 9 43 HEV7587256.1 P-loop NTPase fold protein [Longimicrobium sp.] diamond 105 47.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
30130605 30130605 PRJNA1111077_P_NODE_30132_length_251_cov_0.865169_g29911_i0 PRJNA1111077 30132 251 0.865169 2.17157419 Longimicrobiales bacterium 2910168 Bacteria Bacteria 155 2.88e-45   NR HUG39686.1 2910168 g29911 i0 89.2 2.97609561752988 83 9 99.2 0 250 2 16 98 HUG39686.1 Phenylacetic acid catabolic protein [Longimicrobiales bacterium] diamond 747 155 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
31300060 31300060 PRJNA1111077_P_NODE_14575_length_310_cov_8.637131_g14354_i0 PRJNA1111077 14575 310 8.637131 26.7751061 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 45.1 0.0118   NR MDP3775898.1 2448054 g14354 i0 51 0.474193548387097 49 17 40.6 2 180 305 4 52 MDP3775898.1 GWxTD domain-containing protein [Gemmatimonadales bacterium] diamond 147 45.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
31395104 31395104 PRJNA1111077_P_NODE_22156_length_280_cov_1.140097_g21935_i0 PRJNA1111077 22156 280 1.140097 3.1922716 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 47.4 0.00128   NR HXJ29501.1 2448054 g21935 i0 46.6 0.621428571428571 58 30 62.1 1 176 3 100 156 HXJ29501.1 DNA methyltransferase [Gemmatimonadales bacterium] diamond 174 47.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
31647807 31647807 PRJNA1111077_P_NODE_29077_length_254_cov_3.309392_g28856_i0 PRJNA1111077 29077 254 3.309392 8.40585568 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 114 9.3e-29   NR HXT47130.1 2026741 g28856 i0 67.5 3.92125984251969 83 27 98 0 254 6 68 150 HXT47130.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 996 114 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
31670840 31670840 PRJNA1111077_P_NODE_23377_length_275_cov_4.970297_g23156_i0 PRJNA1111077 23377 275 4.970297 13.66831675 Bacteria 2 Bacteria Bacteria 115 3.68e-28   NR MBI4421446.1 2026742 g23156 i0 64 1.93090909090909 89 31 96 1 10 273 3 91 MBI4421446.1 hypothetical protein [Gemmatimonadota bacterium] diamond 531 115 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
31869344 31869344 PRJNA1111077_P_NODE_34257_length_245_cov_0.895349_g34036_i0 PRJNA1111077 34257 245 0.895349 2.19360505 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 151 7.519999999999998e-42   NR MFI5244609.1 2448054 g34036 i0 84 0.991836734693878 81 13 99.2 0 243 1 141 221 MFI5244609.1 B12-binding domain-containing radical SAM protein [Gemmatimonadales bacterium] diamond 243 151 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
32280972 32280972 PRJNA1111077_P_NODE_17939_length_295_cov_5.536036_g17718_i0 PRJNA1111077 17939 295 5.536036 16.3313062 Longimicrobium sp. 2029185 Bacteria Bacteria 66.2 1.29e-11   NR WP_329682577.1 2029185 g17718 i0 68.3 0.416949152542373 41 13 41.7 0 26 148 47 87 WP_329682577.1 alpha/beta hydrolase-fold protein, partial [Longimicrobium sp.] diamond 123 66.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
32470802 32470802 PRJNA1111077_P_NODE_17339_length_298_cov_4.528889_g17118_i0 PRJNA1111077 17339 298 4.528889 13.49608922 Longimicrobiales bacterium 2910168 Bacteria Bacteria 177 3.97e-49   NR MEO5511175.1 2910168 g17118 i0 73.5 2.2751677852349 113 16 99.7 1 297 1 846 958 MEO5511175.1 amidohydrolase family protein [Longimicrobiales bacterium] diamond 678 177 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
32534069 32534069 PRJNA1111077_P_NODE_18099_length_294_cov_4.506787_g17878_i0 PRJNA1111077 18099 294 4.506787 13.24995378 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 66.6 2.7e-10   NR MEO7997562.1 2026741 g17878 i0 58.3 0.489795918367347 48 20 49 0 3 146 290 337 MEO7997562.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 144 66.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae 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);;