contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1126198" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4108131 | 4108131 | PRJNA1126198_P_NODE_143084_length_316_cov_2.444444_g142365_i0 | PRJNA1126198 | 143084 | 316 | 2.444444 | 7.72444304 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 248 | 3.5199999999999996e-61 | NTclustered | gi|2893358453|emb|OZ220745.1| | 2026734 | g142365 | i0 | 81.25 | 54.629746835443 | 320 | 48 | 100 | 9 | 1 | 316 | 2300156 | 2299845 | MAG: Dehalococcoidia bacterium isolate d99f35f8-e104-4752-81ca-da635d51ba71 genome assembly, chromosome: 1 | blastn | 17263 | 248 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 4108442 | 4108442 | PRJNA1126198_P_NODE_312404_length_263_cov_1.226316_g311683_i0 | PRJNA1126198 | 312404 | 263 | 1.226316 | 3.22521108 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 464 | 2.5999999999999993e-126 | NTclustered | gi|2874254102|emb|OY970185.1| | 1672391 | g311683 | i0 | 98.479 | 931.619771863118 | 263 | 4 | 100 | 0 | 1 | 263 | 1859871 | 1860133 | MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1 | blastn | 245016 | 464 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 5384913 | 5384913 | PRJNA1126198_P_NODE_449105_length_244_cov_0.906433_g448384_i0 | PRJNA1126198 | 449105 | 244 | 0.906433 | 2.21169652 | Anaerolineaceae bacterium oral taxon 439 | 1889813 | Bacteria | Bacteria | 446 | 8.639999999999999e-121 | NTclustered | gi|1061024832|gb|CP017039.1| | 1889813 | g448384 | i0 | 99.59 | 1 | 244 | 1 | 100 | 0 | 1 | 244 | 2491027 | 2491270 | Anaerolineaceae bacterium oral taxon 439 strain W11661 chromosome, complete genome | blastn | 244 | 446 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium oral taxon 439 | |||
| 11759702 | 11759702 | PRJNA1126198_P_NODE_162370_length_307_cov_1.965812_g161651_i0 | PRJNA1126198 | 162370 | 307 | 1.965812 | 6.03504284 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 470 | 6.67e-128 | NTclustered | gi|2874253981|emb|OY970306.1| | 1672391 | g161651 | i0 | 94.175 | 633.791530944625 | 309 | 16 | 100 | 2 | 1 | 307 | 1027573 | 1027265 | MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1 | blastn | 194574 | 470 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 15584613 | 15584613 | PRJNA1126198_P_NODE_446313_length_244_cov_0.912281_g445592_i0 | PRJNA1126198 | 446313 | 244 | 0.912281 | 2.22596564 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 422 | 1.46e-113 | NTclustered | gi|2874254102|emb|OY970185.1| | 1672391 | g445592 | i0 | 97.951 | 348.040983606557 | 244 | 3 | 100 | 2 | 1 | 244 | 1859468 | 1859227 | MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1 | blastn | 84922 | 422 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 18133318 | 18133318 | PRJNA1126198_P_NODE_396875_length_249_cov_0.886364_g396154_i0 | PRJNA1126198 | 396875 | 249 | 0.886364 | 2.20704636 | uncultured Caldilinea sp. | 435295 | Bacteria | Bacteria | 368 | 1.97e-97 | NTclustered | gi|443300639|gb|KC216670.1| | 435295 | g396154 | i0 | 95.652 | 99.0602409638554 | 230 | 8 | 92 | 2 | 1 | 229 | 229 | 1 | Uncultured Caldilinea sp. clone PBW-95 16S ribosomal RNA gene, partial sequence | blastn | 24666 | 368 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilinea | uncultured Caldilinea sp. | ||
| 21958327 | 21958327 | PRJNA1126198_P_NODE_370938_length_252_cov_0.865922_g370217_i0 | PRJNA1126198 | 370938 | 252 | 0.865922 | 2.18212344 | Anaerolineaceae bacterium oral taxon 439 | 1889813 | Bacteria | Bacteria | 455 | 1.49e-123 | NTclustered | gi|1061024832|gb|CP017039.1| | 1889813 | g370217 | i0 | 99.206 | 1 | 252 | 2 | 100 | 0 | 1 | 252 | 902986 | 902735 | Anaerolineaceae bacterium oral taxon 439 strain W11661 chromosome, complete genome | blastn | 252 | 455 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium oral taxon 439 | |||
| 23233948 | 23233948 | PRJNA1126198_P_NODE_402379_length_248_cov_1.697143_g401658_i0 | PRJNA1126198 | 402379 | 248 | 1.697143 | 4.20891464 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 207 | 4.52e-49 | NTclustered | gi|2874254133|emb|OY970218.1| | 1672391 | g401658 | i0 | 82.627 | 0.951612903225806 | 236 | 39 | 95 | 2 | 9 | 243 | 811044 | 811278 | MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1 | blastn | 236 | 207 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia 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);;