contig_metadata
5 rows where bioproject = "PRJNA429937", tax_clade = "FCB group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 425927 | 425927 | PRJNA429937_P_NODE_141921_length_202_cov_3.069364_g119294_i0 | PRJNA429937 | 141921 | 202 | 3.069364 | 6.20011528 | uncultured Fibrobacteria bacterium | 1758207 | Bacteria | Bacteria | 176 | 1e-39 | NTclustered | gi|2874253984|emb|OY970309.1| | 1758207 | g119294 | i0 | 95.455 | 285.59900990099 | 110 | 5 | 54 | 0 | 93 | 202 | 1595598 | 1595707 | MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1 | blastn | 57691 | 176 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | uncultured Fibrobacteria bacterium | ||||
| 13180484 | 13180484 | PRJNA429937_P_NODE_46191_length_525_cov_3.262097_g29811_i0 | PRJNA429937 | 46191 | 525 | 3.262097 | 17.12600925 | uncultured Fibrobacteria bacterium | 1758207 | Bacteria | Bacteria | 311 | 7.69e-80 | NTclustered | gi|2874253984|emb|OY970309.1| | 1758207 | g29811 | i0 | 83.095 | 177.407619047619 | 349 | 52 | 95 | 7 | 7 | 351 | 1595461 | 1595116 | MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1 | blastn | 93139 | 311 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | uncultured Fibrobacteria bacterium | ||||
| 15729219 | 15729219 | PRJNA429937_P_NODE_34433_length_618_cov_2.757216_g21309_i0 | PRJNA429937 | 34433 | 618 | 2.757216 | 17.03959488 | uncultured Fibrobacteria bacterium | 1758207 | Bacteria | Bacteria | 311 | 9.16e-80 | NTclustered | gi|2874253984|emb|OY970309.1| | 1758207 | g21309 | i0 | 83.095 | 144.778317152104 | 349 | 52 | 78 | 7 | 163 | 507 | 1595116 | 1595461 | MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1 | blastn | 89473 | 311 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | uncultured Fibrobacteria bacterium | ||||
| 23377634 | 23377634 | PRJNA429937_P_NODE_101379_length_298_cov_3.122677_g78767_i0 | PRJNA429937 | 101379 | 298 | 3.122677 | 9.30557746 | uncultured Fibrobacteria bacterium | 1758207 | Bacteria | Bacteria | 180 | 1.22e-40 | NTclustered | gi|2874253984|emb|OY970309.1| | 1758207 | g78767 | i0 | 95.536 | 191.862416107383 | 112 | 5 | 59 | 0 | 11 | 122 | 1595598 | 1595709 | MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1 | blastn | 57175 | 180 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | uncultured Fibrobacteria bacterium | ||||
| 29018869 | 29018869 | PRJNA429937_P_NODE_47008_length_519_cov_7.344898_g30441_i0 | PRJNA429937 | 47008 | 519 | 7.344898 | 38.12002062 | root | 1 | Root_unresolved | Root_unresolved | 64.3 | 1.94e-8 | NR | WP_295056764.1 | 261512 | g30441 | i0 | 60.4 | 0.826589595375723 | 48 | 19 | 27.7 | 0 | 517 | 374 | 11 | 58 | WP_295056764.1 BspA family leucine-rich repeat surface protein [uncultured Fibrobacter sp.] | diamond | 429 | 64.7 | 0.993817619783617 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | uncultured Fibrobacter sp. |
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);;