RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where bioproject = "PRJNA695273" and tax_phylum = "Candidatus Blackallbacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Blackallbacteria · 10 ✖

tax_clade 1

bioproject 1

  • PRJNA695273 · 10 ✖

analysis 1

tax_kingdom 0

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
22354812 22354812 PRJNA695273_P_NODE_155978_length_242_cov_0.911243_g155220_i0 PRJNA695273 155978 242 0.911243 2.20520806 Bacteria 2 Bacteria Bacteria 132 1.15e-34   NR PIQ27644.1 2014262 g155220 i0 87.5 2.97520661157025 80 10 99.2 0 240 1 234 313 PIQ27644.1 MAG: alkaline serine protease [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26] diamond 720 132 1 Bacteria Bacteria candidate phyla   Candidatus Blackallbacteria         bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
26745422 26745422 PRJNA695273_P_NODE_54121_length_371_cov_1.033557_g53363_i0 PRJNA695273 54121 371 1.033557 3.83449647 Bacteria 2 Bacteria Bacteria 140 2.46e-38   NR PIQ29105.1 2014262 g53363 i0 62.3 1.84366576819407 114 43 92.2 0 369 28 137 250 PIQ29105.1 MAG: DUF547 domain-containing protein [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26] diamond 684 140 1 Bacteria Bacteria candidate phyla   Candidatus Blackallbacteria         bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
26777602 26777602 PRJNA695273_P_NODE_153941_length_243_cov_0.905882_g153183_i0 PRJNA695273 153941 243 0.905882 2.20129326 Bacteria 2 Bacteria Bacteria 85.1 3e-17   NR PIQ26335.1 2014262 g153183 i0 89.8 1.81481481481481 49 5 60.5 0 148 2 1 49 PIQ26335.1 MAG: flagellar biosynthesis protein FlhB [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26] diamond 441 85.1 1 Bacteria Bacteria candidate phyla   Candidatus Blackallbacteria         bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
29967611 29967611 PRJNA695273_P_NODE_68171_length_333_cov_1.473077_g67413_i0 PRJNA695273 68171 333 1.473077 4.90534641 Bacteria 2 Bacteria Bacteria 108 1.17e-24   NR PIQ24923.1 2014262 g67413 i0 54.1 1.76576576576577 98 45 88.3 0 3 296 531 628 PIQ24923.1 MAG: hypothetical protein COW64_16920 [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26] diamond 588 108 1 Bacteria Bacteria candidate phyla   Candidatus Blackallbacteria         bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
30567532 30567532 PRJNA695273_P_NODE_88833_length_293_cov_1.050000_g88075_i0 PRJNA695273 88833 293 1.05 3.0765 Bacteria 2 Bacteria Bacteria 130 7.73e-33   NR PIQ25049.1 2014262 g88075 i0 64.6 1.97610921501706 96 34 98.3 0 288 1 1216 1311 PIQ25049.1 MAG: hypothetical protein COW64_16550 [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26] diamond 579 131 0.99236641221374 Bacteria Bacteria candidate phyla   Candidatus Blackallbacteria         bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
31010158 31010158 PRJNA695273_P_NODE_147254_length_245_cov_0.895349_g146496_i0 PRJNA695273 147254 245 0.895349 2.19360505 Bacteria 2 Bacteria Bacteria 105 4.08e-26   NR PIQ24424.1 2014262 g146496 i0 61.8 2.79183673469388 76 29 93.1 0 17 244 1 76 PIQ24424.1 MAG: N-acetylmannosamine-6-phosphate 2-epimerase [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26] diamond 684 106 0.990566037735849 Bacteria Bacteria candidate phyla   Candidatus Blackallbacteria         bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
31199318 31199318 PRJNA695273_P_NODE_150715_length_244_cov_0.900585_g149957_i0 PRJNA695273 150715 244 0.900585 2.1974274 Bacteria 2 Bacteria Bacteria 148 8.99e-40   NR PIQ23315.1 2014262 g149957 i0 90.1 2.98770491803279 81 8 99.6 0 1 243 478 558 PIQ23315.1 MAG: peptidase S9, prolyl oligopeptidase [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26] diamond 729 148 1 Bacteria Bacteria candidate phyla   Candidatus Blackallbacteria         bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
31452925 31452925 PRJNA695273_P_NODE_58356_length_358_cov_1.080702_g57598_i0 PRJNA695273 58356 358 1.080702 3.86891316 Bacteria 2 Bacteria Bacteria 134 2.52e-35   NR PIQ28596.1 2014262 g57598 i0 54.9 3.80446927374302 113 51 94.7 0 19 357 109 221 PIQ28596.1 MAG: alpha/beta hydrolase [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26] diamond 1362 134 1 Bacteria Bacteria candidate phyla   Candidatus Blackallbacteria         bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
32169364 32169364 PRJNA695273_P_NODE_46578_length_397_cov_1.876543_g45820_i0 PRJNA695273 46578 397 1.876543 7.44987571 bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_5 2014262 Bacteria Bacteria 186 8.19e-52   NR PIQ25839.1 2014262 g45820 i0 81.5 0.982367758186398 130 24 98.2 0 7 396 911 1040 PIQ25839.1 MAG: CusA/CzcA family heavy metal efflux RND transporter [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26] diamond 390 186 1 Bacteria Bacteria candidate phyla   Candidatus Blackallbacteria         bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
32180501 32180501 PRJNA695273_P_NODE_136858_length_248_cov_0.880000_g136100_i0 PRJNA695273 136858 248 0.88 2.1824 Bacteria 2 Bacteria Bacteria 105 1e-24   NR PIQ26268.1 2014262 g136100 i0 61 1.95967741935484 82 32 99.2 0 246 1 242 323 PIQ26268.1 MAG: hypothetical protein COW64_11305 [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26] diamond 486 105 1 Bacteria Bacteria candidate phyla   Candidatus Blackallbacteria         bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26

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