RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJNA168635", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 22 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 22 ✖

bioproject 1

  • PRJNA168635 · 22 ✖
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
1054198 1054198 PRJNA168635_P_NODE_13641_length_219_cov_3.435294_g13225_i0 PRJNA168635 13641 219 3.435294 7.52329386 Gemmatimonas 173479 Bacteria Bacteria 388 1.3e-103   NTclustered gi|1015602748|gb|CP011454.1| 1379270 g13225 i0 98.63 14.6027397260274 219 3 100 0 1 219 2076153 2075935 Gemmatimonas phototrophica strain AP64, complete genome blastn 3198 388 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas phototrophica
1054396 1054396 PRJNA168635_P_NODE_4381_length_402_cov_9.390935_g3979_i0 PRJNA168635 4381 402 9.390935 37.7515587 Gemmatimonas 173479 Bacteria Bacteria 667 0   NTclustered gi|470475286|ref|NR_076270.1| 173480 g3979 i0 99.189 513.597014925373 370 3 92 0 33 402 1157 788 Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence blastn 206466 667 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas aurantiaca
4191719 4191719 PRJNA168635_P_NODE_31884_length_162_cov_0.920354_g31468_i0 PRJNA168635 31884 162 0.920354 1.49097348 Pseudomonadati 3379134 Bacteria Bacteria 96.7 1.24e-21   NR WP_337172479.1 173480 g31468 i0 81.1 4.90740740740741 53 10 98.1 0 3 161 721 773 WP_337172479.1 formate dehydrogenase subunit alpha [Gemmatimonas aurantiaca] diamond 795 97.1 0.995880535530381 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas aurantiaca
4191739 4191739 PRJNA168635_P_NODE_33284_length_158_cov_4.128440_g32868_i0 PRJNA168635 33284 158 4.12844 6.5229352 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 60.2 7.8e-5   NTclustered gi|2874253728|emb|OY969570.1| 412054 g32868 i0 85.965 1.80379746835443 57 6 35 2 59 114 171719 171774 MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 blastn 285 60.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
6157014 6157014 PRJNA168635_P_NODE_2625_length_509_cov_5.178261_g2239_i0 PRJNA168635 2625 509 5.178261 26.35734849 Gemmatimonas 173479 Bacteria Bacteria 754 0   NTclustered gi|470475286|ref|NR_076270.1| 173480 g2239 i0 93.491 329.730844793713 507 33 99 0 3 509 1903 1397 Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence blastn 167833 754 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas aurantiaca
6157155 6157155 PRJNA168635_P_NODE_9985_length_262_cov_10.788732_g9570_i0 PRJNA168635 9985 262 10.788732 28.26647784 Gemmatimonas 173479 Bacteria Bacteria 446 9.379999999999998e-121   NTclustered gi|470475286|ref|NR_076270.1| 173480 g9570 i0 97.328 39.8015267175573 262 7 100 0 1 262 2012 2273 Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence blastn 10428 446 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas aurantiaca
8017851 8017851 PRJNA168635_P_NODE_24667_length_170_cov_1.652893_g24251_i0 PRJNA168635 24667 170 1.652893 2.8099181 Pseudogemmatithrix spongiicola 3062599 Bacteria Bacteria 161 2.26e-35   NTclustered gi|2557479348|gb|CP130613.1| 3062599 g24251 i0 84.302 33.0470588235294 172 19 99 4 1 168 1552647 1552814 Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome blastn 5618 161 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Pseudogemmatithrix Pseudogemmatithrix spongiicola
14393577 14393577 PRJNA168635_P_NODE_21472_length_178_cov_1.232558_g21056_i0 PRJNA168635 21472 178 1.232558 2.19395324 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 233 5.01e-57   NTclustered gi|2874253728|emb|OY969570.1| 412054 g21056 i0 90.556 186.837078651685 180 11 99 5 2 178 173223 173047 MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 blastn 33257 233 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
17631818 17631818 PRJNA168635_P_NODE_1494_length_649_cov_5.311667_g1157_i0 PRJNA168635 1494 649 5.311667 34.47271883 Gemmatimonas 173479 Bacteria Bacteria 1042 0   NTclustered gi|470475286|ref|NR_076270.1| 173480 g1157 i0 95.712 145.730354391371 653 18 100 8 1 649 850 204 Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence blastn 94579 1042 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas aurantiaca
18216210 18216210 PRJNA168635_P_NODE_23195_length_173_cov_2.717742_g22779_i0 PRJNA168635 23195 173 2.717742 4.70169366 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 224 2.91e-54   NTclustered gi|2874254107|emb|OY970192.1| 412054 g22779 i0 91.463 226.28323699422 164 12 94 2 2 164 1592074 1592236 MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1 blastn 39147 224 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
22041205 22041205 PRJNA168635_P_NODE_30078_length_164_cov_0.904348_g29662_i0 PRJNA168635 30078 164 0.904348 1.48313072 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 63.2 6.43e-10   NR HEV8453759.1 2448054 g29662 i0 70 0.914634146341463 50 15 91.5 0 162 13 107 156 HEV8453759.1 hypothetical protein [Gemmatimonadales bacterium] diamond 150 63.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
28305629 28305629 PRJNA168635_P_NODE_8646_length_286_cov_2.244726_g8231_i0 PRJNA168635 8646 286 2.244726 6.41991636 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 43.1 0.0331   NR HSE53947.1 2448054 g8231 i0 33.7 1.02797202797203 98 45 87.1 3 7 255 100 192 HSE53947.1 helix-turn-helix domain-containing protein [Gemmatimonadales bacterium] diamond 294 43.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
28652973 28652973 PRJNA168635_P_NODE_19227_length_185_cov_1.507353_g18811_i0 PRJNA168635 19227 185 1.507353 2.78860305 Gemmatimonas sp. 1962908 Bacteria Bacteria 61.2 4.95e-9   NR MEQ1693660.1 1962908 g18811 i0 68.2 2.18918918918919 44 14 71.4 0 185 54 346 389 MEQ1693660.1 potassium channel family protein [Gemmatimonas sp.] diamond 405 61.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas sp.
28905267 28905267 PRJNA168635_P_NODE_16168_length_199_cov_2.046667_g15752_i0 PRJNA168635 16168 199 2.046667 4.07286733 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 72.4 4.74e-13   NR MBP6571614.1 2448054 g15752 i0 68.6 0.768844221105528 51 16 76.9 0 46 198 42 92 MBP6571614.1 recombinase RecT [Gemmatimonadales bacterium] diamond 153 72.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
29126817 29126817 PRJNA168635_P_NODE_29249_length_165_cov_0.896552_g28833_i0 PRJNA168635 29249 165 0.896552 1.4793108 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 69.3 5.25e-12   NR GMV07395.1 2026742 g28833 i0 60.4 1.94545454545455 53 21 96.4 0 2 160 241 293 GMV07395.1 MAG: hypothetical protein AMXMBFR53_36700 [Gemmatimonadota bacterium] diamond 321 69.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
29884530 29884530 PRJNA168635_P_NODE_32591_length_161_cov_2.625000_g32175_i0 PRJNA168635 32591 161 2.625 4.22625 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 44.3 0.0014   NR MBU6364809.1 2026742 g32175 i0 48 0.93167701863354 50 21 93.2 1 160 11 10 54 MBU6364809.1 hypothetical protein [Gemmatimonadota bacterium] diamond 150 44.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30073778 30073778 PRJNA168635_P_NODE_29972_length_164_cov_0.904348_g29556_i0 PRJNA168635 29972 164 0.904348 1.48313072 Longimicrobiaceae bacterium 3047548 Bacteria Bacteria 75.9 1.93e-16   NR HET7321161.1 3047548 g29556 i0 65.9 0.804878048780488 44 15 80.5 0 137 6 1 44 HET7321161.1 hypothetical protein [Longimicrobiaceae bacterium] diamond 132 75.9 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae   Longimicrobiaceae bacterium
30516218 30516218 PRJNA168635_P_NODE_25913_length_168_cov_1.747899_g25497_i0 PRJNA168635 25913 168 1.747899 2.93647032 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 102 1.2999999999999998e-24   NR MCC7132674.1 2448054 g25497 i0 90.9 0.982142857142857 55 5 98.2 0 2 166 135 189 MCC7132674.1 hypothetical protein [Gemmatimonadales bacterium] diamond 165 102 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
30737282 30737282 PRJNA168635_P_NODE_24654_length_170_cov_1.685950_g24238_i0 PRJNA168635 24654 170 1.68595 2.866115 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 44.7 0.00283   NR MCR4341171.1 2026741 g24238 i0 42.6 0.952941176470588 54 31 95.3 0 170 9 59 112 MCR4341171.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 162 44.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
30737286 30737286 PRJNA168635_P_NODE_29994_length_164_cov_0.904348_g29578_i0 PRJNA168635 29994 164 0.904348 1.48313072 Gaopeijia maritima 3119007 Bacteria Bacteria 53.5 1.97e-6   NR WP_405288063.1 3119007 g29578 i0 42.3 1.92073170731707 52 30 95.1 0 2 157 343 394 WP_405288063.1 phage portal protein [Gaopeijia maritima] diamond 315 53.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Gaopeijiales Gaopeijiaceae Gaopeijia Gaopeijia maritima
31306163 31306163 PRJNA168635_P_NODE_25195_length_169_cov_1.108333_g24779_i0 PRJNA168635 25195 169 1.108333 1.87308277 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 56.2 2.39e-7   NR MBK6423885.1 2026742 g24779 i0 71.1 0.674556213017751 38 11 67.5 0 166 53 114 151 MBK6423885.1 hypothetical protein [Gemmatimonadota bacterium] diamond 114 56.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
32336572 32336572 PRJNA168635_P_NODE_31019_length_163_cov_0.912281_g30603_i0 PRJNA168635 31019 163 0.912281 1.48701803 FCB group 1783270 Bacteria Bacteria 43.9 0.00487   NR HEX6992386.1 2448054 g30603 i0 48.1 1.89570552147239 52 27 95.7 0 158 3 1819 1870 HEX6992386.1 hypothetical protein [Gemmatimonadales bacterium] diamond 309 43.9 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales 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);;