contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA1016321" and tax_phylum = "Chloroflexota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10362327 | 10362327 | PRJNA1016321_P_NODE_10229_length_628_cov_3.120721_g10007_i0 | PRJNA1016321 | 10229 | 628 | 3.120721 | 19.59812788 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 365 | 6.84e-123 | NR | MEO8288921.1 | 2026724 | g10007 | i0 | 86.7 | 1.93949044585987 | 203 | 27 | 97 | 0 | 610 | 2 | 112 | 314 | MEO8288921.1 nucleotide sugar dehydrogenase [Chloroflexota bacterium] | diamond | 1218 | 365 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 26591397 | 26591397 | PRJNA1016321_P_NODE_18001_length_455_cov_3.523560_g17771_i0 | PRJNA1016321 | 18001 | 455 | 3.52356 | 16.032198 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 61.6 | 9.31e-8 | NR | MBE0696636.1 | 2024896 | g17771 | i0 | 34.7 | 1.5956043956044 | 118 | 71 | 77.8 | 3 | 376 | 23 | 85 | 196 | MBE0696636.1 DUF11 domain-containing protein [Anaerolineaceae bacterium] | diamond | 726 | 61.6 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 26741806 | 26741806 | PRJNA1016321_P_NODE_52041_length_246_cov_0.890173_g51810_i0 | PRJNA1016321 | 52041 | 246 | 0.890173 | 2.18982558 | Chloroflexota | 200795 | Bacteria | Bacteria | 92.4 | 8.26e-20 | NR | MBU1660369.1 | 2026724 | g51810 | i0 | 63.9 | 3.9390243902439 | 83 | 29 | 100 | 1 | 1 | 246 | 28 | 110 | MBU1660369.1 glycosyltransferase family 2 protein [Chloroflexota bacterium] | diamond | 969 | 93.2 | 0.991416309012876 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 26781785 | 26781785 | PRJNA1016321_P_NODE_23481_length_386_cov_1.437700_g23250_i0 | PRJNA1016321 | 23481 | 386 | 1.4377 | 5.549522 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 177 | 1.29e-53 | NR | MDX2140239.1 | 2026724 | g23250 | i0 | 78.3 | 0.893782383419689 | 115 | 25 | 89.4 | 0 | 349 | 5 | 6 | 120 | MDX2140239.1 cytochrome c oxidase subunit 3 [Chloroflexota bacterium] | diamond | 345 | 177 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28203262 | 28203262 | PRJNA1016321_P_NODE_55406_length_242_cov_0.911243_g55175_i0 | PRJNA1016321 | 55406 | 242 | 0.911243 | 2.20520806 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 47 | 5e-4 | NR | MBI3966067.1 | 2026724 | g55175 | i0 | 55.3 | 0.471074380165289 | 38 | 17 | 47.1 | 0 | 115 | 2 | 4 | 41 | MBI3966067.1 hypothetical protein [Chloroflexota bacterium] | diamond | 114 | 47 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28424629 | 28424629 | PRJNA1016321_P_NODE_21346_length_410_cov_1.753709_g21115_i0 | PRJNA1016321 | 21346 | 410 | 1.753709 | 7.1902069 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 137 | 2.96e-36 | NR | MCC6615191.1 | 2052143 | g21115 | i0 | 60.5 | 3.6219512195122 | 124 | 47 | 90.7 | 1 | 373 | 2 | 1 | 122 | MCC6615191.1 hypothetical protein [Anaerolineae bacterium] | diamond | 1485 | 137 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 28519348 | 28519348 | PRJNA1016321_P_NODE_25607_length_366_cov_1.501706_g25376_i0 | PRJNA1016321 | 25607 | 366 | 1.501706 | 5.49624396 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 127 | 7.4699999999999984e-34 | NR | GIL13638.1 | 2026724 | g25376 | i0 | 62 | 1.54098360655738 | 92 | 35 | 75.4 | 0 | 3 | 278 | 134 | 225 | GIL13638.1 MAG: hypothetical protein BroJett038_23580 [Chloroflexota bacterium] | diamond | 564 | 127 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28677205 | 28677205 | PRJNA1016321_P_NODE_50507_length_248_cov_0.880000_g50276_i0 | PRJNA1016321 | 50507 | 248 | 0.88 | 2.1824 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 134 | 1.2899999999999998e-35 | NR | MBX6770575.1 | 2026724 | g50276 | i0 | 67.9 | 1.95967741935484 | 81 | 26 | 98 | 0 | 245 | 3 | 260 | 340 | MBX6770575.1 beta-galactosidase [Chloroflexota bacterium] | diamond | 486 | 134 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28677206 | 28677206 | PRJNA1016321_P_NODE_53407_length_244_cov_1.204678_g53176_i0 | PRJNA1016321 | 53407 | 244 | 1.204678 | 2.93941432 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 133 | 5.55e-35 | NR | MFN8372163.1 | 2052143 | g53176 | i0 | 85.2 | 1.99180327868852 | 81 | 12 | 99.6 | 0 | 2 | 244 | 296 | 376 | MFN8372163.1 acyl-CoA dehydrogenase family protein [Anaerolineae bacterium] | diamond | 486 | 133 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 28803120 | 28803120 | PRJNA1016321_P_NODE_15128_length_504_cov_1.897912_g14899_i0 | PRJNA1016321 | 15128 | 504 | 1.897912 | 9.56547648 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 123 | 3.4499999999999996e-30 | NR | MCC6615191.1 | 2052143 | g14899 | i0 | 48.7 | 0.904761904761905 | 152 | 75 | 89.9 | 2 | 3 | 455 | 151 | 300 | MCC6615191.1 hypothetical protein [Anaerolineae bacterium] | diamond | 456 | 123 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 29561025 | 29561025 | PRJNA1016321_P_NODE_18450_length_449_cov_1.228723_g18220_i0 | PRJNA1016321 | 18450 | 449 | 1.228723 | 5.51696627 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 230 | 7.96e-72 | NR | MEO8287270.1 | 2026724 | g18220 | i0 | 79.7 | 2.90645879732739 | 143 | 29 | 95.5 | 0 | 430 | 2 | 207 | 349 | MEO8287270.1 galactokinase [Chloroflexota bacterium] | diamond | 1305 | 230 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29718788 | 29718788 | PRJNA1016321_P_NODE_48670_length_250_cov_0.870056_g48439_i0 | PRJNA1016321 | 48670 | 250 | 0.870056 | 2.17514 | Candidatus Trichofilum aggregatum | 3140686 | Bacteria | Bacteria | 74.7 | 2.33e-13 | NR | MBK9050966.1 | 3140686 | g48439 | i0 | 56 | 0.9 | 75 | 29 | 90 | 1 | 249 | 25 | 2242 | 2312 | MBK9050966.1 DUF4157 domain-containing protein [Candidatus Trichofilum aggregatum] | diamond | 225 | 74.7 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Candidatus Promineifilales | Candidatus Promineifilaceae | Candidatus Trichofilum | Candidatus Trichofilum aggregatum |
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);;