contig_metadata
6 rows where bioproject = "PRJNA781427", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9688800 | 9688800 | PRJNA781427_P_NODE_3008_length_1615_cov_1.822309_g2717_i0 | PRJNA781427 | 3008 | 1615 | 1.822309 | 29.43029035 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 54.7 | 0.046 | NTclustered | gi|2621703510|emb|OY762557.1| | 2910168 | g2717 | i0 | 100 | 0.0179566563467492 | 29 | 0 | 2 | 0 | 1410 | 1438 | 2565353 | 2565381 | MAG: Longimicrobiales bacterium isolate c10e2151-7d97-4465-9cf7-a78a4796a63d genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 19887851 | 19887851 | PRJNA781427_P_NODE_54856_length_302_cov_1.397380_g53973_i0 | PRJNA781427 | 54856 | 302 | 1.39738 | 4.2200876 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 501 | 2.32e-137 | NTclustered | gi|2874253728|emb|OY969570.1| | 412054 | g53973 | i0 | 96.7 | 260.5 | 303 | 7 | 100 | 2 | 1 | 302 | 2237631 | 2237331 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 | blastn | 78671 | 501 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 19887934 | 19887934 | PRJNA781427_P_NODE_57936_length_293_cov_0.959091_g57052_i0 | PRJNA781427 | 57936 | 293 | 0.959091 | 2.81013663 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 446 | 1.07e-120 | NTclustered | gi|2874253728|emb|OY969570.1| | 412054 | g57052 | i0 | 94.218 | 76.3378839590444 | 294 | 14 | 100 | 2 | 1 | 293 | 172749 | 172458 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 | blastn | 22367 | 446 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 21164565 | 21164565 | PRJNA781427_P_NODE_94137_length_242_cov_0.911243_g93253_i0 | PRJNA781427 | 94137 | 242 | 0.911243 | 2.20520806 | Pseudogemmatithrix spongiicola | 3062599 | Bacteria | Bacteria | 147 | 9.72e-31 | NTclustered | gi|2557479348|gb|CP130613.1| | 3062599 | g93253 | i0 | 96.591 | 21.5206611570248 | 88 | 3 | 36 | 0 | 155 | 242 | 1549492 | 1549579 | Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome | blastn | 5208 | 147 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Pseudogemmatithrix | Pseudogemmatithrix spongiicola | |
| 28758857 | 28758857 | PRJNA781427_P_NODE_67667_length_267_cov_1.500000_g66783_i0 | PRJNA781427 | 67667 | 267 | 1.5 | 4.005 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 129 | 7.690000000000001e-36 | NR | MEJ2152439.1 | 2026742 | g66783 | i0 | 70.2 | 0.943820224719101 | 84 | 25 | 94.4 | 0 | 2 | 253 | 65 | 148 | MEJ2152439.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 252 | 129 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30053440 | 30053440 | PRJNA781427_P_NODE_93891_length_242_cov_0.911243_g93007_i0 | PRJNA781427 | 93891 | 242 | 0.911243 | 2.20520806 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 42.7 | 0.0343 | NR | HKP15771.1 | 2026741 | g93007 | i0 | 41.3 | 0.78099173553719 | 63 | 31 | 73.1 | 2 | 63 | 239 | 200 | 260 | HKP15771.1 tRNA pseudouridine(55) synthase TruB [Gemmatimonadaceae bacterium] | diamond | 189 | 42.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae 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);;