contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA498309" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 481209 | 481209 | PRJNA498309_P_NODE_66681_length_298_cov_18.555556_g64533_i0 | PRJNA498309 | 66681 | 298 | 18.555556 | 55.29555688 | Candidatus Saccharibacteria bacterium oral taxon 488 | 713059 | Bacteria | Bacteria | 78.7 | 4.57e-10 | NTclustered | gi|1663050868|gb|CP040003.1| | 713059 | g64533 | i0 | 95.833 | 3.70805369127517 | 48 | 2 | 16 | 0 | 22 | 69 | 682114 | 682067 | Candidatus Saccharibacteria bacterium oral taxon 488 strain AC001 chromosome, complete genome | blastn | 1105 | 78.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 1757444 | 1757444 | PRJNA498309_S_NODE_39242_length_217_cov_372.395604_g37074_i0 | PRJNA498309 | 39242 | 217 | 372.395604 | 808.09846068 | candidate division SR1 bacterium RAAC1_SR1_1 | 1394709 | Bacteria | Bacteria | 161 | 3.05e-35 | NTclustered | gi|563351663|gb|CP006913.1| | 1394709 | g37074 | i0 | 82.873 | 45.6267281105991 | 181 | 29 | 83 | 2 | 1 | 180 | 125727 | 125906 | Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome | blastn | 9901 | 161 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium RAAC1_SR1_1 | ||||||
| 4309452 | 4309452 | PRJNA498309_S_NODE_53144_length_154_cov_1.462185_g50976_i0 | PRJNA498309 | 53144 | 154 | 1.462185 | 2.2517649 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | 1619070 | Bacteria | Bacteria | 154 | 3.37e-33 | NTclustered | gi|837350690|gb|CP011211.1| | 1619070 | g50976 | i0 | 85.621 | 80.7402597402597 | 153 | 14 | 97 | 6 | 2 | 150 | 850051 | 849903 | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome | blastn | 12434 | 154 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 | ||||||
| 6858037 | 6858037 | PRJNA498309_P_NODE_18666_length_675_cov_6.844828_g16891_i0 | PRJNA498309 | 18666 | 675 | 6.844828 | 46.202589 | Candidatus Nanosynbacter sp. HMT-352 | 2899133 | Bacteria | Bacteria | 93.5 | 3.96e-14 | NTclustered | gi|2218409032|gb|CP089290.1| | 2899133 | g16891 | i0 | 85.556 | 5.39111111111111 | 90 | 11 | 13 | 2 | 466 | 554 | 164791 | 164879 | Candidatus Nanosynbacter sp. HMT-352 strain TM7-001 chromosome | blastn | 3639 | 93.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. HMT-352 | ||
| 10684836 | 10684836 | PRJNA498309_P_NODE_65109_length_305_cov_2.529851_g62961_i0 | PRJNA498309 | 65109 | 305 | 2.529851 | 7.71604555 | uncultured Methylomirabilota bacterium | 991135 | Bacteria | Bacteria | 73.1 | 2.18e-8 | NTclustered | gi|2874253892|emb|OY970067.1| | 991135 | g62961 | i0 | 85.507 | 0.226229508196721 | 69 | 10 | 23 | 0 | 198 | 266 | 241345 | 241413 | MAG: uncultured candidate division NC10 bacterium isolate MFD01231.bin.c.1 genome assembly, chromosome: 1 | blastn | 69 | 73.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | uncultured Methylomirabilota bacterium | ||||||
| 13234909 | 13234909 | PRJNA498309_P_NODE_6191_length_1287_cov_13.224800_g5028_i0 | PRJNA498309 | 6191 | 1287 | 13.2248 | 170.203176 | candidate division SR1 bacterium RAAC1_SR1_1 | 1394709 | Bacteria | Bacteria | 1042 | 0 | NTclustered | gi|563351663|gb|CP006913.1| | 1394709 | g5028 | i0 | 82.898 | 137.776223776224 | 1187 | 175 | 91 | 27 | 94 | 1265 | 126091 | 124918 | Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome | blastn | 177318 | 1042 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium RAAC1_SR1_1 | ||||||
| 14510469 | 14510469 | PRJNA498309_P_NODE_99052_length_196_cov_2.440252_g96903_i0 | PRJNA498309 | 99052 | 196 | 2.440252 | 4.78289392 | TM7 phylum sp. oral taxon 349 | 713051 | Bacteria | Bacteria | 147 | 7.56e-31 | NTclustered | gi|2028829559|gb|CP072328.1| | 713051 | g96903 | i0 | 80.729 | 0.979591836734694 | 192 | 34 | 97 | 3 | 3 | 192 | 26819 | 27009 | TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome | blastn | 192 | 147 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | TM7 phylum sp. oral taxon 349 | ||||||
| 15785314 | 15785314 | PRJNA498309_S_NODE_6633_length_1081_cov_42.605163_g5134_i0 | PRJNA498309 | 6633 | 1081 | 42.605163 | 460.56181203 | candidate division SR1 bacterium RAAC1_SR1_1 | 1394709 | Bacteria | Bacteria | 728 | 0 | NTclustered | gi|563351663|gb|CP006913.1| | 1394709 | g5134 | i0 | 82.118 | 97.5235892691952 | 878 | 131 | 100 | 25 | 1 | 864 | 125766 | 124901 | Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome | blastn | 105423 | 728 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium RAAC1_SR1_1 | ||||||
| 23433816 | 23433816 | PRJNA498309_P_NODE_80099_length_250_cov_2.676056_g77950_i0 | PRJNA498309 | 80099 | 250 | 2.676056 | 6.69014 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 147 | 1.01e-30 | NTclustered | gi|1950821269|gb|CP066696.1| | 2026720 | g77950 | i0 | 93.069 | 9.46 | 101 | 5 | 40 | 2 | 88 | 188 | 38289 | 38387 | Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome | blastn | 2365 | 147 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 23434062 | 23434062 | PRJNA498309_P_NODE_96899_length_201_cov_8.829268_g94750_i0 | PRJNA498309 | 96899 | 201 | 8.829268 | 17.74682868 | Candidatus Absconditicoccus praedator | 2735562 | Bacteria | Bacteria | 171 | 4.6299999999999996e-38 | NTclustered | gi|2160621446|gb|CP054059.1| | 2735562 | g94750 | i0 | 84.27 | 297.114427860697 | 178 | 25 | 87 | 2 | 26 | 200 | 728820 | 728643 | Candidatus Absconditicoccus praedator strain M39-6 chromosome, complete genome | blastn | 59720 | 171 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditicoccaceae | Candidatus Absconditicoccus | Candidatus Absconditicoccus praedator |
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);;