contig_metadata
8 rows where bioproject = "PRJNA206070" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26725375 | 26725375 | PRJNA206070_S_NODE_6341_length_582_cov_7.730275_g4504_i0 | PRJNA206070 | 6341 | 582 | 7.730275 | 44.9902005 | Fibrobacter sp. | 35828 | Bacteria | Bacteria | 153 | 1.38e-40 | NR | MCF0225529.1 | 35828 | g4504 | i0 | 62.5 | 0.618556701030928 | 120 | 44 | 61.9 | 1 | 362 | 3 | 207 | 325 | MCF0225529.1 hypothetical protein [Fibrobacter sp.] | diamond | 360 | 153 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter sp. | |
| 27217919 | 27217919 | PRJNA206070_S_NODE_31142_length_151_cov_1.982456_g29266_i0 | PRJNA206070 | 31142 | 151 | 1.982456 | 2.99350856 | Fibrobacter | 832 | Bacteria | Bacteria | 55.8 | 2.42e-7 | NR | WP_073304425.1 | 28122 | g29266 | i0 | 56 | 2.98013245033113 | 50 | 20 | 97.4 | 2 | 2 | 148 | 143 | 191 | WP_073304425.1 hypothetical protein [Fibrobacter intestinalis] | diamond | 450 | 55.8 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter intestinalis | |
| 27484779 | 27484779 | PRJNA206070_S_NODE_9003_length_418_cov_3.905512_g7130_i0 | PRJNA206070 | 9003 | 418 | 3.905512 | 16.32504016 | Fibrobacter sp. | 35828 | Bacteria | Bacteria | 135 | 1.37e-34 | NR | MCF0225529.1 | 35828 | g7130 | i0 | 50.4 | 0.997607655502392 | 139 | 69 | 99.8 | 0 | 2 | 418 | 7 | 145 | MCF0225529.1 hypothetical protein [Fibrobacter sp.] | diamond | 417 | 135 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter sp. | |
| 28337288 | 28337288 | PRJNA206070_S_NODE_5786_length_638_cov_3.131448_g3969_i0 | PRJNA206070 | 5786 | 638 | 3.131448 | 19.97863824 | uncultured Fibrobacter sp. | 261512 | Bacteria | Bacteria | 51.6 | 9.71e-4 | NR | WP_295001965.1 | 261512 | g3969 | i0 | 29.9 | 0.785266457680251 | 167 | 90 | 72.4 | 7 | 88 | 549 | 229 | 381 | WP_295001965.1 ATP-binding domain-containing protein [uncultured Fibrobacter sp.] | diamond | 501 | 51.6 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | uncultured Fibrobacter sp. | |
| 30484775 | 30484775 | PRJNA206070_S_NODE_5313_length_698_cov_3.239032_g3526_i0 | PRJNA206070 | 5313 | 698 | 3.239032 | 22.60844336 | Fibrobacter sp. | 35828 | Bacteria | Bacteria | 278 | 1.62e-88 | NR | MBR6450493.1 | 35828 | g3526 | i0 | 60.3 | 2.99140401146132 | 232 | 91 | 99.3 | 1 | 4 | 696 | 55 | 286 | MBR6450493.1 hypothetical protein [Fibrobacter sp.] | diamond | 2088 | 278 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter sp. | |
| 30642526 | 30642526 | PRJNA206070_S_NODE_2873_length_1648_cov_4.723774_g1521_i0 | PRJNA206070 | 2873 | 1648 | 4.723774 | 77.84779552 | uncultured Fibrobacter sp. | 261512 | Bacteria | Bacteria | 187 | 3.0299999999999996e-47 | NR | WP_295001966.1 | 261512 | g1521 | i0 | 29.6 | 0.762742718446602 | 419 | 274 | 74.5 | 12 | 1234 | 8 | 140 | 547 | WP_295001966.1 DUF5906 domain-containing protein [uncultured Fibrobacter sp.] | diamond | 1257 | 187 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | uncultured Fibrobacter sp. | |
| 31843875 | 31843875 | PRJNA206070_S_NODE_8117_length_459_cov_5.611374_g6246_i0 | PRJNA206070 | 8117 | 459 | 5.611374 | 25.75620666 | Fibrobacter sp. | 35828 | Bacteria | Bacteria | 75.5 | 4.59e-13 | NR | NLB64271.1 | 35828 | g6246 | i0 | 40.7 | 1.37908496732026 | 108 | 61 | 68.6 | 1 | 95 | 409 | 155 | 262 | NLB64271.1 sigma-70 family RNA polymerase sigma factor [Fibrobacter sp.] | diamond | 633 | 75.5 | 1 | Bacteria | FCB group | Pseudomonadati | Fibrobacterota | Fibrobacteria | Fibrobacterales | Fibrobacteraceae | Fibrobacter | Fibrobacter sp. | |
| 32746837 | 32746837 | PRJNA206070_S_NODE_6880_length_537_cov_22.614000_g5024_i0 | PRJNA206070 | 6880 | 537 | 22.614 | 121.43718 | root | 1 | Root_unresolved | Root_unresolved | 151 | 9.679999999999997e-43 | NR | WP_288800649.1 | 261512 | g5024 | i0 | 54.3 | 3.10055865921788 | 138 | 61 | 77.1 | 2 | 94 | 507 | 55 | 190 | WP_288800649.1 hypothetical protein [uncultured Fibrobacter sp.] | diamond | 1665 | 151 | 1 | 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);;