contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA382558" and tax_phylum = "Acidobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1679661 | 1679661 | PRJNA382558_S_NODE_13782_length_157_cov_3.858333_g13778_i0 | PRJNA382558 | 13782 | 157 | 3.858333 | 6.05758281 | Geothrix sp. | 1962974 | Bacteria | Bacteria | 106 | 9.8e-19 | NTclustered | gi|2515262989|gb|CP126625.1| | 1962974 | g13778 | i0 | 93.056 | 5.07643312101911 | 72 | 5 | 46 | 0 | 1 | 72 | 715190 | 715261 | MAG: Geothrix sp. isolate L227-G1 chromosome, complete genome | blastn | 797 | 106 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagaceae | Geothrix | Geothrix sp. | ||
| 1679770 | 1679770 | PRJNA382558_S_NODE_5182_length_209_cov_7.837209_g5178_i0 | PRJNA382558 | 5182 | 209 | 7.837209 | 16.37976681 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 178 | 2.9e-40 | NTclustered | gi|2874253678|emb|OY969112.1| | 171953 | g5178 | i0 | 83.871 | 6.08612440191388 | 186 | 30 | 89 | 0 | 21 | 206 | 2738608 | 2738793 | MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1 | blastn | 1272 | 178 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 4232005 | 4232005 | PRJNA382558_S_NODE_16064_length_150_cov_4.345133_g16060_i0 | PRJNA382558 | 16064 | 150 | 4.345133 | 6.5176995 | uncultured Acidobacteriaceae bacterium | 194844 | Bacteria | Bacteria | 117 | 4.27e-22 | NTclustered | gi|2874254057|emb|OY970381.1| | 194844 | g16060 | i0 | 84.874 | 11.26 | 119 | 14 | 78 | 4 | 18 | 134 | 2148776 | 2148660 | MAG: uncultured Acidobacteriaceae bacterium isolate MFD04580.bin.1.19 genome assembly, chromosome: 1 | blastn | 1689 | 117 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | uncultured Acidobacteriaceae bacterium | |||
| 6782724 | 6782724 | PRJNA382558_S_NODE_8666_length_180_cov_8.216783_g8662_i0 | PRJNA382558 | 8666 | 180 | 8.216783 | 14.7902094 | Thermoanaerobaculaceae bacterium | 2699758 | Bacteria | Bacteria | 161 | 2.43e-35 | NTclustered | gi|2874254005|emb|OY970330.1| | 2699758 | g8662 | i0 | 86.806 | 39.1444444444444 | 144 | 19 | 80 | 0 | 1 | 144 | 8565646 | 8565503 | MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1 | blastn | 7046 | 161 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculales | Thermoanaerobaculaceae | Thermoanaerobaculaceae bacterium | |||
| 8058261 | 8058261 | PRJNA382558_S_NODE_6527_length_196_cov_5.955975_g6523_i0 | PRJNA382558 | 6527 | 196 | 5.955975 | 11.673711 | Thermoanaerobaculaceae bacterium | 2699758 | Bacteria | Bacteria | 180 | 7.45e-41 | NTclustered | gi|2874254005|emb|OY970330.1| | 2699758 | g6523 | i0 | 83.417 | 104.55612244898 | 199 | 28 | 100 | 4 | 1 | 196 | 4877695 | 4877499 | MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1 | blastn | 20493 | 180 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculales | Thermoanaerobaculaceae | Thermoanaerobaculaceae bacterium | |||
| 10608817 | 10608817 | PRJNA382558_S_NODE_8269_length_183_cov_4.431507_g8265_i0 | PRJNA382558 | 8269 | 183 | 4.431507 | 8.10965781 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 139 | 1.1599999999999999e-28 | NTclustered | gi|2814788339|emb|OY761475.2| | 2910147 | g8265 | i0 | 81.609 | 1.72131147540984 | 174 | 27 | 95 | 4 | 11 | 183 | 4962906 | 4963075 | MAG: Vicinamibacterales bacterium isolate 01def6b1-0c8c-435d-859a-076764f3ef92 genome assembly, chromosome: 1 | blastn | 315 | 139 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 19530784 | 19530784 | PRJNA382558_S_NODE_4816_length_214_cov_4.581921_g4812_i0 | PRJNA382558 | 4816 | 214 | 4.581921 | 9.80531094 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 147 | 8.41e-31 | NTclustered | gi|2874254167|emb|OY970399.1| | 171953 | g4812 | i0 | 79.358 | 1.57009345794393 | 218 | 37 | 100 | 8 | 1 | 214 | 3954108 | 3954321 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1 | blastn | 336 | 147 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 19530836 | 19530836 | PRJNA382558_S_NODE_7056_length_191_cov_9.805195_g7052_i0 | PRJNA382558 | 7056 | 191 | 9.805195 | 18.72792245 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 93.5 | 9.68e-15 | NTclustered | gi|2621704939|emb|OY762226.1| | 2910147 | g7052 | i0 | 83.333 | 5.34031413612565 | 102 | 15 | 53 | 2 | 4 | 104 | 5017743 | 5017643 | MAG: Vicinamibacterales bacterium isolate 0d5134ca-f8ab-4963-ab29-a032ed897002 genome assembly, chromosome: 1 | blastn | 1020 | 93.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales 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);;