contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA827593" and tax_clade = "Bacteria candidate phyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12707806 | 12707806 | PRJNA827593_P_NODE_12450_length_619_cov_2.587912_g12158_i0 | PRJNA827593 | 12450 | 619 | 2.587912 | 16.01917528 | Bacteria | 2 | Bacteria | Bacteria | 130 | 2.76e-25 | NTclustered | gi|2518596736|emb|OX639992.1| | 265321 | g12158 | i0 | 94.186 | 14.7124394184168 | 86 | 4 | 14 | 1 | 478 | 562 | 4485286 | 4485371 | MAG: uncultured Poribacteria bacterium isolate 2342930e-25dc-453b-b24c-d77caf5257d8 genome assembly, chromosome: 1 | blastn | 9107 | 130 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | uncultured Poribacteria bacterium | ||||||
| 16123677 | 16123677 | PRJNA827593_P_NODE_31633_length_367_cov_1.370748_g31334_i0 | PRJNA827593 | 31633 | 367 | 1.370748 | 5.03064516 | Candidatus Roizmanbacteria bacterium | 2282149 | Bacteria | Bacteria | 56.5 | 0.003 | NTclustered | gi|1950818454|gb|CP066689.1| | 2282149 | g31334 | i0 | 97.059 | 0.0926430517711172 | 34 | 0 | 9 | 1 | 270 | 303 | 109135 | 109103 | MAG: Candidatus Roizmanbacteria bacterium isolate NC_groundwater_538_Ag_S-0.1um_35_236 chromosome | blastn | 34 | 56.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Roizmaniibacteriota | Candidatus Roizmanbacteria bacterium | ||||||
| 17399217 | 17399217 | PRJNA827593_P_NODE_21194_length_460_cov_2.224806_g20896_i0 | PRJNA827593 | 21194 | 460 | 2.224806 | 10.2341076 | Candidatus Woesebacteria bacterium | 2026804 | Bacteria | Bacteria | 56.5 | 0.003 | NTclustered | gi|1876390488|gb|CP058602.1| | 2026804 | g20896 | i0 | 97.059 | 0.0739130434782609 | 34 | 0 | 7 | 1 | 93 | 125 | 107614 | 107647 | MAG: Candidatus Woesebacteria bacterium isolate Ch104c chromosome, complete genome | blastn | 34 | 56.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium | ||||||
| 17806003 | 17806003 | PRJNA827593_P_NODE_57934_length_259_cov_2.301075_g57635_i0 | PRJNA827593 | 57934 | 259 | 2.301075 | 5.95978425 | Bacteria | 2 | Bacteria | Bacteria | 446 | 9.26e-121 | NTclustered | gi|1950821269|gb|CP066696.1| | 2026720 | g57635 | i0 | 97.683 | 109.602316602317 | 259 | 6 | 100 | 0 | 1 | 259 | 800363 | 800621 | Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome | blastn | 28387 | 446 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 19080088 | 19080088 | PRJNA827593_P_NODE_62515_length_249_cov_0.875000_g62216_i0 | PRJNA827593 | 62515 | 249 | 0.875 | 2.17875 | Bacteria | 2 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2874254068|emb|OY970151.1| | 179883 | g62216 | i0 | 100 | 0.903614457831325 | 30 | 0 | 12 | 0 | 23 | 52 | 126899 | 126928 | MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD00082.bin.2.65 genome assembly, chromosome: 1 | blastn | 225 | 56.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | uncultured Candidatus Saccharibacteria bacterium | ||||||
| 19947312 | 19947312 | PRJNA827593_P_NODE_13556_length_591_cov_1.965251_g13261_i0 | PRJNA827593 | 13556 | 591 | 1.965251 | 11.61463341 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 158 | 1.2e-33 | NTclustered | gi|1950821269|gb|CP066696.1| | 2026720 | g13261 | i0 | 100 | 9.17258883248731 | 85 | 0 | 15 | 0 | 268 | 352 | 461418 | 461334 | Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome | blastn | 5421 | 158 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 21223425 | 21223425 | PRJNA827593_P_NODE_4817_length_1036_cov_2.959502_g4584_i0 | PRJNA827593 | 4817 | 1036 | 2.959502 | 30.66044072 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 161 | 1.67e-34 | NTclustered | gi|1474570736|gb|CP023991.1| | 2026720 | g4584 | i0 | 97.849 | 1.72104247104247 | 93 | 2 | 9 | 0 | 765 | 857 | 568223 | 568131 | Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome | blastn | 1783 | 161 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 23773464 | 23773464 | PRJNA827593_P_NODE_28619_length_388_cov_2.333333_g28320_i0 | PRJNA827593 | 28619 | 388 | 2.333333 | 9.05333204 | uncultured Candidatus Saccharibacteria bacterium | 179883 | Bacteria | Bacteria | 100 | 1.31e-16 | NTclustered | gi|2874254068|emb|OY970151.1| | 179883 | g28320 | i0 | 95.238 | 0.713917525773196 | 63 | 3 | 16 | 0 | 36 | 98 | 559906 | 559968 | MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD00082.bin.2.65 genome assembly, chromosome: 1 | blastn | 277 | 100 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | uncultured Candidatus Saccharibacteria 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);;