RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA278119" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 19 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA278119 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
26725486 26725486 PRJNA278119_P_NODE_2241_length_821_cov_2.126943_g2030_i0 PRJNA278119 2241 821 2.126943 17.46220203 Anaerolineales bacterium 2073117 Bacteria Bacteria 368 2.71e-117   NR HND47414.1 2073117 g2030 i0 63 1.08526187576127 297 82 99.8 3 3 821 402 694 HND47414.1 hypothetical protein [Anaerolineales bacterium] diamond 891 368 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
27136881 27136881 PRJNA278119_P_NODE_5962_length_488_cov_2.234624_g5716_i0 PRJNA278119 5962 488 2.234624 10.90496512 Anaerolineales bacterium 2073117 Bacteria Bacteria 110 1.22e-24   NR HND47414.1 2073117 g5716 i0 45 0.860655737704918 140 61 78.7 7 3 386 183 318 HND47414.1 hypothetical protein [Anaerolineales bacterium] diamond 420 110 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
27376564 27376564 PRJNA278119_P_NODE_46423_length_162_cov_1.380531_g46174_i0 PRJNA278119 46423 162 1.380531 2.23646022 Bacteria 2 Bacteria Bacteria 81.6 1.76e-16   NR HEY7467127.1 2026734 g46174 i0 69.2 8.57407407407407 52 16 96.3 0 3 158 262 313 HEY7467127.1 MBL fold metallo-hydrolase [Dehalococcoidia bacterium] diamond 1389 82.4 0.990291262135922 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
27390339 27390339 PRJNA278119_P_NODE_44803_length_163_cov_1.210526_g44554_i0 PRJNA278119 44803 163 1.210526 1.97315738 Roseiflexaceae bacterium 2762507 Bacteria Bacteria 83.6 5.17e-17   NR HEU4326262.1 2762507 g44554 i0 75.9 0.993865030674847 54 13 99.4 0 1 162 519 572 HEU4326262.1 S9 family peptidase [Roseiflexaceae bacterium] diamond 162 83.6 1 Bacteria   Bacillati Chloroflexota Chloroflexia Chloroflexales Roseiflexaceae   Roseiflexaceae bacterium
28495404 28495404 PRJNA278119_P_NODE_35167_length_169_cov_0.866667_g34918_i0 PRJNA278119 35167 169 0.866667 1.46466723 Roseiflexaceae bacterium 2762507 Bacteria Bacteria 112 1.26e-27   NR HEU5101156.1 2762507 g34918 i0 94.6 0.994082840236686 56 3 99.4 0 2 169 149 204 HEU5101156.1 extracellular solute-binding protein [Roseiflexaceae bacterium] diamond 168 112 1 Bacteria   Bacillati Chloroflexota Chloroflexia Chloroflexales Roseiflexaceae   Roseiflexaceae bacterium
28495421 28495421 PRJNA278119_P_NODE_807_length_1315_cov_2.852291_g676_i0 PRJNA278119 807 1315 2.852291 37.50762665 Anaerolineales bacterium 2073117 Bacteria Bacteria 175 1.44e-44   NR HND47413.1 2073117 g676 i0 29.8 1.06539923954373 467 197 76.9 6 1315 305 171 636 HND47413.1 Ty1/Copia family ribonuclease HI [Anaerolineales bacterium] diamond 1401 175 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
29112945 29112945 PRJNA278119_P_NODE_46128_length_162_cov_1.840708_g45879_i0 PRJNA278119 46128 162 1.840708 2.98194696 PVC group 1783257 Bacteria Bacteria 46.6 5.58e-4   NR MCX6071241.1 2026724 g45879 i0 47.1 7.55555555555556 51 27 94.4 0 10 162 293 343 MCX6071241.1 transketolase [Chloroflexota bacterium] diamond 1224 47 0.991489361702128 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
29789642 29789642 PRJNA278119_P_NODE_33711_length_171_cov_1.278689_g33462_i0 PRJNA278119 33711 171 1.278689 2.18655819 Anaerolineae bacterium 2052143 Bacteria Bacteria 88.2 1.24e-18   NR MCC7207441.1 2052143 g33462 i0 78.6 3.98245614035088 56 12 98.2 0 4 171 91 146 MCC7207441.1 orotidine-5'-phosphate decarboxylase [Anaerolineae bacterium] diamond 681 88.2 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
30091580 30091580 PRJNA278119_P_NODE_36672_length_168_cov_0.873950_g36423_i0 PRJNA278119 36672 168 0.87395 1.468236 Bacillati 1783272 Bacteria Bacteria 43.1 0.00977   NR OGO06267.1 1797632 g36423 i0 53.8 9.25 39 18 69.6 0 119 3 231 269 OGO06267.1 MAG: copper-translocating P-type ATPase, partial [Chloroflexi bacterium RBG_13_56_8] diamond 1554 43.5 0.990804597701149 Bacteria   Bacillati Chloroflexota         Chloroflexi bacterium RBG_13_56_8
30358924 30358924 PRJNA278119_P_NODE_11012_length_349_cov_4.010000_g10765_i0 PRJNA278119 11012 349 4.01 13.9949 Dehalococcoidales bacterium 2026733 Bacteria Bacteria 90.5 1.76e-20   NR MDO9333994.1 2026733 g10765 i0 92.2 0.438395415472779 51 3 43 1 3 152 89 139 MDO9333994.1 30S ribosomal protein S4 [Dehalococcoidales bacterium] diamond 153 90.5 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia Dehalococcoidales     Dehalococcoidales bacterium
30358952 30358952 PRJNA278119_P_NODE_39672_length_166_cov_1.213675_g39423_i0 PRJNA278119 39672 166 1.213675 2.0147005 Anaerolineales bacterium 2073117 Bacteria Bacteria 54.3 1.06e-6   NR HND47414.1 2073117 g39423 i0 51 0.885542168674699 49 24 88.6 0 18 164 17 65 HND47414.1 hypothetical protein [Anaerolineales bacterium] diamond 147 54.3 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
31021964 31021964 PRJNA278119_P_NODE_14855_length_282_cov_1.484979_g14606_i0 PRJNA278119 14855 282 1.484979 4.18764078 Candidatus Lucifugimonas marina 3038979 Bacteria Bacteria 64.3 5.7e-10   NR WP_342835703.1 3038979 g14606 i0 67.4 1.37234042553191 43 14 45.7 0 153 281 158 200 WP_342835703.1 NAD(P)-dependent oxidoreductase [Candidatus Lucifugimonas marina] diamond 387 64.3 1 Bacteria SAR202 cluster Bacillati Chloroflexota Dehalococcoidia Candidatus Lucifugimonadales Candidatus Lucifugimonadaceae Candidatus Lucifugimonas Candidatus Lucifugimonas marina
31085172 31085172 PRJNA278119_P_NODE_45955_length_163_cov_0.894737_g45706_i0 PRJNA278119 45955 163 0.894737 1.45842131 Chloroflexota bacterium 2026724 Bacteria Bacteria 53.1 2.7e-6   NR HET7770507.1 2026724 g45706 i0 84.8 0.607361963190184 33 5 60.7 0 100 2 388 420 HET7770507.1 YfhO family protein [Chloroflexota bacterium] diamond 99 53.1 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
31116480 31116480 PRJNA278119_P_NODE_20355_length_221_cov_1.808140_g20106_i0 PRJNA278119 20355 221 1.80814 3.9959894 Anaerolineales bacterium 2073117 Bacteria Bacteria 103 7.93e-24   NR HND47414.1 2073117 g20106 i0 59.7 0.97737556561086 72 29 97.7 0 1 216 728 799 HND47414.1 hypothetical protein [Anaerolineales bacterium] diamond 216 103 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
31274734 31274734 PRJNA278119_P_NODE_23035_length_206_cov_1.210191_g22786_i0 PRJNA278119 23035 206 1.210191 2.49299346 Ktedonobacteraceae bacterium 2740538 Bacteria Bacteria 69.3 4.07e-12   NR HZS76708.1 2740538 g22786 i0 46.2 2.14077669902913 78 32 99 2 204 1 84 161 HZS76708.1 sulfotransferase [Ktedonobacteraceae bacterium] diamond 441 69.3 1 Bacteria   Bacillati Chloroflexota Ktedonobacteria Ktedonobacterales Ktedonobacteraceae   Ktedonobacteraceae bacterium
31749077 31749077 PRJNA278119_P_NODE_12177_length_327_cov_1.859712_g11929_i0 PRJNA278119 12177 327 1.859712 6.08125824 Anaerolineales bacterium 2073117 Bacteria Bacteria 95.9 2.24e-20   NR HND47414.1 2073117 g11929 i0 60 0.688073394495413 75 27 66.1 1 322 107 801 875 HND47414.1 hypothetical protein [Anaerolineales bacterium] diamond 225 95.9 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
31907379 31907379 PRJNA278119_P_NODE_45817_length_163_cov_0.912281_g45568_i0 PRJNA278119 45817 163 0.912281 1.48701803 Chloroflexota bacterium 2026724 Bacteria Bacteria 81.3 3.26e-16   NR RPJ26839.1 2026724 g45568 i0 70.9 6.03680981595092 55 15 99.4 1 2 163 132 186 RPJ26839.1 MAG: aminotransferase class V-fold PLP-dependent enzyme [Chloroflexota bacterium] diamond 984 81.3 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
32666232 32666232 PRJNA278119_P_NODE_7540_length_433_cov_1.625000_g7293_i0 PRJNA278119 7540 433 1.625 7.03625 Anaerolineaceae bacterium 2024896 Bacteria Bacteria 144 2.82e-41   NR RJP51470.1 2024896 g7293 i0 58.4 1.7459584295612 125 47 83.1 1 422 63 2 126 RJP51470.1 MAG: RidA family protein [Anaerolineaceae bacterium] diamond 756 144 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales Anaerolineaceae   Anaerolineaceae bacterium
32760707 32760707 PRJNA278119_P_NODE_37100_length_168_cov_0.873950_g36851_i0 PRJNA278119 37100 168 0.87395 1.468236 Chloroflexota bacterium 2026724 Bacteria Bacteria 72 5.94e-13   NR MCH8062211.1 2026724 g36851 i0 56.4 0.982142857142857 55 24 98.2 0 2 166 318 372 MCH8062211.1 6-phosphofructokinase [Chloroflexota bacterium] diamond 165 72 1 Bacteria   Bacillati Chloroflexota         Chloroflexota 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);;