contig_metadata
6 rows where bioproject = "PRJNA1063685", tax_clade = "FCB group" and tax_phylum = "Rhodothermota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12933291 | 12933291 | PRJNA1063685_S_NODE_3331_length_798_cov_18.845517_g2936_i0 | PRJNA1063685 | 3331 | 798 | 18.845517 | 150.38722566 | Rhodothermales bacterium | 2306054 | Bacteria | Bacteria | 332 | 2.11e-111 | NR | HMB89744.1 | 2306054 | g2936 | i0 | 62 | 1.97744360902256 | 263 | 98 | 98.9 | 1 | 1 | 789 | 22 | 282 | HMB89744.1 SDR family oxidoreductase [Rhodothermales bacterium] | diamond | 1578 | 332 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermales bacterium | |||
| 16756638 | 16756638 | PRJNA1063685_S_NODE_52014_length_310_cov_4.194093_g51471_i0 | PRJNA1063685 | 52014 | 310 | 4.194093 | 13.0016883 | Rhodothermales bacterium | 2306054 | Bacteria | Bacteria | 348 | 3.3e-91 | NTclustered | gi|2893358395|emb|OZ220686.1| | 2306054 | g51471 | i0 | 88.316 | 102.01935483871 | 291 | 32 | 94 | 2 | 1 | 290 | 1667115 | 1667404 | MAG: Rhodothermales bacterium isolate 312d6c01-350c-491a-87ad-f3958f88b76c genome assembly, chromosome: 1 | blastn | 31626 | 348 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermales bacterium | |||
| 16756776 | 16756776 | PRJNA1063685_S_NODE_74694_length_240_cov_3.257485_g74151_i0 | PRJNA1063685 | 74694 | 240 | 3.257485 | 7.817964 | Rhodothermales bacterium | 2306054 | Bacteria | Bacteria | 219 | 2.0099999999999998e-52 | NTclustered | gi|2621702557|emb|OY760427.1| | 2306054 | g74151 | i0 | 84.932 | 186.995833333333 | 219 | 30 | 90 | 3 | 25 | 240 | 5500783 | 5501001 | MAG: Rhodothermales bacterium isolate 1504ddc0-b432-43e2-af37-a45191a88aeb genome assembly, chromosome: 1 | blastn | 44879 | 219 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermales bacterium | |||
| 18031292 | 18031292 | PRJNA1063685_S_NODE_39675_length_370_cov_2.925926_g39132_i0 | PRJNA1063685 | 39675 | 370 | 2.925926 | 10.8259262 | uncultured Rubrivirga sp. | 1699421 | Bacteria | Bacteria | 608 | 1.6599999999999992e-169 | NTclustered | gi|2795020992|gb|PQ250471.1| | 1699421 | g39132 | i0 | 98 | 93.827027027027 | 350 | 7 | 95 | 0 | 17 | 366 | 67 | 416 | Uncultured Rubrivirga sp. clone OTU616 16S ribosomal RNA gene, partial sequence | blastn | 34716 | 608 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rubricoccaceae | Rubrivirga | uncultured Rubrivirga sp. | |
| 19305230 | 19305230 | PRJNA1063685_S_NODE_29236_length_434_cov_8.362881_g28694_i0 | PRJNA1063685 | 29236 | 434 | 8.362881 | 36.29490354 | Rubricoccaceae bacterium | 2838334 | Bacteria | Bacteria | 462 | 1.6299999999999998e-125 | NTclustered | gi|2874254104|emb|OY970187.1| | 2838334 | g28694 | i0 | 89.037 | 408.73732718894 | 374 | 39 | 86 | 2 | 28 | 399 | 1309431 | 1309058 | MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1 | blastn | 177392 | 462 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rubricoccaceae | Rubricoccaceae bacterium | ||
| 27383302 | 27383302 | PRJNA1063685_S_NODE_74123_length_241_cov_5.041667_g73580_i0 | PRJNA1063685 | 74123 | 241 | 5.041667 | 12.15041747 | Rhodothermales bacterium | 2306054 | Bacteria | Bacteria | 80.5 | 1.79e-15 | NR | HMB91192.1 | 2306054 | g73580 | i0 | 54 | 1.69294605809129 | 63 | 28 | 77.2 | 1 | 191 | 6 | 160 | 222 | HMB91192.1 serine protease [Rhodothermales bacterium] | diamond | 408 | 80.5 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermales 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);;