contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1002570" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1426837 | 1426837 | PRJNA1002570_P_NODE_15342_length_310_cov_3.514768_g15147_i0 | PRJNA1002570 | 15342 | 310 | 3.514768 | 10.8957808 | Candidatus Promineifilum breve | 1806508 | Bacteria | Bacteria | 185 | 2.7399999999999998e-42 | NTclustered | gi|1041165931|emb|LN890655.2| | 1806508 | g15147 | i0 | 77.023 | 4.24193548387097 | 309 | 62 | 98 | 7 | 4 | 308 | 1221583 | 1221280 | Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I | blastn | 1315 | 185 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Candidatus Promineifilales | Candidatus Promineifilaceae | Candidatus Promineifilum | Candidatus Promineifilum breve | ||
| 3978971 | 3978971 | PRJNA1002570_P_NODE_43584_length_241_cov_4.178571_g43389_i0 | PRJNA1002570 | 43584 | 241 | 4.178571 | 10.07035611 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 246 | 9.27e-61 | NTclustered | gi|2874253788|emb|OY969772.1| | 1672391 | g43389 | i0 | 86.076 | 14.3070539419087 | 237 | 23 | 96 | 10 | 10 | 241 | 861105 | 861336 | MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1 | blastn | 3448 | 246 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 10355457 | 10355457 | PRJNA1002570_P_NODE_24709_length_280_cov_1.487923_g24514_i0 | PRJNA1002570 | 24709 | 280 | 1.487923 | 4.1661844 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 267 | 8.46e-67 | NTclustered | gi|2874253725|emb|OY969567.1| | 1672391 | g24514 | i0 | 84.364 | 52.0285714285714 | 275 | 39 | 97 | 4 | 1 | 272 | 1192704 | 1192431 | MAG: uncultured Chloroflexia bacterium isolate MFD01561.bin.c.1 genome assembly, chromosome: 1 | blastn | 14568 | 267 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 10355552 | 10355552 | PRJNA1002570_P_NODE_30629_length_265_cov_5.276042_g30434_i0 | PRJNA1002570 | 30629 | 265 | 5.276042 | 13.9815113 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 137 | 6.5e-28 | NTclustered | gi|2874253860|emb|OY969916.1| | 1672391 | g30434 | i0 | 91.837 | 68.7358490566038 | 98 | 8 | 37 | 0 | 1 | 98 | 8074594 | 8074691 | MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 | blastn | 18215 | 137 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 10355833 | 10355833 | PRJNA1002570_P_NODE_5649_length_460_cov_1.989664_g5455_i0 | PRJNA1002570 | 5649 | 460 | 1.989664 | 9.1524544 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 63.9 | 2.06e-5 | NTclustered | gi|2556906889|gb|CP129483.1| | 2073117 | g5455 | i0 | 97.368 | 0.0826086956521739 | 38 | 0 | 8 | 1 | 299 | 335 | 1284278 | 1284241 | MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome | blastn | 38 | 63.9 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 14181279 | 14181279 | PRJNA1002570_P_NODE_45592_length_228_cov_3.451613_g45397_i0 | PRJNA1002570 | 45592 | 228 | 3.451613 | 7.86967764 | Roseiflexus sp. RS-1 | 357808 | Bacteria | Bacteria | 87.9 | 5.57e-13 | NTclustered | gi|148566298|gb|CP000686.1| | 357808 | g45397 | i0 | 86.25 | 2.51315789473684 | 80 | 11 | 35 | 0 | 28 | 107 | 4091248 | 4091169 | Roseiflexus sp. RS-1, complete genome | blastn | 573 | 87.9 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexus | Roseiflexus sp. RS-1 | ||
| 23104769 | 23104769 | PRJNA1002570_P_NODE_41059_length_245_cov_0.895349_g40864_i0 | PRJNA1002570 | 41059 | 245 | 0.895349 | 2.19360505 | uncultured Dehalococcoidia bacterium | 498747 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|2531949168|emb|OY282456.1| | 498747 | g40864 | i0 | 100 | 0.118367346938776 | 29 | 0 | 12 | 0 | 184 | 212 | 3251686 | 3251714 | MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | uncultured Dehalococcoidia bacterium | |||||
| 23104811 | 23104811 | PRJNA1002570_P_NODE_43759_length_241_cov_1.785714_g43564_i0 | PRJNA1002570 | 43759 | 241 | 1.785714 | 4.30357074 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 58.4 | 4.66e-4 | NTclustered | gi|2621702680|emb|OY759581.1| | 2026734 | g43564 | i0 | 97.143 | 6.19502074688797 | 35 | 0 | 14 | 1 | 168 | 201 | 2533414 | 2533448 | MAG: Dehalococcoidia bacterium isolate 65a5fbfc-6c1a-4510-92bc-3c45fb3a16c9 genome assembly, chromosome: 1 | blastn | 1493 | 58.4 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia 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);;