RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA414036" and tax_clade = "Bacteria candidate phyla"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Bacteria candidate phyla · 19 ✖

bioproject 1

  • PRJNA414036 · 19 ✖

analysis 1

  • diamond · 19 ✖

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
1693488 1693488 PRJNA414036_P_NODE_162_length_1093_cov_64.661626_g136_i1 PRJNA414036 162 1093 64.661626 706.75157218 Candidatus Dojkabacteria bacterium 2099670 Bacteria Bacteria 124 4.05e-31   NR HRN86952.1 2099670 g136 i1 73.5 0.227813357731016 83 22 22.8 0 1071 823 1 83 HRN86952.1 hypothetical protein [Candidatus Dojkabacteria bacterium] diamond 249 124 1 Bacteria Bacteria candidate phyla             Candidatus Dojkabacteria bacterium
4245754 4245754 PRJNA414036_P_NODE_204_length_1017_cov_69.845214_g136_i2 PRJNA414036 204 1017 69.845214 710.32582638 Candidatus Dojkabacteria bacterium 2099670 Bacteria Bacteria 124 2.3599999999999998e-31   NR HRN86952.1 2099670 g136 i2 73.5 0.244837758112094 83 22 24.5 0 995 747 1 83 HRN86952.1 hypothetical protein [Candidatus Dojkabacteria bacterium] diamond 249 124 1 Bacteria Bacteria candidate phyla             Candidatus Dojkabacteria bacterium
11897513 11897513 PRJNA414036_P_NODE_150_length_1120_cov_63.168664_g136_i0 PRJNA414036 150 1120 63.168664 707.4890368 Candidatus Dojkabacteria bacterium 2099670 Bacteria Bacteria 124 4.839999999999999e-31   NR HRN86952.1 2099670 g136 i0 73.5 0.222321428571429 83 22 22.2 0 1098 850 1 83 HRN86952.1 hypothetical protein [Candidatus Dojkabacteria bacterium] diamond 249 124 1 Bacteria Bacteria candidate phyla             Candidatus Dojkabacteria bacterium
15721508 15721508 PRJNA414036_P_NODE_793_length_763_cov_86.638736_g136_i4 PRJNA414036 793 763 86.638736 661.05355568 Candidatus Dojkabacteria bacterium 2099670 Bacteria Bacteria 103 3.4299999999999995e-24   NR HRN86952.1 2099670 g136 i4 68.4 0.298820445609436 76 24 29.9 0 32 259 8 83 HRN86952.1 hypothetical protein [Candidatus Dojkabacteria bacterium] diamond 228 103 1 Bacteria Bacteria candidate phyla             Candidatus Dojkabacteria bacterium
19544502 19544502 PRJNA414036_P_NODE_236_length_978_cov_66.854719_g136_i3 PRJNA414036 236 978 66.854719 653.83915182 Candidatus Dojkabacteria bacterium 2099670 Bacteria Bacteria 124 1.2799999999999999e-31   NR HRN86952.1 2099670 g136 i3 73.5 0.254601226993865 83 22 25.5 0 226 474 1 83 HRN86952.1 hypothetical protein [Candidatus Dojkabacteria bacterium] diamond 249 124 1 Bacteria Bacteria candidate phyla             Candidatus Dojkabacteria bacterium
20820318 20820318 PRJNA414036_P_NODE_1177_length_703_cov_94.179641_g136_i5 PRJNA414036 1177 703 94.179641 662.08287623 Candidatus Dojkabacteria bacterium 2099670 Bacteria Bacteria 124 1.6499999999999999e-32   NR HRN86952.1 2099670 g136 i5 73.5 0.354196301564723 83 22 35.4 0 681 433 1 83 HRN86952.1 hypothetical protein [Candidatus Dojkabacteria bacterium] diamond 249 124 1 Bacteria Bacteria candidate phyla             Candidatus Dojkabacteria bacterium
27534580 27534580 PRJNA414036_P_NODE_44503_length_231_cov_3.433673_g42764_i0 PRJNA414036 44503 231 3.433673 7.93178463 Bacteria 2 Bacteria Bacteria 44.7 0.00669   NR NJK51264.1 2044595 g42764 i0 85.7 1.09090909090909 21 3 27.3 0 220 158 80 100 NJK51264.1 PAS domain S-box protein [Candidatus Altimarinota bacterium] diamond 252 44.7 1 Bacteria Bacteria candidate phyla   Candidatus Altimarinota         Candidatus Altimarinota bacterium
28086143 28086143 PRJNA414036_P_NODE_44365_length_231_cov_3.479592_g42626_i0 PRJNA414036 44365 231 3.479592 8.03785752 Candidatus Saccharimonadota bacterium 2026720 Bacteria Bacteria 61.6 6.51e-9   NR MBC7564865.1 2026720 g42626 i0 50.7 2.76623376623377 71 19 92.2 1 9 221 133 187 MBC7564865.1 AI-2E family transporter [Candidatus Saccharibacteria bacterium] diamond 639 61.6 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharimonadota bacterium
29506995 29506995 PRJNA414036_P_NODE_58350_length_223_cov_2.547872_g56611_i0 PRJNA414036 58350 223 2.547872 5.68175456 Candidatus Dojkabacteria bacterium 2099670 Bacteria Bacteria 73.2 1.08e-14   NR HRN86953.1 2099670 g56611 i0 78.4 0.68609865470852 51 11 68.6 0 1 153 57 107 HRN86953.1 hypothetical protein [Candidatus Dojkabacteria bacterium] diamond 153 73.2 1 Bacteria Bacteria candidate phyla             Candidatus Dojkabacteria bacterium
29506996 29506996 PRJNA414036_P_NODE_60810_length_213_cov_3.617978_g59071_i0 PRJNA414036 60810 213 3.617978 7.70629314 Candidatus Saccharimonadota bacterium 2026720 Bacteria Bacteria 47.8 1.8e-4   NR MDB5179975.1 2026720 g59071 i0 79.2 0.338028169014085 24 5 33.8 0 11 82 104 127 MDB5179975.1 hypothetical protein [Candidatus Saccharibacteria bacterium] diamond 72 47.8 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharimonadota bacterium
29696149 29696149 PRJNA414036_P_NODE_78370_length_165_cov_56.753846_g76631_i0 PRJNA414036 78370 165 56.753846 93.6438459 Parcubacteria bacterium C7867- 2762014 Bacteria Bacteria 45.1 4.51e-4   NR KND51121.1 1659195 g76631 i0 63.6 0.6 33 12 60 0 11 109 19 51 KND51121.1 MAG: hypothetical protein ABA06_02290 [Parcubacteria bacterium C7867-001] diamond 99 45.1 1 Bacteria Bacteria candidate phyla   Candidatus Parcubacteria         Parcubacteria bacterium C7867-001
29965898 29965898 PRJNA414036_P_NODE_41211_length_231_cov_5.244898_g39472_i0 PRJNA414036 41211 231 5.244898 12.11571438 Bacteria 2 Bacteria Bacteria 43.9 0.0123   NR AHB42076.1 1394711 g39472 i0 95.5 24.5714285714286 22 1 28.6 0 8 73 523 544 AHB42076.1 hypothetical protein RAAC3_TM7C00001G0211 [Candidatus Saccharibacteria bacterium RAAC3_TM7_1] diamond 5676 43.9 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium RAAC3_TM7_1
30455065 30455065 PRJNA414036_P_NODE_83093_length_158_cov_2.585366_g81354_i0 PRJNA414036 83093 158 2.585366 4.08487828 Candidatus Saccharimonadota bacterium 2026720 Bacteria Bacteria 45.8 1.38e-4   NR MDB5179974.1 2026720 g81354 i0 50 0.949367088607595 50 25 94.9 0 152 3 17 66 MDB5179974.1 hypothetical protein [Candidatus Saccharibacteria bacterium] diamond 150 45.8 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharimonadota bacterium
31813942 31813942 PRJNA414036_P_NODE_85857_length_154_cov_2.403361_g84118_i0 PRJNA414036 85857 154 2.403361 3.70117594 Candidatus Woesebacteria bacterium RIFOXYA1_FULL_38_9 1802531 Bacteria Bacteria 48.9 4.53e-6   NR OGM73833.1 1802531 g84118 i0 59.5 1.55844155844156 37 15 72.1 0 128 18 13 49 OGM73833.1 MAG: hypothetical protein A2191_04540 [Candidatus Woesebacteria bacterium RIFOXYA1_FULL_38_9] diamond 240 48.9 1 Bacteria Bacteria candidate phyla   Candidatus Woeseibacteriota         Candidatus Woesebacteria bacterium RIFOXYA1_FULL_38_9
31893849 31893849 PRJNA414036_P_NODE_47257_length_231_cov_2.750000_g45518_i0 PRJNA414036 47257 231 2.75 6.3525 Bacteria 2 Bacteria Bacteria 46.6 0.0014   NR OHA87156.1 1802732 g45518 i0 35.1 6.2987012987013 97 37 92.2 1 10 222 282 378 OHA87156.1 MAG: protein-export membrane protein SecD, partial [Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_01_FULL_35_32] diamond 1455 47 0.991489361702128 Bacteria Bacteria candidate phyla   Candidatus Zambryskiibacteriota         Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_01_FULL_35_32
32098661 32098661 PRJNA414036_P_NODE_45358_length_231_cov_3.188776_g43619_i0 PRJNA414036 45358 231 3.188776 7.36607256 Patescibacteria group bacterium 2052139 Bacteria Bacteria 44.7 0.00692   NR MES2631079.1 2052139 g43619 i0 90.9 0.571428571428571 22 2 28.6 0 157 222 511 532 MES2631079.1 HAD-IC family P-type ATPase [Patescibacteria group bacterium] diamond 132 44.7 1 Bacteria Bacteria candidate phyla             Patescibacteria group bacterium
32478632 32478632 PRJNA414036_P_NODE_44559_length_231_cov_3.418367_g42820_i0 PRJNA414036 44559 231 3.418367 7.89642777 Candidatus Saccharimonadales bacterium 2973664 Bacteria Bacteria 53.5 4.86e-6   NR HJP81387.1 2973664 g42820 i0 51.5 6.07792207792208 66 18 85.7 1 220 23 302 353 HJP81387.1 LCP family protein [Candidatus Saccharimonadales bacterium] diamond 1404 53.5 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota Candidatus Saccharimonadia Candidatus Saccharimonadales     Candidatus Saccharimonadales bacterium
32510321 32510321 PRJNA414036_P_NODE_22399_length_320_cov_4.042105_g20669_i0 PRJNA414036 22399 320 4.042105 12.934736 Candidatus Peregrinibacteria bacterium 2030811 Bacteria Bacteria 52 5.22e-5   NR MBI5755073.1 2030811 g20669 i0 60.7 8.9625 56 22 52.5 0 1 168 66 121 MBI5755073.1 carbamoyl-phosphate synthase (glutamine-hydrolyzing) large subunit [Candidatus Peregrinibacteria bacterium] diamond 2868 52.4 0.99236641221374 Bacteria Bacteria candidate phyla   Candidatus Peregrinibacteriota         Candidatus Peregrinibacteria bacterium
32762190 32762190 PRJNA414036_P_NODE_42020_length_231_cov_4.525510_g40281_i0 PRJNA414036 42020 231 4.52551 10.4539281 Candidatus Saccharimonadales bacterium 2973664 Bacteria Bacteria 41.2 0.0451   NR HEY1085400.1 2973664 g40281 i0 90.9 0.285714285714286 22 2 28.6 0 160 225 47 68 HEY1085400.1 50S ribosomal protein L14 [Candidatus Saccharimonadales bacterium] diamond 66 41.2 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota Candidatus Saccharimonadia Candidatus Saccharimonadales     Candidatus Saccharimonadales 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);;