contig_metadata
18 rows where bioproject = "PRJNA724011", tax_clade = "Cyanobacteriota/Melainabacteria group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16013476 | 16013476 | PRJNA724011_P_NODE_88893_length_259_cov_3.258065_g87870_i0 | PRJNA724011 | 88893 | 259 | 3.258065 | 8.43838835 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 353 | 5.77e-93 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g87870 | i0 | 91.288 | 154.841698841699 | 264 | 16 | 100 | 6 | 1 | 259 | 3682167 | 3681906 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 40104 | 353 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 23663633 | 23663633 | PRJNA724011_P_NODE_37519_length_439_cov_5.136612_g36496_i0 | PRJNA724011 | 37519 | 439 | 5.136612 | 22.54972668 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 326 | 2.26e-84 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g36496 | i0 | 80.653 | 48.9635535307517 | 429 | 76 | 97 | 7 | 15 | 439 | 3682248 | 3682673 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 21495 | 326 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 27399938 | 27399938 | PRJNA724011_P_NODE_36163_length_450_cov_0.867374_g35140_i0 | PRJNA724011 | 36163 | 450 | 0.867374 | 3.903183 | Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11 | 1801609 | Bacteria | Bacteria | 51.6 | 2.07e-4 | NR | OGI09100.1 | 1801609 | g35140 | i0 | 37.3 | 0.446666666666667 | 67 | 37 | 44.7 | 1 | 295 | 95 | 103 | 164 | OGI09100.1 MAG: hypothetical protein A3F80_00030 [Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11] | diamond | 201 | 51.6 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11 | |||||
| 27399942 | 27399942 | PRJNA724011_P_NODE_39003_length_429_cov_0.946629_g37980_i0 | PRJNA724011 | 39003 | 429 | 0.946629 | 4.06103841 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 139 | 1.0299999999999999e-38 | NR | MBL8086383.1 | 2711154 | g37980 | i0 | 78.4 | 0.615384615384615 | 88 | 18 | 61.5 | 1 | 353 | 90 | 57 | 143 | MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] | diamond | 264 | 139 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 27747296 | 27747296 | PRJNA724011_P_NODE_18264_length_695_cov_2.329582_g17264_i0 | PRJNA724011 | 18264 | 695 | 2.329582 | 16.1905949 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 184 | 8.38e-52 | NR | MBL0186718.1 | 2711154 | g17264 | i0 | 51.7 | 5.41294964028777 | 180 | 71 | 77.7 | 3 | 2 | 541 | 284 | 447 | MBL0186718.1 allantoinase AllB [Candidatus Obscuribacter sp.] | diamond | 3762 | 184 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 28315532 | 28315532 | PRJNA724011_P_NODE_41166_length_414_cov_0.882698_g40143_i0 | PRJNA724011 | 41166 | 414 | 0.882698 | 3.65436972 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 110 | 1.27e-27 | NR | MBL8086383.1 | 2711154 | g40143 | i0 | 76 | 0.543478260869565 | 75 | 14 | 51.4 | 1 | 2 | 214 | 67 | 141 | MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] | diamond | 225 | 110 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 28757430 | 28757430 | PRJNA724011_P_NODE_63307_length_319_cov_1.585366_g62284_i0 | PRJNA724011 | 63307 | 319 | 1.585366 | 5.05731754 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 52 | 4.89e-5 | NR | MFA6209845.1 | 2364082 | g62284 | i0 | 30.5 | 0.893416927899687 | 95 | 63 | 88.4 | 2 | 284 | 3 | 452 | 544 | MFA6209845.1 FAD-dependent monooxygenase [Candidatus Obscuribacterales bacterium] | diamond | 285 | 52 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28915135 | 28915135 | PRJNA724011_P_NODE_87108_length_263_cov_1.563158_g86085_i0 | PRJNA724011 | 87108 | 263 | 1.563158 | 4.11110554 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 101 | 1.12e-24 | NR | MBL8086383.1 | 2711154 | g86085 | i0 | 72.9 | 0.798479087452472 | 70 | 15 | 75.3 | 1 | 5 | 202 | 75 | 144 | MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] | diamond | 210 | 101 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 29641202 | 29641202 | PRJNA724011_P_NODE_42050_length_408_cov_1.367164_g41027_i0 | PRJNA724011 | 42050 | 408 | 1.367164 | 5.57802912 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 56.2 | 2.73e-6 | NR | HEY9814218.1 | 2364082 | g41027 | i0 | 36.6 | 0.742647058823529 | 101 | 61 | 72.8 | 2 | 371 | 75 | 103 | 202 | HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 303 | 56.2 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30052027 | 30052027 | PRJNA724011_P_NODE_76151_length_286_cov_1.211268_g75128_i0 | PRJNA724011 | 76151 | 286 | 1.211268 | 3.46422648 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 132 | 4.9000000000000005e-34 | NR | MBI3591625.1 | 2052166 | g75128 | i0 | 71.8 | 7.20629370629371 | 85 | 24 | 89.2 | 0 | 32 | 286 | 4 | 88 | MBI3591625.1 dihydropyrimidinase [Candidatus Melainabacteria bacterium] | diamond | 2061 | 132 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 30241851 | 30241851 | PRJNA724011_P_NODE_85492_length_266_cov_1.595855_g84469_i0 | PRJNA724011 | 85492 | 266 | 1.595855 | 4.2449743 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 58.2 | 1.93e-8 | NR | MBZ0187479.1 | 2364082 | g84469 | i0 | 47 | 1.59022556390977 | 66 | 27 | 74.4 | 2 | 26 | 223 | 60 | 117 | MBZ0187479.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 423 | 58.2 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30305335 | 30305335 | PRJNA724011_P_NODE_24692_length_571_cov_3.339357_g23676_i0 | PRJNA724011 | 24692 | 571 | 3.339357 | 19.06772847 | Vampirovibrionales bacterium | 2692181 | Bacteria | Bacteria | 168 | 5.64e-46 | NR | MDH4379041.1 | 2692181 | g23676 | i0 | 62.8 | 0.677758318739054 | 129 | 45 | 67.8 | 1 | 388 | 2 | 18 | 143 | MDH4379041.1 IMP dehydrogenase [Vampirovibrionales bacterium] | diamond | 387 | 168 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Vampirovibriophyceae | Vampirovibrionales | Vampirovibrionales bacterium | |||
| 30778916 | 30778916 | PRJNA724011_P_NODE_74694_length_289_cov_1.425926_g73671_i0 | PRJNA724011 | 74694 | 289 | 1.425926 | 4.12092614 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 72.4 | 3.55e-13 | NR | MBX9771135.1 | 2364082 | g73671 | i0 | 50 | 0.747404844290657 | 72 | 35 | 74.7 | 1 | 289 | 74 | 98 | 168 | MBX9771135.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 216 | 72.4 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31000066 | 31000066 | PRJNA724011_P_NODE_20594_length_643_cov_2.873684_g19583_i0 | PRJNA724011 | 20594 | 643 | 2.873684 | 18.47778812 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 53.9 | 7.46e-5 | NR | HIA53992.1 | 2052166 | g19583 | i0 | 34.5 | 1.23639191290824 | 87 | 57 | 40.6 | 0 | 226 | 486 | 120 | 206 | HIA53992.1 tetratricopeptide repeat protein [Candidatus Melainabacteria bacterium] | diamond | 795 | 53.9 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 32075293 | 32075293 | PRJNA724011_P_NODE_59638_length_330_cov_2.322957_g58615_i0 | PRJNA724011 | 59638 | 330 | 2.322957 | 7.6657581 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 83.2 | 2.42e-18 | NR | MBL8086371.1 | 2711154 | g58615 | i0 | 98.2 | 0.518181818181818 | 57 | 1 | 51.8 | 0 | 283 | 113 | 1 | 57 | MBL8086371.1 hypothetical protein [Candidatus Obscuribacter sp.] | diamond | 171 | 83.2 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 32106818 | 32106818 | PRJNA724011_P_NODE_107518_length_242_cov_1.497041_g106495_i0 | PRJNA724011 | 107518 | 242 | 1.497041 | 3.62283922 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 73.2 | 9.86e-14 | NR | MBX9771135.1 | 2364082 | g106495 | i0 | 66.7 | 0.669421487603306 | 54 | 18 | 66.9 | 0 | 3 | 164 | 139 | 192 | MBX9771135.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 162 | 73.2 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 32233767 | 32233767 | PRJNA724011_P_NODE_44278_length_395_cov_0.956522_g43255_i0 | PRJNA724011 | 44278 | 395 | 0.956522 | 3.7782619 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 50.4 | 2.91e-4 | NR | MCC7527304.1 | 2052166 | g43255 | i0 | 43.3 | 2.15696202531646 | 67 | 34 | 47.8 | 1 | 316 | 128 | 11 | 77 | MCC7527304.1 serine/threonine protein kinase [Candidatus Melainabacteria bacterium] | diamond | 852 | 50.4 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 32581643 | 32581643 | PRJNA724011_P_NODE_53579_length_351_cov_3.273381_g52556_i0 | PRJNA724011 | 53579 | 351 | 3.273381 | 11.48956731 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 142 | 1.36e-37 | NR | MDX2086181.1 | 2052166 | g52556 | i0 | 73.2 | 1.66666666666667 | 97 | 26 | 82.9 | 0 | 57 | 347 | 389 | 485 | MDX2086181.1 IMP dehydrogenase [Candidatus Melainabacteria bacterium] | diamond | 585 | 142 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria 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);;