contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA944406" and tax_phylum = "Fibrobacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 924230 | 924230 | PRJNA944406_P_NODE_16521_length_318_cov_1.346939_g15562_i0 | PRJNA944406 | 16521 | 318 | 1.346939 | 4.28326602 | uncultured Fibrobacteria bacterium | 1758207 | Bacteria | Bacteria | 399 | 9.239999999999998e-107 | NTclustered | gi|2874253984|emb|OY970309.1| | 1758207 | g15562 | i0 | 89.557 | 333.874213836478 | 316 | 32 | 99 | 1 | 4 | 318 | 1596898 | 1596583 | MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1 | blastn | 106172 | 399 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | uncultured Fibrobacteria bacterium | ||||
| 3475773 | 3475773 | PRJNA944406_P_NODE_9123_length_412_cov_1.410029_g8164_i0 | PRJNA944406 | 9123 | 412 | 1.410029 | 5.80931948 | uncultured Fibrobacteria bacterium | 1758207 | Bacteria | Bacteria | 494 | 5.47e-135 | NTclustered | gi|2874253984|emb|OY970309.1| | 1758207 | g8164 | i0 | 88.221 | 229.958737864078 | 416 | 45 | 100 | 3 | 1 | 412 | 1594430 | 1594015 | MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1 | blastn | 94743 | 494 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | uncultured Fibrobacteria bacterium | ||||
| 16227677 | 16227677 | PRJNA944406_P_NODE_60113_length_253_cov_3.422222_g59154_i0 | PRJNA944406 | 60113 | 253 | 3.422222 | 8.65822166 | uncultured Fibrobacteria bacterium | 1758207 | Bacteria | Bacteria | 294 | 3.45e-75 | NTclustered | gi|2874253984|emb|OY970309.1| | 1758207 | g59154 | i0 | 87.795 | 297.541501976285 | 254 | 28 | 99 | 3 | 2 | 253 | 1593963 | 1594215 | MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1 | blastn | 75278 | 294 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | uncultured Fibrobacteria bacterium | ||||
| 16227813 | 16227813 | PRJNA944406_P_NODE_7433_length_461_cov_1.801546_g6477_i0 | PRJNA944406 | 7433 | 461 | 1.801546 | 8.30512706 | uncultured Fibrobacteria bacterium | 1758207 | Bacteria | Bacteria | 377 | 6.499999999999999e-100 | NTclustered | gi|2874253984|emb|OY970309.1| | 1758207 | g6477 | i0 | 81.974 | 104.119305856833 | 466 | 65 | 99 | 17 | 1 | 455 | 1593960 | 1594417 | MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1 | blastn | 47999 | 377 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | uncultured Fibrobacteria bacterium | ||||
| 22601916 | 22601916 | PRJNA944406_P_NODE_6838_length_484_cov_1.656934_g5882_i0 | PRJNA944406 | 6838 | 484 | 1.656934 | 8.01956056 | uncultured Fibrobacteria bacterium | 1758207 | Bacteria | Bacteria | 569 | 1.0499999999999997e-157 | NTclustered | gi|2874253984|emb|OY970309.1| | 1758207 | g5882 | i0 | 87.91 | 99.4235537190083 | 488 | 53 | 100 | 6 | 1 | 484 | 1595798 | 1595313 | MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1 | blastn | 48121 | 569 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | uncultured Fibrobacteria bacterium | ||||
| 25150475 | 25150475 | PRJNA944406_P_NODE_16860_length_315_cov_4.252066_g15901_i0 | PRJNA944406 | 16860 | 315 | 4.252066 | 13.3940079 | uncultured Fibrobacteria bacterium | 1758207 | Bacteria | Bacteria | 357 | 5.58e-94 | NTclustered | gi|2874253984|emb|OY970309.1| | 1758207 | g15901 | i0 | 88.814 | 154.015873015873 | 295 | 28 | 93 | 5 | 1 | 293 | 1595126 | 1594835 | MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1 | blastn | 48515 | 357 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | uncultured Fibrobacteria 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);;