contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax_phylum = "Candidatus Melainabacteria"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 364648 | 364648 | PRJNA168635_P_NODE_4761_length_386_cov_6.323442_g4357_i0 | PRJNA168635 | 4761 | 386 | 6.323442 | 24.40848612 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 388 | 2.47e-103 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g4357 | i0 | 85.333 | 43.9585492227979 | 375 | 55 | 97 | 0 | 1 | 375 | 3680796 | 3681170 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 16968 | 388 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 1639123 | 1639123 | PRJNA168635_P_NODE_12922_length_226_cov_2.169492_g12506_i0 | PRJNA168635 | 12922 | 226 | 2.169492 | 4.90305192 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 209 | 1.13e-49 | NTclustered | gi|2189472572|gb|CP091731.1| | 2052166 | g12506 | i0 | 84.651 | 313.734513274336 | 215 | 28 | 94 | 5 | 1 | 212 | 596080 | 595868 | MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome | blastn | 70904 | 209 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 1639147 | 1639147 | PRJNA168635_P_NODE_142_length_1440_cov_15.089145_g101_i0 | PRJNA168635 | 142 | 1440 | 15.089145 | 217.283688 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 634 | 1.1499999999999995e-176 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g101 | i0 | 78.969 | 414.901388888889 | 970 | 175 | 66 | 23 | 482 | 1437 | 3681237 | 3682191 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 597458 | 634 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 1639444 | 1639444 | PRJNA168635_P_NODE_3422_length_451_cov_23.945274_g3023_i0 | PRJNA168635 | 3422 | 451 | 23.945274 | 107.99318574 | Candidatus Melainabacteria bacterium MEL.A1 | 1899017 | Bacteria | Bacteria | 484 | 3.64e-132 | NTclustered | gi|1079475020|gb|CP017245.1| | 1899017 | g3023 | i0 | 86.414 | 369.578713968958 | 449 | 54 | 99 | 7 | 1 | 446 | 1477422 | 1477866 | Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome | blastn | 166680 | 484 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium MEL.A1 | |||||
| 2915318 | 2915318 | PRJNA168635_P_NODE_34143_length_155_cov_8.103774_g33727_i0 | PRJNA168635 | 34143 | 155 | 8.103774 | 12.5608497 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 150 | 4.3899999999999996e-32 | NTclustered | gi|2189472572|gb|CP091731.1| | 2052166 | g33727 | i0 | 88.095 | 460.432258064516 | 126 | 15 | 81 | 0 | 8 | 133 | 597343 | 597218 | MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome | blastn | 71367 | 150 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 6742090 | 6742090 | PRJNA168635_P_NODE_166_length_1382_cov_47.395349_g116_i0 | PRJNA168635 | 166 | 1382 | 47.395349 | 655.00372318 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 669 | 0 | NTclustered | gi|2189472572|gb|CP091731.1| | 2052166 | g116 | i0 | 76.02 | 657.002894356006 | 1422 | 268 | 100 | 68 | 1 | 1382 | 597430 | 598818 | MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome | blastn | 907978 | 669 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 8706889 | 8706889 | PRJNA168635_P_NODE_11167_length_245_cov_5.765306_g10752_i0 | PRJNA168635 | 11167 | 245 | 5.765306 | 14.1249997 | Bacteria | 2 | Bacteria | Bacteria | 204 | 5.77e-48 | NTclustered | gi|1079475020|gb|CP017245.1| | 1899017 | g10752 | i0 | 81.781 | 57.5469387755102 | 247 | 41 | 99 | 4 | 2 | 245 | 1478382 | 1478137 | Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome | blastn | 14099 | 204 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium MEL.A1 | |||||
| 10568344 | 10568344 | PRJNA168635_P_NODE_12409_length_231_cov_2.186813_g11993_i0 | PRJNA168635 | 12409 | 231 | 2.186813 | 5.05153803 | Candidatus Gastranaerophilales bacterium | 2137880 | Bacteria | Bacteria | 213 | 8.95e-51 | NTclustered | gi|2729058672|emb|OZ006972.1| | 2137880 | g11993 | i0 | 83.55 | 531.649350649351 | 231 | 35 | 99 | 3 | 1 | 230 | 512255 | 512027 | MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1 | blastn | 122811 | 213 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium | ||||
| 15667092 | 15667092 | PRJNA168635_P_NODE_11253_length_244_cov_4.753846_g10838_i0 | PRJNA168635 | 11253 | 244 | 4.753846 | 11.59938424 | Candidatus Gastranaerophilales bacterium | 2137880 | Bacteria | Bacteria | 316 | 7.069999999999998e-82 | NTclustered | gi|2729058672|emb|OZ006972.1| | 2137880 | g10838 | i0 | 90.417 | 96.905737704918 | 240 | 23 | 98 | 0 | 1 | 240 | 511267 | 511506 | MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1 | blastn | 23645 | 316 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium | ||||
| 16941661 | 16941661 | PRJNA168635_P_NODE_19654_length_183_cov_4.022388_g19238_i0 | PRJNA168635 | 19654 | 183 | 4.022388 | 7.36097004 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 73.1 | 1.2e-8 | NTclustered | gi|2189472572|gb|CP091731.1| | 2052166 | g19238 | i0 | 83.544 | 0.683060109289617 | 79 | 11 | 67 | 1 | 2 | 78 | 597352 | 597274 | MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome | blastn | 125 | 73.1 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 20765920 | 20765920 | PRJNA168635_P_NODE_15937_length_200_cov_10.801325_g15521_i0 | PRJNA168635 | 15937 | 200 | 10.801325 | 21.60265 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 185 | 1.64e-42 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g15521 | i0 | 83.415 | 138.24 | 205 | 28 | 100 | 5 | 1 | 200 | 3681959 | 3682162 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 27648 | 185 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 20766316 | 20766316 | PRJNA168635_P_NODE_8317_length_293_cov_1.872951_g7902_i0 | PRJNA168635 | 8317 | 293 | 1.872951 | 5.48774643 | Candidatus Gastranaerophilales bacterium | 2137880 | Bacteria | Bacteria | 183 | 9.229999999999998e-42 | NTclustered | gi|2729058672|emb|OZ006972.1| | 2137880 | g7902 | i0 | 79.771 | 303.877133105802 | 262 | 46 | 88 | 6 | 19 | 276 | 510101 | 510359 | MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1 | blastn | 89036 | 183 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium | ||||
| 21456022 | 21456022 | PRJNA168635_P_NODE_20537_length_180_cov_4.923664_g20121_i0 | PRJNA168635 | 20537 | 180 | 4.923664 | 8.8625952 | Bacteria | 2 | Bacteria | Bacteria | 243 | 8.439999999999999e-60 | NTclustered | gi|1079475020|gb|CP017245.1| | 1899017 | g20121 | i0 | 95.395 | 43.3666666666667 | 152 | 7 | 84 | 0 | 1 | 152 | 1478625 | 1478776 | Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome | blastn | 7806 | 244 | 0.995901639344262 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium MEL.A1 | |||||
| 22041091 | 22041091 | PRJNA168635_P_NODE_22698_length_174_cov_5.608000_g22282_i0 | PRJNA168635 | 22698 | 174 | 5.608 | 9.75792 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 172 | 1.08e-38 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g22282 | i0 | 87.097 | 0.890804597701149 | 155 | 16 | 88 | 4 | 15 | 167 | 197480 | 197632 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 155 | 172 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 23316397 | 23316397 | PRJNA168635_P_NODE_11159_length_245_cov_8.433673_g10744_i0 | PRJNA168635 | 11159 | 245 | 8.433673 | 20.66249885 | Candidatus Melainabacteria bacterium MEL.A1 | 1899017 | Bacteria | Bacteria | 344 | 3.26e-90 | NTclustered | gi|1079475020|gb|CP017245.1| | 1899017 | g10744 | i0 | 92.827 | 459.791836734694 | 237 | 17 | 97 | 0 | 5 | 241 | 1477950 | 1478186 | Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome | blastn | 112649 | 344 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium MEL.A1 | |||||
| 24590942 | 24590942 | PRJNA168635_P_NODE_400_length_1077_cov_13.024319_g101_i2 | PRJNA168635 | 400 | 1077 | 13.024319 | 140.27191563 | Candidatus Gastranaerophilales bacterium | 2137880 | Bacteria | Bacteria | 632 | 3.069999999999999e-176 | NTclustered | gi|2729058729|emb|OZ007029.1| | 2137880 | g101 | i2 | 77.86 | 149.043639740019 | 1075 | 201 | 98 | 35 | 25 | 1077 | 1222271 | 1223330 | MAG: Candidatus Gastranaerophilales bacterium isolate 6755_HET_CTRL_tig00013926_hicanu_large MAG genome assembly, chromosome: 1 | blastn | 160520 | 632 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium |
Advanced export
JSON shape: default, array, newline-delimited
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);;