contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA382357" and tax_phylum = "Ignavibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1679212 | 1679212 | PRJNA382357_P_NODE_77802_length_270_cov_1.875598_g77063_i0 | PRJNA382357 | 77802 | 270 | 1.875598 | 5.0641146 | Melioribacteraceae bacterium | 2614255 | Bacteria | Bacteria | 213 | 1.07e-50 | NTclustered | gi|2621703088|emb|OY760517.1| | 2614255 | g77063 | i0 | 92.568 | 191.892592592593 | 148 | 11 | 55 | 0 | 108 | 255 | 3131679 | 3131826 | MAG: Melioribacteraceae bacterium isolate c8b6aad9-4aa7-488e-baf1-dd4234e1cecc genome assembly, chromosome: 1 | blastn | 51811 | 213 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae bacterium | ||
| 4231068 | 4231068 | PRJNA382357_P_NODE_44_length_51706_cov_27.778352_g3_i0 | PRJNA382357 | 44 | 51706 | 27.778352 | 14363.07468512 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 102 | 5.32e-15 | NTclustered | gi|1850842921|gb|CP053447.1| | 2026749 | g3 | i0 | 90.909 | 0.563957761188257 | 77 | 5 | 1 | 2 | 1606 | 1680 | 1301710 | 1301786 | Ignavibacteriae bacterium isolate IGN3 chromosome | blastn | 29160 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 5506686 | 5506686 | PRJNA382357_P_NODE_145_length_14234_cov_24.000353_g3_i11 | PRJNA382357 | 145 | 14234 | 24.000353 | 3416.21024602 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 102 | 1.46e-15 | NTclustered | gi|1850842921|gb|CP053447.1| | 2026749 | g3 | i11 | 90.909 | 1.02430799494169 | 77 | 5 | 1 | 2 | 1606 | 1680 | 1301710 | 1301786 | Ignavibacteriae bacterium isolate IGN3 chromosome | blastn | 14580 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 5507589 | 5507589 | PRJNA382357_P_NODE_45_length_51626_cov_27.723262_g3_i1 | PRJNA382357 | 45 | 51626 | 27.723262 | 14312.41124012 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 102 | 5.31e-15 | NTclustered | gi|1850842921|gb|CP053447.1| | 2026749 | g3 | i1 | 90.909 | 0.564831673962732 | 77 | 5 | 1 | 2 | 1606 | 1680 | 1301710 | 1301786 | Ignavibacteriae bacterium isolate IGN3 chromosome | blastn | 29160 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 8055667 | 8055667 | PRJNA382357_P_NODE_107_length_26652_cov_27.231131_g3_i6 | PRJNA382357 | 107 | 26652 | 27.231131 | 7257.64103412 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 102 | 2.74e-15 | NTclustered | gi|1850842921|gb|CP053447.1| | 2026749 | g3 | i6 | 90.909 | 0.547050877982891 | 77 | 5 | 1 | 2 | 1606 | 1680 | 1301710 | 1301786 | Ignavibacteriae bacterium isolate IGN3 chromosome | blastn | 14580 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 9332282 | 9332282 | PRJNA382357_P_NODE_64488_length_293_cov_4.616379_g63749_i0 | PRJNA382357 | 64488 | 293 | 4.616379 | 13.52599047 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 63.9 | 1.26e-5 | NTclustered | gi|2621700951|emb|OY759785.1| | 2651163 | g63749 | i0 | 97.297 | 0.546075085324232 | 37 | 1 | 25 | 0 | 14 | 50 | 1866190 | 1866226 | MAG: Ignavibacteriaceae bacterium isolate e3da2468-0b18-4b5b-bfd4-73ebec91e4fc genome assembly, chromosome: 1 | blastn | 160 | 63.9 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 10608088 | 10608088 | PRJNA382357_P_NODE_69_length_41503_cov_31.129458_g3_i2 | PRJNA382357 | 69 | 41503 | 31.129458 | 12919.65895374 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 102 | 4.27e-15 | NTclustered | gi|1850842921|gb|CP053447.1| | 2026749 | g3 | i2 | 90.909 | 0.702599812061779 | 77 | 5 | 1 | 2 | 1606 | 1680 | 1301710 | 1301786 | Ignavibacteriae bacterium isolate IGN3 chromosome | blastn | 29160 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 11882350 | 11882350 | PRJNA382357_P_NODE_34390_length_387_cov_2.776074_g33651_i0 | PRJNA382357 | 34390 | 387 | 2.776074 | 10.74340638 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 200 | 1.25e-46 | NTclustered | gi|2621700951|emb|OY759785.1| | 2651163 | g33651 | i0 | 82.743 | 21.4470284237726 | 226 | 37 | 58 | 2 | 159 | 383 | 267955 | 268179 | MAG: Ignavibacteriaceae bacterium isolate e3da2468-0b18-4b5b-bfd4-73ebec91e4fc genome assembly, chromosome: 1 | blastn | 8300 | 200 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 13156784 | 13156784 | PRJNA382357_P_NODE_151_length_12834_cov_27.271745_g3_i12 | PRJNA382357 | 151 | 12834 | 27.271745 | 3500.0557533 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 102 | 1.32e-15 | NTclustered | gi|1850842921|gb|CP053447.1| | 2026749 | g3 | i12 | 90.909 | 1.13604488078541 | 77 | 5 | 1 | 2 | 11155 | 11229 | 1301786 | 1301710 | Ignavibacteriae bacterium isolate IGN3 chromosome | blastn | 14580 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 16980724 | 16980724 | PRJNA382357_P_NODE_174_length_8746_cov_27.749568_g3_i13 | PRJNA382357 | 174 | 8746 | 27.749568 | 2426.97721728 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 102 | 8.97e-16 | NTclustered | gi|1850842921|gb|CP053447.1| | 2026749 | g3 | i13 | 90.909 | 1.66704779327693 | 77 | 5 | 2 | 2 | 1606 | 1680 | 1301710 | 1301786 | Ignavibacteriae bacterium isolate IGN3 chromosome | blastn | 14580 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 22081217 | 22081217 | PRJNA382357_P_NODE_98_length_30484_cov_23.565592_g3_i4 | PRJNA382357 | 98 | 30484 | 23.565592 | 7183.73506528 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 102 | 3.14e-15 | NTclustered | gi|1850842921|gb|CP053447.1| | 2026749 | g3 | i4 | 90.909 | 0.956567379608975 | 77 | 5 | 1 | 2 | 1606 | 1680 | 1301710 | 1301786 | Ignavibacteriae bacterium isolate IGN3 chromosome | blastn | 29160 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 23356863 | 23356863 | PRJNA382357_P_NODE_99_length_30293_cov_27.278480_g3_i5 | PRJNA382357 | 99 | 30293 | 27.27848 | 8263.4699464 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 102 | 3.12e-15 | NTclustered | gi|1850842921|gb|CP053447.1| | 2026749 | g3 | i5 | 90.909 | 0.481299310071634 | 77 | 5 | 0 | 2 | 1606 | 1680 | 1301710 | 1301786 | Ignavibacteriae bacterium isolate IGN3 chromosome | blastn | 14580 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota 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);;