contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1000943" and tax_phylum = "Verrucomicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2695312 | 2695312 | PRJNA1000943_P_NODE_143_length_1549_cov_2.367209_g116_i0 | PRJNA1000943 | 143 | 1549 | 2.367209 | 36.66806741 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 2540 | 0 | NTclustered | gi|2874254019|emb|OY970344.1| | 412056 | g116 | i0 | 96.26 | 103.848934796643 | 1551 | 54 | 100 | 4 | 1 | 1549 | 737142 | 735594 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 | blastn | 160862 | 2540 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 3971486 | 3971486 | PRJNA1000943_P_NODE_7264_length_304_cov_1.350649_g7126_i0 | PRJNA1000943 | 7264 | 304 | 1.350649 | 4.10597296 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 289 | 1.9799999999999996e-73 | NTclustered | gi|2874253952|emb|OY970277.1| | 412056 | g7126 | i0 | 89.823 | 443.861842105263 | 226 | 22 | 74 | 1 | 35 | 259 | 2749638 | 2749863 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1 | blastn | 134934 | 289 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 9072538 | 9072538 | PRJNA1000943_P_NODE_12088_length_250_cov_1.418079_g11950_i0 | PRJNA1000943 | 12088 | 250 | 1.418079 | 3.5451975 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 281 | 2.65e-71 | NTclustered | gi|2874253690|emb|OY969416.1| | 412056 | g11950 | i0 | 91.346 | 70.06 | 208 | 15 | 83 | 3 | 1 | 207 | 1315122 | 1314917 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 | blastn | 17515 | 281 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 14173816 | 14173816 | PRJNA1000943_P_NODE_7292_length_304_cov_0.874459_g7154_i0 | PRJNA1000943 | 7292 | 304 | 0.874459 | 2.65835536 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 374 | 5.319999999999998e-99 | NTclustered | gi|2874253690|emb|OY969416.1| | 412056 | g7154 | i0 | 89.333 | 76.6842105263158 | 300 | 29 | 98 | 3 | 1 | 298 | 1315203 | 1315501 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 | blastn | 23312 | 374 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 15447914 | 15447914 | PRJNA1000943_P_NODE_7973_length_292_cov_1.552511_g7835_i0 | PRJNA1000943 | 7973 | 292 | 1.552511 | 4.53333212 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 359 | 1.42e-94 | NTclustered | gi|2874254020|emb|OY970345.1| | 412056 | g7835 | i0 | 89.68 | 200.332191780822 | 281 | 29 | 96 | 0 | 12 | 292 | 3894740 | 3894460 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1 | blastn | 58497 | 359 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 17996823 | 17996823 | PRJNA1000943_P_NODE_15115_length_243_cov_0.917647_g14977_i0 | PRJNA1000943 | 15115 | 243 | 0.917647 | 2.22988221 | Termitidicoccus mucosus | 1184151 | Bacteria | Bacteria | 165 | 2.6999999999999997e-36 | NTclustered | gi|2724066732|gb|CP109796.1| | 1184151 | g14977 | i0 | 79.184 | 26.1646090534979 | 245 | 45 | 99 | 6 | 1 | 242 | 6569312 | 6569071 | Termitidicoccus mucosus strain TSB47 chromosome, complete genome | blastn | 6358 | 165 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Termitidicoccus | Termitidicoccus mucosus | |
| 17996834 | 17996834 | PRJNA1000943_P_NODE_15735_length_237_cov_2.817073_g15597_i0 | PRJNA1000943 | 15735 | 237 | 2.817073 | 6.67646301 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 366 | 6.69e-97 | NTclustered | gi|2874254019|emb|OY970344.1| | 412056 | g15597 | i0 | 94.561 | 154.725738396624 | 239 | 9 | 100 | 4 | 1 | 237 | 737308 | 737544 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 | blastn | 36670 | 366 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 25225387 | 25225387 | PRJNA1000943_P_NODE_9620_length_269_cov_1.260204_g9482_i0 | PRJNA1000943 | 9620 | 269 | 1.260204 | 3.38994876 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 359 | 1.3e-94 | NTclustered | gi|2874254040|emb|OY970364.1| | 412056 | g9482 | i0 | 90.741 | 118.234200743494 | 270 | 24 | 100 | 1 | 1 | 269 | 2168321 | 2168590 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04463.bin.c.15 genome assembly, chromosome: 1 | blastn | 31805 | 359 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae 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);;