RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA549880" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 12 ✖

bioproject 1

  • PRJNA549880 · 12 ✖

analysis 1

  • diamond · 12 ✖
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
14540690 14540690 PRJNA549880_P_NODE_14992_length_242_cov_0.911243_g14899_i0 PRJNA549880 14992 242 0.911243 2.20520806 Scytonema sp. PRP1 3120513 Bacteria Bacteria 142 2.4199999999999993e-40   NR WP_332996773.1 3120513 g14899 i0 93.8 0.991735537190083 80 5 99.2 0 2 241 80 159 WP_332996773.1 cadmium resistance transporter [Scytonema sp. PRP1] diamond 240 142 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Scytonemataceae Scytonema Scytonema sp. PRP1
21521643 21521643 PRJNA549880_P_NODE_10517_length_251_cov_0.865169_g10424_i0 PRJNA549880 10517 251 0.865169 2.17157419 Cyanobacteria bacterium PR.023 2067979 Bacteria Bacteria 121 3.1299999999999995e-31   NR MBA4073859.1 2067979 g10424 i0 83.1 0.99203187250996006 83 12 99.2 1 3 251 190 270 MBA4073859.1 hypothetical protein [Cyanobacteria bacterium PR.023] diamond 249 121 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium PR.023
27330913 27330913 PRJNA549880_P_NODE_11583_length_249_cov_0.875000_g11490_i0 PRJNA549880 11583 249 0.875 2.17875 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 143 1.4299999999999998e-37   NR MDP3509630.1 2052166 g11490 i0 92.6 0.975903614457831 81 6 97.6 0 244 2 219 299 MDP3509630.1 TerD family protein [Candidatus Melainabacteria bacterium] diamond 243 143 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
27773076 27773076 PRJNA549880_P_NODE_14244_length_244_cov_0.900585_g14151_i0 PRJNA549880 14244 244 0.900585 2.1974274 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 134 8.23e-37   NR MFA7336086.1 2364082 g14151 i0 91.3 0.983606557377049 80 7 98.4 0 3 242 24 103 MFA7336086.1 SRPBCC family protein [Candidatus Obscuribacterales bacterium] diamond 240 134 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
27850718 27850718 PRJNA549880_P_NODE_12264_length_248_cov_0.880000_g12171_i0 PRJNA549880 12264 248 0.88 2.1824 Bacillati 1783272 Bacteria Bacteria 82.4 4.32e-16   NR MBA4073970.1 2067979 g12171 i0 97.5 1.45161290322581 40 1 48.4 0 129 248 1 40 MBA4073970.1 hypothetical protein [Cyanobacteria bacterium PR.023] diamond 360 82.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium PR.023
28056920 28056920 PRJNA549880_P_NODE_9705_length_260_cov_1.524064_g9612_i0 PRJNA549880 9705 260 1.524064 3.9625664 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 54.3 3.08e-6   NR HEY9870685.1 2364082 g9612 i0 56.8 0.507692307692308 44 19 50.8 0 260 129 1 44 HEY9870685.1 tetratricopeptide repeat protein [Candidatus Obscuribacterales bacterium] diamond 132 54.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
29288325 29288325 PRJNA549880_P_NODE_15089_length_242_cov_0.911243_g14996_i0 PRJNA549880 15089 242 0.911243 2.20520806 Cyanobacteria bacterium PR.023 2067979 Bacteria Bacteria 107 2.61e-26   NR MBA4075935.1 2067979 g14996 i0 90.6 0.793388429752066 64 6 79.3 0 50 241 1 64 MBA4075935.1 hypothetical protein [Cyanobacteria bacterium PR.023] diamond 192 107 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium PR.023
29698503 29698503 PRJNA549880_P_NODE_8250_length_281_cov_1.471154_g8157_i0 PRJNA549880 8250 281 1.471154 4.13394274 Cyanobacteria bacterium PR.023 2067979 Bacteria Bacteria 175 9.57e-52   NR MBA4078679.1 2067979 g8157 i0 92.4 0.98220640569395 92 7 98.2 0 4 279 46 137 MBA4078679.1 hypothetical protein [Cyanobacteria bacterium PR.023] diamond 276 175 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium PR.023
30678055 30678055 PRJNA549880_P_NODE_9293_length_266_cov_1.564767_g9200_i0 PRJNA549880 9293 266 1.564767 4.16228022 Cyanobacteria bacterium PR.023 2067979 Bacteria Bacteria 176 1.62e-51   NR MBA4073988.1 2067979 g9200 i0 98.9 2.97744360902256 88 1 99.2 0 266 3 136 223 MBA4073988.1 serine--tRNA ligase [Cyanobacteria bacterium PR.023] diamond 792 176 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium PR.023
31626490 31626490 PRJNA549880_P_NODE_12756_length_247_cov_0.885057_g12663_i0 PRJNA549880 12756 247 0.885057 2.18609079 Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40 3070899 Bacteria Bacteria 87.8 5.56e-18   NR MDQ5934914.1 3070899 g12663 i0 68.2 0.801619433198381 66 21 80.2 0 2 199 573 638 MDQ5934914.1 hypothetical protein [Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40] diamond 198 87.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40
32638333 32638333 PRJNA549880_P_NODE_9720_length_260_cov_1.278075_g9627_i0 PRJNA549880 9720 260 1.278075 3.322995 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 134 3.2e-35   NR MFA6213298.1 2364082 g9627 i0 82.6 0.992307692307692 86 14 99.2 1 259 2 325 409 MFA6213298.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 258 134 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
32827580 32827580 PRJNA549880_P_NODE_12180_length_248_cov_0.880000_g12087_i0 PRJNA549880 12180 248 0.88 2.1824 Cyanobacteria bacterium PR.023 2067979 Bacteria Bacteria 158 5.439999999999999e-48   NR MBA4075194.1 2067979 g12087 i0 98.8 1.98387096774194 82 1 99.2 0 2 247 30 111 MBA4075194.1 hypothetical protein [Cyanobacteria bacterium PR.023] diamond 492 158 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium PR.023

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