RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA432257" and tax_phylum = "Chlorobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorobiota · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA432257 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
23381718 23381718 PRJNA432257_S_NODE_34219_length_266_cov_20.842795_g33838_i0 PRJNA432257 34219 266 20.842795 55.4418347 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 147 7.5e-40   NR KXB98564.1 1662223 g33838 i0 97.3 0.845864661654135 75 2 84.6 0 244 20 222 296 KXB98564.1 MAG: hypothetical protein AA908_04070 [Chlorobi bacterium NICIL-2] diamond 225 147 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
27265524 27265524 PRJNA432257_S_NODE_18663_length_330_cov_1.907850_g18282_i0 PRJNA432257 18663 330 1.90785 6.295905 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 153 4.2399999999999996e-42   NR KXB97589.1 1662223 g18282 i0 92.9 0.772727272727273 85 6 77.3 0 1 255 112 196 KXB97589.1 MAG: UDP-glucose 6-dehydrogenase [Chlorobi bacterium NICIL-2] diamond 255 153 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
27518167 27518167 PRJNA432257_S_NODE_14623_length_358_cov_5.146417_g14242_i0 PRJNA432257 14623 358 5.146417 18.42417286 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 204 5.930000000000001e-59   NR KXB98565.1 1662223 g14242 i0 93.7 0.930167597765363 111 7 93 0 355 23 41 151 KXB98565.1 MAG: hypothetical protein AA908_04075 [Chlorobi bacterium NICIL-2] diamond 333 204 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
27991939 27991939 PRJNA432257_S_NODE_99425_length_177_cov_1.114286_g99044_i0 PRJNA432257 99425 177 1.114286 1.97228622 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 117 1.5e-30   NR KXB97608.1 1662223 g99044 i0 94.8 0.983050847457627 58 3 98.3 0 174 1 184 241 KXB97608.1 MAG: hypothetical protein AA908_05640 [Chlorobi bacterium NICIL-2] diamond 174 117 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
28086406 28086406 PRJNA432257_S_NODE_80365_length_192_cov_206.625806_g79984_i0 PRJNA432257 80365 192 206.625806 396.72154752 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 82.8 6.38e-17   NR KXB97646.1 1662223 g79984 i0 91.1 0.703125 45 4 70.3 0 29 163 1 45 KXB97646.1 MAG: hypothetical protein AA908_05875 [Chlorobi bacterium NICIL-2] diamond 135 82.8 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
28591794 28591794 PRJNA432257_S_NODE_31727_length_273_cov_227.868644_g31346_i0 PRJNA432257 31727 273 227.868644 622.08139812 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 97.8 4.38e-22   NR KXB98715.1 1662223 g31346 i0 98.1 0.571428571428571 52 1 57.1 0 174 19 63 114 KXB98715.1 MAG: hypothetical protein AA908_03175 [Chlorobi bacterium NICIL-2] diamond 156 97.8 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
29759755 29759755 PRJNA432257_S_NODE_20331_length_320_cov_11.759717_g19950_i0 PRJNA432257 20331 320 11.759717 37.6310944 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 161 1.83e-43   NR KXB97457.1 1662223 g19950 i0 94.5 0.853125 91 5 85.3 0 306 34 8 98 KXB97457.1 MAG: hypothetical protein AA908_06250 [Chlorobi bacterium NICIL-2] diamond 273 161 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
30329113 30329113 PRJNA432257_S_NODE_64212_length_210_cov_31.843931_g63831_i0 PRJNA432257 64212 210 31.843931 66.8722551 Chloroherpetonaceae bacterium 2969135 Bacteria Bacteria 64.3 9.65e-12   NR MEN6512222.1 2969135 g63831 i0 54.2 1.35714285714286 48 22 68.6 0 28 171 19 66 MEN6512222.1 hypothetical protein [Chloroherpetonaceae bacterium] diamond 285 64.3 1 Bacteria FCB group Pseudomonadati Chlorobiota Chlorobiia Chlorobiales Chloroherpetonaceae   Chloroherpetonaceae bacterium
30486631 30486631 PRJNA432257_S_NODE_52933_length_226_cov_6.730159_g52552_i0 PRJNA432257 52933 226 6.730159 15.21015934 Chlorobiota bacterium 2268192 Bacteria Bacteria 79 5.36e-17   NR RMF32936.1 2268192 g52552 i0 97.4 0.517699115044248 39 1 51.8 0 217 101 1 39 RMF32936.1 MAG: RNA-binding protein [Chlorobiota bacterium] diamond 117 79 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobiota bacterium
32130792 32130792 PRJNA432257_S_NODE_25958_length_294_cov_3.346304_g25577_i0 PRJNA432257 25958 294 3.346304 9.83813376 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 127 9.2e-34   NR KXB97764.1 1662223 g25577 i0 100 0.581632653061224 57 0 58.2 0 270 100 232 288 KXB97764.1 MAG: hypothetical protein AA908_04995 [Chlorobi bacterium NICIL-2] diamond 171 127 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
32225646 32225646 PRJNA432257_S_NODE_55618_length_222_cov_2.843243_g55237_i0 PRJNA432257 55618 222 2.843243 6.31199946 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 126 8.54e-32   NR KXB98712.1 1662223 g55237 i0 100 0.810810810810811 60 0 81.1 0 193 14 889 948 KXB98712.1 MAG: alpha-ketoglutarate decarboxylase [Chlorobi bacterium NICIL-2] diamond 180 126 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
32636278 32636278 PRJNA432257_S_NODE_86260_length_187_cov_4.433333_g85879_i0 PRJNA432257 86260 187 4.433333 8.29033271 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 119 2.68e-29   NR KXB97433.1 1662223 g85879 i0 96.7 0.962566844919786 60 2 96.3 0 186 7 44 103 KXB97433.1 MAG: DEAD/DEAH box helicase [Chlorobi bacterium NICIL-2] diamond 180 119 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
32856882 32856882 PRJNA432257_S_NODE_60700_length_215_cov_2.191011_g60319_i0 PRJNA432257 60700 215 2.191011 4.71067365 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 118 6.28e-29   NR KXB97205.1 1662223 g60319 i0 98.5 0.92093023255814 66 0 90.7 1 206 12 364 429 KXB97205.1 MAG: iron/manganese transporter [Chlorobi bacterium NICIL-2] diamond 198 118 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2

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