contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA599026" and tax_kingdom = "Fusobacteriati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8225163 | 8225163 | PRJNA599026_S_NODE_64847_length_163_cov_0.894737_g64391_i0 | PRJNA599026 | 64847 | 163 | 0.894737 | 1.45842131 | Cetobacterium | 180162 | Bacteria | Bacteria | 107 | 1.23e-25 | NR | WP_047381211.1 | 2630983 | g64391 | i0 | 98.1 | 1.98773006134969 | 54 | 1 | 99.4 | 0 | 162 | 1 | 24 | 77 | WP_047381211.1 MULTISPECIES: methylenetetrahydrofolate--tRNA-(uracil(54)-C(5))-methyltransferase (FADH(2)-oxidizing) TrmFO [unclassified Cetobacterium] | diamond | 324 | 107 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 26872039 | 26872039 | PRJNA599026_S_NODE_5201_length_418_cov_2.197832_g4746_i0 | PRJNA599026 | 5201 | 418 | 2.197832 | 9.18693776 | Cetobacterium | 180162 | Bacteria | Bacteria | 111 | 2.07e-25 | NR | WP_240220714.1 | 188913 | g4746 | i0 | 41.9 | 5.84928229665072 | 136 | 74 | 96.9 | 3 | 14 | 418 | 539 | 670 | WP_240220714.1 glycosyl hydrolase family 18 protein [Cetobacterium somerae] | diamond | 2445 | 111 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 27301226 | 27301226 | PRJNA599026_S_NODE_64523_length_163_cov_0.894737_g64067_i0 | PRJNA599026 | 64523 | 163 | 0.894737 | 1.45842131 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 107 | 1.7e-25 | NR | WP_294096797.1 | 527638 | g64067 | i0 | 100 | 0.993865030674847 | 54 | 0 | 99.4 | 0 | 1 | 162 | 200 | 253 | WP_294096797.1 ABC transporter substrate-binding protein [uncultured Cetobacterium sp.] | diamond | 162 | 107 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 27775020 | 27775020 | PRJNA599026_S_NODE_60624_length_164_cov_0.886957_g60168_i0 | PRJNA599026 | 60624 | 164 | 0.886957 | 1.45460948 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 107 | 3.03e-28 | NR | WP_047383851.1 | 2630983 | g60168 | i0 | 96.3 | 0.98780487804878 | 54 | 2 | 98.8 | 0 | 163 | 2 | 50 | 103 | WP_047383851.1 MULTISPECIES: hypothetical protein [unclassified Cetobacterium] | diamond | 162 | 107 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 28893098 | 28893098 | PRJNA599026_S_NODE_35908_length_189_cov_1.307143_g35452_i0 | PRJNA599026 | 35908 | 189 | 1.307143 | 2.47050027 | Cetobacterium | 180162 | Bacteria | Bacteria | 48.9 | 1.2e-4 | NR | WP_297599059.1 | 527638 | g35452 | i0 | 31.7 | 5 | 63 | 42 | 98.4 | 1 | 187 | 2 | 597 | 659 | WP_297599059.1 glycosyl hydrolase family 18 protein [uncultured Cetobacterium sp.] | diamond | 945 | 49.3 | 0.991886409736308 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 29398404 | 29398404 | PRJNA599026_S_NODE_1429_length_783_cov_3.735695_g1103_i0 | PRJNA599026 | 1429 | 783 | 3.735695 | 29.25049185 | Bacteria | 2 | Bacteria | Bacteria | 98.6 | 3.03e-19 | NR | WP_281833196.1 | 45622 | g1103 | i0 | 55.8 | 5.59386973180077 | 86 | 31 | 31.8 | 2 | 253 | 5 | 519 | 600 | WP_281833196.1 glycosyl hydrolase family 18 protein [Propionigenium maris] | diamond | 4380 | 98.6 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Propionigenium | Propionigenium maris | ||
| 30978012 | 30978012 | PRJNA599026_S_NODE_134_length_1979_cov_6.703627_g80_i0 | PRJNA599026 | 134 | 1979 | 6.703627 | 132.66477833 | Cetobacterium | 180162 | Bacteria | Bacteria | 424 | 5.53e-135 | NR | WP_240220714.1 | 188913 | g80 | i0 | 64.9 | 2.36634663971703 | 313 | 105 | 47.4 | 3 | 1239 | 301 | 449 | 756 | WP_240220714.1 glycosyl hydrolase family 18 protein [Cetobacterium somerae] | diamond | 4683 | 424 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 31470541 | 31470541 | PRJNA599026_S_NODE_60956_length_164_cov_0.886957_g60500_i0 | PRJNA599026 | 60956 | 164 | 0.886957 | 1.45460948 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 111 | 6.95e-27 | NR | WP_294095512.1 | 527638 | g60500 | i0 | 100 | 0.98780487804878 | 54 | 0 | 98.8 | 0 | 3 | 164 | 597 | 650 | WP_294095512.1 transcription-repair coupling factor [uncultured Cetobacterium sp.] | diamond | 162 | 111 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 32829541 | 32829541 | PRJNA599026_S_NODE_27800_length_207_cov_1.291139_g27344_i0 | PRJNA599026 | 27800 | 207 | 1.291139 | 2.67265773 | Fusobacteriaceae bacterium | 2053555 | Bacteria | Bacteria | 73.2 | 4.28e-13 | NR | MBN1469292.1 | 2053555 | g27344 | i0 | 55.1 | 8.01449275362319 | 69 | 29 | 97.1 | 1 | 2 | 202 | 615 | 683 | MBN1469292.1 endopeptidase La [Fusobacteriaceae bacterium] | diamond | 1659 | 73.2 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacteriaceae 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);;