contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax_phylum = "Candidatus Peregrinibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4191365 | 4191365 | PRJNA168635_P_NODE_10884_length_249_cov_9.060000_g10469_i0 | PRJNA168635 | 10884 | 249 | 9.06 | 22.5594 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 294 | 3.39e-75 | NTclustered | gi|2258829869|gb|CP060224.1| | 2053688 | g10469 | i0 | 90.541 | 164.265060240964 | 222 | 21 | 89 | 0 | 1 | 222 | 787375 | 787596 | MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-8 chromosome | blastn | 40902 | 294 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 6742491 | 6742491 | PRJNA168635_P_NODE_9706_length_267_cov_5.834862_g9291_i0 | PRJNA168635 | 9706 | 267 | 5.834862 | 15.57908154 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 141 | 5.070000000000001e-29 | NTclustered | gi|2258832001|gb|CP060225.1| | 2053688 | g9291 | i0 | 77.872 | 1.29962546816479 | 235 | 46 | 86 | 4 | 39 | 267 | 626721 | 626487 | MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-9 chromosome, complete genome | blastn | 347 | 141 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 15667638 | 15667638 | PRJNA168635_P_NODE_9533_length_270_cov_2.018100_g9118_i0 | PRJNA168635 | 9533 | 270 | 2.0181 | 5.44887 | Candidatus Peregrinibacteria bacterium | 2030811 | Bacteria | Bacteria | 377 | 3.59e-100 | NTclustered | gi|2874254110|emb|OY970195.1| | 2030811 | g9118 | i0 | 94.309 | 117.962962962963 | 246 | 14 | 91 | 0 | 16 | 261 | 379528 | 379283 | MAG: Candidatus Peregrinibacteria bacterium isolate MFD02416.bin.c.20 genome assembly, chromosome: 1 | blastn | 31850 | 377 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium | ||||||
| 16941848 | 16941848 | PRJNA168635_P_NODE_31714_length_162_cov_1.725664_g31298_i0 | PRJNA168635 | 31714 | 162 | 1.725664 | 2.79557568 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 117 | 4.71e-22 | NTclustered | gi|2258832001|gb|CP060225.1| | 2053688 | g31298 | i0 | 80.12 | 1.02469135802469 | 166 | 26 | 98 | 4 | 4 | 162 | 626669 | 626504 | MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-9 chromosome, complete genome | blastn | 166 | 117 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 18216156 | 18216156 | PRJNA168635_P_NODE_19435_length_184_cov_1.970370_g19019_i0 | PRJNA168635 | 19435 | 184 | 1.97037 | 3.6254808 | Candidatus Peribacter riflensis | 1735162 | Bacteria | Bacteria | 193 | 8.86e-45 | NTclustered | gi|946529367|gb|CP013062.1| | 1735162 | g19019 | i0 | 90.541 | 5.55434782608696 | 148 | 11 | 80 | 3 | 1 | 147 | 1195581 | 1195436 | MAG: Candidatus Peribacter riflensis, complete genome | blastn | 1022 | 193 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacter | Candidatus Peribacter riflensis | |||
| 19490604 | 19490604 | PRJNA168635_P_NODE_34536_length_154_cov_3.828571_g34120_i0 | PRJNA168635 | 34536 | 154 | 3.828571 | 5.89599934 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 154 | 3.37e-33 | NTclustered | gi|2258833497|gb|CP060226.1| | 2053688 | g34120 | i0 | 85.065 | 94.7792207792208 | 154 | 19 | 99 | 4 | 1 | 152 | 813268 | 813419 | MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome | blastn | 14596 | 154 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 22041178 | 22041178 | PRJNA168635_P_NODE_28438_length_165_cov_4.422414_g28022_i0 | PRJNA168635 | 28438 | 165 | 4.422414 | 7.2969831 | Candidatus Peribacter riflensis | 1735162 | Bacteria | Bacteria | 71.3 | 3.81e-8 | NTclustered | gi|946529367|gb|CP013062.1| | 1735162 | g28022 | i0 | 100 | 1.71515151515152 | 38 | 0 | 23 | 0 | 127 | 164 | 1195651 | 1195614 | MAG: Candidatus Peribacter riflensis, complete genome | blastn | 283 | 71.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacter | Candidatus Peribacter riflensis | |||
| 24590680 | 24590680 | PRJNA168635_P_NODE_19200_length_185_cov_1.676471_g18784_i0 | PRJNA168635 | 19200 | 185 | 1.676471 | 3.10147135 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 278 | 2.39e-70 | NTclustered | gi|2258833497|gb|CP060226.1| | 2053688 | g18784 | i0 | 96.429 | 10.5027027027027 | 168 | 6 | 91 | 0 | 6 | 173 | 813112 | 812945 | MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome | blastn | 1943 | 278 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 24590822 | 24590822 | PRJNA168635_P_NODE_28460_length_165_cov_3.801724_g28044_i0 | PRJNA168635 | 28460 | 165 | 3.801724 | 6.2728446 | Candidatus Peregrinibacteria bacterium | 2030811 | Bacteria | Bacteria | 185 | 1.3e-42 | NTclustered | gi|1958006436|gb|CP064962.1| | 2030811 | g28044 | i0 | 93.548 | 404.545454545455 | 124 | 8 | 75 | 0 | 42 | 165 | 212180 | 212303 | MAG: Candidatus Peregrinibacteria bacterium isolate Aved_18-Q3-R54-62_BAT3C.344 chromosome, complete genome | blastn | 66750 | 185 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium | ||||||
| 24590883 | 24590883 | PRJNA168635_P_NODE_32760_length_160_cov_3.675676_g32344_i0 | PRJNA168635 | 32760 | 160 | 3.675676 | 5.8810816 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 204 | 3.459999999999999e-48 | NTclustered | gi|2258833497|gb|CP060226.1| | 2053688 | g32344 | i0 | 90.385 | 15.9875 | 156 | 14 | 98 | 1 | 5 | 160 | 814142 | 814296 | MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome | blastn | 2558 | 204 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria 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);;