contig_metadata
18 rows where bioproject = "PRJNA879067", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13607937 | 13607937 | PRJNA879067_P_NODE_20091_length_1006_cov_25.646302_g17164_i0 | PRJNA879067 | 20091 | 1006 | 25.646302 | 258.00179812 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 243 | 3.3699999999999993e-68 | NR | MBY0548177.1 | 2364082 | g17164 | i0 | 57.1 | 0.673956262425447 | 226 | 95 | 66.8 | 1 | 310 | 981 | 1769 | 1994 | MBY0548177.1 FHA domain-containing protein [Candidatus Obscuribacterales bacterium] | diamond | 678 | 243 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 21257860 | 21257860 | PRJNA879067_P_NODE_67717_length_401_cov_1.384146_g64232_i0 | PRJNA879067 | 67717 | 401 | 1.384146 | 5.55042546 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 407 | 7.119999999999999e-109 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g64232 | i0 | 88.596 | 228.640897755611 | 342 | 30 | 84 | 8 | 24 | 360 | 3682508 | 3682171 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 91685 | 407 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 27244869 | 27244869 | PRJNA879067_P_NODE_46563_length_555_cov_2.282158_g43093_i0 | PRJNA879067 | 46563 | 555 | 2.282158 | 12.6659769 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 187 | 2.6899999999999995e-57 | NR | MBX9570187.1 | 2364082 | g43093 | i0 | 65 | 0.864864864864865 | 160 | 54 | 86.5 | 2 | 531 | 52 | 14 | 171 | MBX9570187.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Candidatus Obscuribacterales bacterium] | diamond | 480 | 187 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 27624133 | 27624133 | PRJNA879067_P_NODE_10864_length_1491_cov_16.449224_g8670_i0 | PRJNA879067 | 10864 | 1491 | 16.449224 | 245.25792984 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 328 | 2.88e-104 | NR | MBX9689351.1 | 2364082 | g8670 | i0 | 66.2 | 0.601609657947686 | 299 | 82 | 57.7 | 7 | 943 | 83 | 19 | 310 | MBX9689351.1 ARC6/PARC6 family protein [Candidatus Obscuribacterales bacterium] | diamond | 897 | 328 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 29360563 | 29360563 | PRJNA879067_P_NODE_111229_length_241_cov_0.904762_g107743_i0 | PRJNA879067 | 111229 | 241 | 0.904762 | 2.18047642 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 152 | 8.909999999999999e-45 | NR | MBN9395146.1 | 2052166 | g107743 | i0 | 98.7 | 0.983402489626556 | 79 | 1 | 98.3 | 0 | 239 | 3 | 27 | 105 | MBN9395146.1 hypothetical protein [Candidatus Melainabacteria bacterium] | diamond | 237 | 152 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 29549782 | 29549782 | PRJNA879067_P_NODE_93130_length_287_cov_1.079439_g89644_i0 | PRJNA879067 | 93130 | 287 | 1.079439 | 3.09798993 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 54.3 | 5.15e-6 | NR | MBX9573782.1 | 2364082 | g89644 | i0 | 62.5 | 0.418118466898955 | 40 | 15 | 41.8 | 0 | 42 | 161 | 16 | 55 | MBX9573782.1 sensor histidine kinase [Candidatus Obscuribacterales bacterium] | diamond | 120 | 54.3 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30181579 | 30181579 | PRJNA879067_P_NODE_97032_length_273_cov_1.540000_g93546_i0 | PRJNA879067 | 97032 | 273 | 1.54 | 4.2042 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 110 | 2.7200000000000003e-26 | NR | MBX9687395.1 | 2364082 | g93546 | i0 | 65.5 | 0.956043956043956 | 87 | 28 | 95.6 | 1 | 11 | 271 | 7 | 91 | MBX9687395.1 tetratricopeptide repeat protein [Candidatus Obscuribacterales bacterium] | diamond | 261 | 110 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30371673 | 30371673 | PRJNA879067_P_NODE_83032_length_326_cov_2.434783_g79546_i0 | PRJNA879067 | 83032 | 326 | 2.434783 | 7.93739258 | Candidatus Gastranaerophilales bacterium HUM_14 | 1916227 | Bacteria | Bacteria | 215 | 1.14e-67 | NR | DAB05452.1 | 1916227 | g79546 | i0 | 99 | 0.929447852760736 | 101 | 1 | 92.9 | 0 | 326 | 24 | 209 | 309 | DAB05452.1 MAG TPA: hypothetical protein CPT78_06925, partial [Candidatus Gastranaerophilales bacterium HUM_14] | diamond | 303 | 215 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium HUM_14 | ||||
| 30434745 | 30434745 | PRJNA879067_P_NODE_22073_length_944_cov_1.645235_g19046_i0 | PRJNA879067 | 22073 | 944 | 1.645235 | 15.5310184 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 336 | 2.5499999999999997e-106 | NR | MBX9689669.1 | 2364082 | g19046 | i0 | 56.5 | 0.994703389830508 | 313 | 105 | 99.5 | 4 | 944 | 6 | 387 | 668 | MBX9689669.1 DJ-1/PfpI family protein [Candidatus Obscuribacterales bacterium] | diamond | 939 | 336 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30908483 | 30908483 | PRJNA879067_P_NODE_11254_length_1460_cov_5.462870_g9009_i0 | PRJNA879067 | 11254 | 1460 | 5.46287 | 79.757902 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 341 | 9.76e-113 | NR | PZM80893.1 | 2052166 | g9009 | i0 | 100 | 0.336986301369863 | 164 | 0 | 33.7 | 0 | 1459 | 968 | 43 | 206 | PZM80893.1 MAG: hypothetical protein DKT66_16780 [Candidatus Melainabacteria bacterium] | diamond | 492 | 341 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 31097778 | 31097778 | PRJNA879067_P_NODE_49395_length_530_cov_1.295405_g45915_i0 | PRJNA879067 | 49395 | 530 | 1.295405 | 6.8656465 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 281 | 1.06e-91 | NR | MBX9573211.1 | 2364082 | g45915 | i0 | 74.1 | 0.984905660377358 | 174 | 45 | 98.5 | 0 | 522 | 1 | 28 | 201 | MBX9573211.1 amidohydrolase [Candidatus Obscuribacterales bacterium] | diamond | 522 | 281 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31129152 | 31129152 | PRJNA879067_P_NODE_50195_length_523_cov_3.508889_g46714_i0 | PRJNA879067 | 50195 | 523 | 3.508889 | 18.35148947 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 153 | 1.79e-39 | NR | MBX9877699.1 | 2364082 | g46714 | i0 | 54.6 | 0.998087954110899 | 174 | 76 | 98.1 | 3 | 9 | 521 | 17835 | 18008 | MBX9877699.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 522 | 153 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31129162 | 31129162 | PRJNA879067_P_NODE_99455_length_264_cov_2.183246_g95969_i0 | PRJNA879067 | 99455 | 264 | 2.183246 | 5.76376944 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 67.8 | 1.82e-12 | NR | MCC7531058.1 | 2052166 | g95969 | i0 | 57.6 | 0.670454545454545 | 59 | 25 | 67 | 0 | 87 | 263 | 2 | 60 | MCC7531058.1 hypothetical protein [Candidatus Melainabacteria bacterium] | diamond | 177 | 67.8 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 31192333 | 31192333 | PRJNA879067_P_NODE_66615_length_407_cov_2.374251_g63130_i0 | PRJNA879067 | 66615 | 407 | 2.374251 | 9.66320157 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 49.3 | 0.00104 | NR | HEY9792523.1 | 2364082 | g63130 | i0 | 33.3 | 0.685503685503685 | 93 | 60 | 68.6 | 1 | 395 | 117 | 338 | 428 | HEY9792523.1 tetratricopeptide repeat protein [Candidatus Obscuribacterales bacterium] | diamond | 279 | 49.3 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31540736 | 31540736 | PRJNA879067_P_NODE_96976_length_273_cov_2.050000_g93490_i0 | PRJNA879067 | 96976 | 273 | 2.05 | 5.5965 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 67.4 | 1.12e-10 | NR | MBX9687678.1 | 2364082 | g93490 | i0 | 47.8 | 0.758241758241758 | 69 | 36 | 75.8 | 0 | 273 | 67 | 412 | 480 | MBX9687678.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 207 | 67.4 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31667047 | 31667047 | PRJNA879067_P_NODE_75737_length_358_cov_2.884211_g72251_i0 | PRJNA879067 | 75737 | 358 | 2.884211 | 10.32547538 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 122 | 1.11e-29 | NR | MBX9688356.1 | 2364082 | g72251 | i0 | 61.8 | 0.921787709497207 | 110 | 41 | 92.2 | 1 | 330 | 1 | 43 | 151 | MBX9688356.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 330 | 122 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31762009 | 31762009 | PRJNA879067_P_NODE_98317_length_268_cov_3.148718_g94831_i0 | PRJNA879067 | 98317 | 268 | 3.148718 | 8.43856424 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 89.4 | 2.09e-18 | NR | MBX9688463.1 | 2364082 | g94831 | i0 | 45.9 | 0.951492537313433 | 85 | 46 | 95.1 | 0 | 256 | 2 | 268 | 352 | MBX9688463.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 255 | 89.4 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 32300256 | 32300256 | PRJNA879067_P_NODE_111199_length_241_cov_0.916667_g107713_i0 | PRJNA879067 | 111199 | 241 | 0.916667 | 2.20916747 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 161 | 4.2399999999999995e-45 | NR | MBN9393999.1 | 2052166 | g107713 | i0 | 100 | 0.983402489626556 | 79 | 0 | 98.3 | 0 | 3 | 239 | 364 | 442 | MBN9393999.1 L-glutamate gamma-semialdehyde dehydrogenase [Candidatus Melainabacteria bacterium] | diamond | 237 | 161 | 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);;