contig_metadata
18 rows where bioproject = "PRJNA861969" and tax_clade = "Cyanobacteriota/Melainabacteria group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3397232 | 3397232 | PRJNA861969_P_NODE_34283_length_248_cov_0.880000_g34052_i0 | PRJNA861969 | 34283 | 248 | 0.88 | 2.1824 | uncultured Chroococcidiopsis sp. | 259957 | Bacteria | Bacteria | 363 | 9.119999999999997e-96 | NTclustered | gi|225696178|gb|FJ805845.1| | 259957 | g34052 | i0 | 93.802 | 174.713709677419 | 242 | 14 | 98 | 1 | 3 | 244 | 1581 | 1821 | Uncultured Chroococcidiopsis sp. clone AU1_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 43329 | 363 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Chroococcidiopsidales | Chroococcidiopsidaceae | Chroococcidiopsis | uncultured Chroococcidiopsis sp. | |
| 11050400 | 11050400 | PRJNA861969_P_NODE_9049_length_429_cov_1.780899_g8818_i0 | PRJNA861969 | 9049 | 429 | 1.780899 | 7.64005671 | uncultured Chroococcidiopsis sp. | 259957 | Bacteria | Bacteria | 551 | 3.349999999999999e-152 | NTclustered | gi|225696182|gb|FJ805849.1| | 259957 | g8818 | i0 | 90.118 | 166.030303030303 | 425 | 40 | 99 | 2 | 1 | 423 | 2277 | 1853 | Uncultured Chroococcidiopsis sp. clone AU1_8 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 71227 | 551 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Chroococcidiopsidales | Chroococcidiopsidaceae | Chroococcidiopsis | uncultured Chroococcidiopsis sp. | |
| 11440207 | 11440207 | PRJNA861969_P_NODE_23049_length_284_cov_1.459716_g22818_i0 | PRJNA861969 | 23049 | 284 | 1.459716 | 4.14559344 | Chroococcidiopsis | 54298 | Bacteria | Bacteria | 503 | 6.02e-138 | NTclustered | gi|428006994|gb|CP003597.1| | 251229 | g22818 | i0 | 98.592 | 2 | 284 | 4 | 100 | 0 | 1 | 284 | 2365786 | 2366069 | Chroococcidiopsis thermalis PCC 7203, complete genome | blastn | 568 | 503 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Chroococcidiopsidales | Chroococcidiopsidaceae | Chroococcidiopsis | Chroococcidiopsis thermalis | |
| 14874621 | 14874621 | PRJNA861969_P_NODE_41712_length_241_cov_0.916667_g41481_i0 | PRJNA861969 | 41712 | 241 | 0.916667 | 2.20916747 | Phormidium nigroviride | 482564 | Bacteria | Bacteria | 329 | 8.95e-86 | NTclustered | gi|428238862|gb|CP003614.1| | 179408 | g41481 | i0 | 91.322 | 3.90871369294606 | 242 | 20 | 100 | 1 | 1 | 241 | 6425198 | 6424957 | Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome | blastn | 942 | 329 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Oscillatoriales | Oscillatoriaceae | Phormidium | Phormidium nigroviride | |
| 25072375 | 25072375 | PRJNA861969_P_NODE_21220_length_294_cov_1.393665_g20989_i0 | PRJNA861969 | 21220 | 294 | 1.393665 | 4.0973751 | Nostoc sp. PCC 7524 | 28072 | Bacteria | Bacteria | 538 | 1.7199999999999995e-148 | NTclustered | gi|427363208|gb|CP003552.1| | 28072 | g20989 | i0 | 99.66 | 5.00680272108844 | 294 | 1 | 100 | 0 | 1 | 294 | 6008757 | 6009050 | Nostoc sp. PCC 7524, complete genome | blastn | 1472 | 538 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Nostocales | Nostocaceae | Nostoc | Nostoc sp. PCC 7524 | |
| 26770272 | 26770272 | PRJNA861969_P_NODE_26161_length_270_cov_1.563452_g25930_i0 | PRJNA861969 | 26161 | 270 | 1.563452 | 4.2213204 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 161 | 4.53e-44 | NR | MBX9672589.1 | 2364082 | g25930 | i0 | 100 | 0.988888888888889 | 89 | 0 | 98.9 | 0 | 269 | 3 | 409 | 497 | MBX9672589.1 serine/threonine protein kinase [Candidatus Obscuribacterales bacterium] | diamond | 267 | 161 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28097345 | 28097345 | PRJNA861969_P_NODE_5545_length_546_cov_2.114165_g5315_i0 | PRJNA861969 | 5545 | 546 | 2.114165 | 11.5433409 | Cyanobacteriota bacterium | 2847862 | Bacteria | Bacteria | 46.2 | 0.0324 | NR | MEW5820732.1 | 2847862 | g5315 | i0 | 35.1 | 0.423076923076923 | 77 | 50 | 42.3 | 0 | 440 | 210 | 144 | 220 | MEW5820732.1 SGNH/GDSL hydrolase family protein [Cyanobacteriota bacterium] | diamond | 231 | 46.2 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanobacteriota bacterium | |||||
| 28831635 | 28831635 | PRJNA861969_P_NODE_35588_length_247_cov_0.885057_g35357_i0 | PRJNA861969 | 35588 | 247 | 0.885057 | 2.18609079 | Spirulina | 1154 | Bacteria | Bacteria | 94.4 | 2.69e-20 | NR | NEO87136.1 | 2607816 | g35357 | i0 | 57.3 | 3.95951417004049 | 82 | 34 | 99.6 | 1 | 2 | 247 | 472 | 552 | NEO87136.1 GHKL domain-containing protein [Spirulina sp. SIO3F2] | diamond | 978 | 94.4 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Spirulinales | Spirulinaceae | Spirulina | Spirulina sp. SIO3F2 | |
| 29486421 | 29486421 | PRJNA861969_P_NODE_42290_length_233_cov_2.775000_g42059_i0 | PRJNA861969 | 42290 | 233 | 2.775 | 6.46575 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 74.7 | 3.33e-14 | NR | MBK9774186.1 | 2711154 | g42059 | i0 | 44.3 | 0.901287553648069 | 70 | 39 | 90.1 | 0 | 5 | 214 | 9 | 78 | MBK9774186.1 hypothetical protein [Candidatus Obscuribacter sp.] | diamond | 210 | 74.7 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 29644118 | 29644118 | PRJNA861969_P_NODE_25510_length_273_cov_1.540000_g25279_i0 | PRJNA861969 | 25510 | 273 | 1.54 | 4.2042 | Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40 | 3070899 | Bacteria | Bacteria | 182 | 5.11e-51 | NR | MDQ5937995.1 | 3070899 | g25279 | i0 | 98.9 | 1 | 91 | 1 | 100 | 0 | 273 | 1 | 371 | 461 | MDQ5937995.1 hypothetical protein [Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40] | diamond | 273 | 182 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40 | |||||
| 29675766 | 29675766 | PRJNA861969_P_NODE_22690_length_286_cov_1.446009_g22459_i0 | PRJNA861969 | 22690 | 286 | 1.446009 | 4.13558574 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 64.7 | 1.38e-10 | NR | MDR3614999.1 | 2364082 | g22459 | i0 | 56.6 | 1.6993006993007 | 53 | 23 | 55.6 | 0 | 285 | 127 | 100 | 152 | MDR3614999.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 486 | 64.7 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30023694 | 30023694 | PRJNA861969_P_NODE_26831_length_267_cov_1.484536_g26600_i0 | PRJNA861969 | 26831 | 267 | 1.484536 | 3.96371112 | Iningainema tapete | 2806730 | Bacteria | Bacteria | 51.6 | 4.04e-5 | NR | WP_190835607.1 | 2806730 | g26600 | i0 | 88.5 | 0.292134831460674 | 26 | 3 | 29.2 | 0 | 73 | 150 | 2085 | 2110 | WP_190835607.1 type I polyketide synthase [Iningainema tapete] | diamond | 78 | 51.6 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Nostocales | Scytonemataceae | Iningainema | Iningainema tapete | |
| 30031735 | 30031735 | PRJNA861969_P_NODE_36191_length_246_cov_0.890173_g35960_i0 | PRJNA861969 | 36191 | 246 | 0.890173 | 2.18982558 | Bacillati | 1783272 | Bacteria | Bacteria | 78.6 | 1.93e-15 | NR | MCC7528080.1 | 2052166 | g35960 | i0 | 82.1 | 1.92682926829268 | 39 | 7 | 47.6 | 0 | 244 | 128 | 208 | 246 | MCC7528080.1 response regulator transcription factor [Candidatus Melainabacteria bacterium] | diamond | 474 | 79.3 | 0.991172761664565 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 30189556 | 30189556 | PRJNA861969_P_NODE_31792_length_250_cov_0.870056_g31561_i0 | PRJNA861969 | 31792 | 250 | 0.870056 | 2.17514 | Cyanophyceae | 3028117 | Bacteria | Bacteria | 71.2 | 3.54e-12 | NR | WP_190595277.1 | 1162 | g31561 | i0 | 58.8 | 2.304 | 68 | 28 | 81.6 | 0 | 1 | 204 | 364 | 431 | WP_190595277.1 MULTISPECIES: glycosyltransferase [Nostocaceae] | diamond | 576 | 71.6 | 0.994413407821229 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Nostocales | Nostocaceae | |||
| 30876580 | 30876580 | PRJNA861969_P_NODE_31114_length_251_cov_0.865169_g30883_i0 | PRJNA861969 | 31114 | 251 | 0.865169 | 2.17157419 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 166 | 4.539999999999999e-46 | NR | PZM78708.1 | 2052166 | g30883 | i0 | 98.8 | 0.99203187250996006 | 83 | 1 | 99.2 | 0 | 2 | 250 | 235 | 317 | PZM78708.1 MAG: hypothetical protein DKT66_23540 [Candidatus Melainabacteria bacterium] | diamond | 249 | 166 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 31003041 | 31003041 | PRJNA861969_P_NODE_22654_length_286_cov_1.446009_g22423_i0 | PRJNA861969 | 22654 | 286 | 1.446009 | 4.13558574 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 99.8 | 5.7099999999999996e-24 | NR | MBP6348882.1 | 2711154 | g22423 | i0 | 86.8 | 0.555944055944056 | 53 | 7 | 55.6 | 0 | 160 | 2 | 6 | 58 | MBP6348882.1 gamma carbonic anhydrase family protein [Candidatus Obscuribacter sp.] | diamond | 159 | 99.8 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 31603788 | 31603788 | PRJNA861969_P_NODE_36476_length_246_cov_0.890173_g36245_i0 | PRJNA861969 | 36476 | 246 | 0.890173 | 2.18982558 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 73.6 | 5.28e-13 | NR | MBN9396211.1 | 2052166 | g36245 | i0 | 51.6 | 0.75609756097561 | 62 | 30 | 75.6 | 0 | 187 | 2 | 1 | 62 | MBN9396211.1 hypothetical protein [Candidatus Melainabacteria bacterium] | diamond | 186 | 73.6 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 32521515 | 32521515 | PRJNA861969_P_NODE_28799_length_258_cov_1.664865_g28568_i0 | PRJNA861969 | 28799 | 258 | 1.664865 | 4.2953517 | Nostoc ellipsosporum | 45916 | Bacteria | Bacteria | 102 | 6.5e-23 | NR | MDF2385032.1 | 2804519 | g28568 | i0 | 100 | 1 | 86 | 0 | 100 | 0 | 1 | 258 | 755 | 840 | MDF2385032.1 RHS repeat protein [Nostoc ellipsosporum NOK] | diamond | 258 | 102 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Nostocales | Nostocaceae | Nostoc | Nostoc ellipsosporum |
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);;