RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA558770" and tax_phylum = "Candidatus Berkelbacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Berkelbacteria · 18 ✖

tax_clade 1

bioproject 1

  • PRJNA558770 · 18 ✖

analysis 1

  • diamond · 18 ✖

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
26667107 26667107 PRJNA558770_P_NODE_173641_length_234_cov_4.964824_g171636_i0 PRJNA558770 173641 234 4.964824 11.61768816 Berkelbacteria bacterium GW2 2053521 Bacteria Bacteria 66.2 1.79e-10   NR KKQ17110.1 1618331 g171636 i0 48.7 0.974358974358974 76 39 97.4 0 228 1 133 208 KKQ17110.1 MAG: DNA/RNA helicase, superfamily I [Berkelbacteria bacterium GW2011_GWA1_36_9] diamond 228 66.2 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Berkelbacteria bacterium GW2011_GWA1_36_9
27363676 27363676 PRJNA558770_P_NODE_253823_length_234_cov_2.226131_g251818_i0 PRJNA558770 253823 234 2.226131 5.20914654 Candidatus Berkelbacteria bacterium 2053521 Bacteria Bacteria 61.6 6.14e-9   NR MBI4947981.1 2053521 g251818 i0 48.1 1.94871794871795 77 26 98.7 1 233 3 2 64 MBI4947981.1 carbohydrate kinase family protein [Candidatus Berkelbacteria bacterium] diamond 456 61.6 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium
27805639 27805639 PRJNA558770_P_NODE_257524_length_234_cov_2.145729_g255519_i0 PRJNA558770 257524 234 2.145729 5.02100586 Candidatus Berkelbacteria bacterium Licking1 2053521 Bacteria Bacteria 43.1 0.0229   NR TSC93119.1 2017148 g255519 i0 83.3 0.307692307692308 24 4 30.8 0 161 232 102 125 TSC93119.1 MAG: femAB family protein [Candidatus Berkelbacteria bacterium Licking1014_85] diamond 72 43.1 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium Licking1014_85
27931746 27931746 PRJNA558770_P_NODE_198485_length_234_cov_3.844221_g196480_i0 PRJNA558770 198485 234 3.844221 8.99547714 Berkelbacteria bacterium GW2 2053521 Bacteria Bacteria 49.7 1.16e-4   NR AKM81925.1 1618337 g196480 i0 38.2 0.974358974358974 76 23 97.4 1 3 230 276 327 AKM81925.1 MAG: exonuclease RecJ, single-stranded-DNA-specific exonuclease [Berkelbacteria bacterium GW2011_GWE1_39_12] diamond 228 49.7 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Berkelbacteria bacterium GW2011_GWE1_39_12
27931759 27931759 PRJNA558770_P_NODE_256145_length_234_cov_2.175879_g254140_i0 PRJNA558770 256145 234 2.175879 5.09155686 Candidatus Berkelbacteria bacterium 2053521 Bacteria Bacteria 49.3 1.4e-4   NR MCX6806917.1 2053521 g254140 i0 87 0.602564102564103 23 3 29.5 0 7 75 198 220 MCX6806917.1 phenylalanine--tRNA ligase subunit alpha [Candidatus Berkelbacteria bacterium] diamond 141 49.3 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium
28752652 28752652 PRJNA558770_P_NODE_280427_length_234_cov_1.728643_g278422_i0 PRJNA558770 280427 234 1.728643 4.04502462 Candidatus Berkelbacteria bacterium 2053521 Bacteria Bacteria 43.5 0.0185   NR MBI3495521.1 2053521 g278422 i0 84 0.641025641025641 25 4 32.1 0 1 75 332 356 MBI3495521.1 hypothetical protein [Candidatus Berkelbacteria bacterium] diamond 150 43.5 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium
28956370 28956370 PRJNA558770_P_NODE_114468_length_234_cov_9.934673_g112463_i0 PRJNA558770 114468 234 9.934673 23.24713482 Bacteria 2 Bacteria Bacteria 44.3 0.00891   NR KKQ18698.1 1618331 g112463 i0 87.5 0.615384615384615 24 3 30.8 0 3 74 169 192 KKQ18698.1 MAG: Tryptophan-tRNA ligase [Berkelbacteria bacterium GW2011_GWA1_36_9] diamond 144 44.3 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Berkelbacteria bacterium GW2011_GWA1_36_9
29114110 29114110 PRJNA558770_P_NODE_114828_length_234_cov_9.889447_g112823_i0 PRJNA558770 114828 234 9.889447 23.14130598 Bacteria 2 Bacteria Bacteria 51.6 2.29e-5   NR KKQ17936.1 1618331 g112823 i0 100 0.923076923076923 24 0 30.8 0 3 74 298 321 KKQ17936.1 MAG: Galactose-1-phosphate uridylyltransferase GalT [Berkelbacteria bacterium GW2011_GWA1_36_9] diamond 216 51.6 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Berkelbacteria bacterium GW2011_GWA1_36_9
29636344 29636344 PRJNA558770_P_NODE_178370_length_234_cov_4.723618_g176365_i0 PRJNA558770 178370 234 4.723618 11.05326612 Berkelbacteria bacterium GW2 2053521 Bacteria Bacteria 49.7 6.95e-5   NR KKQ18232.1 1618331 g176365 i0 84 0.320512820512821 25 4 32.1 0 2 76 24 48 KKQ18232.1 MAG: 30S ribosomal protein S4 [Berkelbacteria bacterium GW2011_GWA1_36_9] diamond 75 49.7 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Berkelbacteria bacterium GW2011_GWA1_36_9
29731182 29731182 PRJNA558770_P_NODE_194010_length_234_cov_4.020101_g192005_i0 PRJNA558770 194010 234 4.020101 9.40703634 Candidatus Berkelbacteria bacterium 2053521 Bacteria Bacteria 43.5 0.0183   NR NCN24591.1 2053521 g192005 i0 83.3 0.307692307692308 24 4 30.8 0 72 1 321 344 NCN24591.1 DNA translocase FtsK [Candidatus Berkelbacteria bacterium] diamond 72 43.5 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium
29921142 29921142 PRJNA558770_P_NODE_257331_length_234_cov_2.150754_g255326_i0 PRJNA558770 257331 234 2.150754 5.03276436 Berkelbacteria bacterium GW2 2053521 Bacteria Bacteria 67 8.84e-11   NR AKM82154.1 1618337 g255326 i0 43.8 3.42307692307692 89 37 97.4 1 229 2 105 193 AKM82154.1 MAG: phosphomannomutase [Berkelbacteria bacterium GW2011_GWE1_39_12] diamond 801 67 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Berkelbacteria bacterium GW2011_GWE1_39_12
30521239 30521239 PRJNA558770_P_NODE_278553_length_234_cov_1.758794_g276548_i0 PRJNA558770 278553 234 1.758794 4.11557796 Berkelbacteria bacterium GW2 2053521 Bacteria Bacteria 49.3 1.54e-4   NR KKQ17933.1 1618331 g276548 i0 88 0.320512820512821 25 3 32.1 0 233 159 255 279 KKQ17933.1 MAG: hypothetical protein US31_C0013G0016 [Berkelbacteria bacterium GW2011_GWA1_36_9] diamond 75 49.3 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Berkelbacteria bacterium GW2011_GWA1_36_9
30742347 30742347 PRJNA558770_P_NODE_106054_length_234_cov_11.251256_g104049_i0 PRJNA558770 106054 234 11.251256 26.32793904 Berkelbacteria bacterium GW2 2053521 Bacteria Bacteria 44.3 0.00914   NR KKQ74227.1 1618336 g104049 i0 82.6 1.17948717948718 23 4 29.5 0 227 159 70 92 KKQ74227.1 MAG: Preprotein translocase subunit SecD [Berkelbacteria bacterium GW2011_GWB1_38_5] diamond 276 44.3 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Berkelbacteria bacterium GW2011_GWB1_38_5
30742360 30742360 PRJNA558770_P_NODE_162914_length_234_cov_5.577889_g160909_i0 PRJNA558770 162914 234 5.577889 13.05226026 Berkelbacteria bacterium GW2 2053521 Bacteria Bacteria 67.8 2.95e-12   NR AKM82692.1 1618337 g160909 i0 50 1.07692307692308 84 34 97.4 1 2 229 5 88 AKM82692.1 MAG: 50S ribosomal protein L16 [Berkelbacteria bacterium GW2011_GWE1_39_12] diamond 252 67.8 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Berkelbacteria bacterium GW2011_GWE1_39_12
31152759 31152759 PRJNA558770_P_NODE_261515_length_234_cov_2.065327_g259510_i0 PRJNA558770 261515 234 2.065327 4.83286518 Berkelbacteria bacterium GW2 2053521 Bacteria Bacteria 43.1 0.0242   NR KKQ87731.1 1618334 g259510 i0 37.2 1 78 35 100 1 234 1 321 384 KKQ87731.1 MAG: Phenylacetate-CoA ligase [Berkelbacteria bacterium GW2011_GWA2_38_9] diamond 234 43.1 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Berkelbacteria bacterium GW2011_GWA2_38_9
31704863 31704863 PRJNA558770_P_NODE_293177_length_234_cov_1.482412_g291172_i0 PRJNA558770 293177 234 1.482412 3.46884408 Bacteria 2 Bacteria Bacteria 58.2 7.05e-8   NR OIP06655.1 1805038 g291172 i0 45.5 1.97435897435897 77 16 98.7 1 3 233 114 164 OIP06655.1 MAG: hypothetical protein AUK41_01990 [Candidatus Berkelbacteria bacterium CG2_30_43_20] diamond 462 58.2 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium CG2_30_43_20
32432680 32432680 PRJNA558770_P_NODE_148399_length_234_cov_6.532663_g146394_i0 PRJNA558770 148399 234 6.532663 15.28643142 Bacillati 1783272 Bacteria Bacteria 52 1.76e-5   NR KKQ17931.1 1618331 g146394 i0 92 8.28205128205128 25 2 32.1 0 2 76 409 433 KKQ17931.1 MAG: Glycogen synthase [Berkelbacteria bacterium GW2011_GWA1_36_9] diamond 1938 52 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Berkelbacteria bacterium GW2011_GWA1_36_9
32622080 32622080 PRJNA558770_P_NODE_199800_length_234_cov_3.788945_g197795_i0 PRJNA558770 199800 234 3.788945 8.8661313 Bacteria 2 Bacteria Bacteria 48.5 3.07e-4   NR AKM82243.1 1618337 g197795 i0 84 1.28205128205128 25 4 32.1 0 234 160 311 335 AKM82243.1 MAG: general secretion pathway protein E, general secretion pathway protein E [Berkelbacteria bacterium GW2011_GWE1_39_12] diamond 300 48.5 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Berkelbacteria bacterium GW2011_GWE1_39_12

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