contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA946307" and tax_phylum = "Synergistota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2201228 | 2201228 | PRJNA946307_P_NODE_12442_length_373_cov_4.253086_g11576_i0 | PRJNA946307 | 12442 | 373 | 4.253086 | 15.86401078 | uncultured Dethiosulfovibrio sp. | 185448 | Bacteria | Bacteria | 195 | 5.5699999999999995e-45 | NTclustered | gi|2621705290|emb|OY763420.1| | 185448 | g11576 | i0 | 77.26 | 826.772117962466 | 365 | 53 | 96 | 18 | 13 | 370 | 763699 | 764040 | MAG: uncultured Dethiosulfovibrio sp. isolate 94f88398-021e-4021-9552-bf231e535e7d genome assembly, chromosome: 1 | blastn | 308386 | 195 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Dethiosulfovibrionaceae | Dethiosulfovibrio | uncultured Dethiosulfovibrio sp. | ||
| 2202801 | 2202801 | PRJNA946307_P_NODE_56702_length_210_cov_2.795031_g55828_i0 | PRJNA946307 | 56702 | 210 | 2.795031 | 5.8695651 | Fretibacterium fastidiosum | 651822 | Bacteria | Bacteria | 80.5 | 8.45e-11 | NTclustered | gi|2869663113|emb|OZ209244.1| | 651822 | g55828 | i0 | 96 | 5.78571428571429 | 50 | 1 | 24 | 1 | 114 | 163 | 729047 | 729095 | Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 | blastn | 1215 | 80.5 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium fastidiosum | ||
| 9854613 | 9854613 | PRJNA946307_P_NODE_163968_length_161_cov_2.919643_g163094_i0 | PRJNA946307 | 163968 | 161 | 2.919643 | 4.70062523 | Fretibacterium fastidiosum | 651822 | Bacteria | Bacteria | 233 | 4.45e-57 | NTclustered | gi|2869663113|emb|OZ209244.1| | 651822 | g163094 | i0 | 96.479 | 2.64596273291925 | 142 | 4 | 88 | 1 | 4 | 145 | 68566 | 68706 | Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 | blastn | 426 | 233 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium fastidiosum | ||
| 14954750 | 14954750 | PRJNA946307_P_NODE_21092_length_278_cov_5.183406_g20219_i0 | PRJNA946307 | 21092 | 278 | 5.183406 | 14.40986868 | Fretibacterium fastidiosum | 651822 | Bacteria | Bacteria | 248 | 3.0399999999999997e-61 | NTclustered | gi|2869663113|emb|OZ209244.1| | 651822 | g20219 | i0 | 97.26 | 462.964028776978 | 146 | 4 | 83 | 0 | 124 | 269 | 68096 | 67951 | Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 | blastn | 128704 | 248 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium fastidiosum | ||
| 18778628 | 18778628 | PRJNA946307_P_NODE_20455_length_283_cov_2.166667_g19582_i0 | PRJNA946307 | 20455 | 283 | 2.166667 | 6.13166761 | Fretibacterium fastidiosum | 651822 | Bacteria | Bacteria | 322 | 1.8e-83 | NTclustered | gi|2869663113|emb|OZ209244.1| | 651822 | g19582 | i0 | 86.879 | 33.2014134275618 | 282 | 23 | 95 | 5 | 16 | 283 | 69385 | 69104 | Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 | blastn | 9396 | 322 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium fastidiosum | ||
| 18779311 | 18779311 | PRJNA946307_P_NODE_59095_length_209_cov_2.262500_g58221_i0 | PRJNA946307 | 59095 | 209 | 2.2625 | 4.728625 | Fretibacterium fastidiosum | 651822 | Bacteria | Bacteria | 200 | 6.18e-47 | NTclustered | gi|2869663113|emb|OZ209244.1| | 651822 | g58221 | i0 | 88.957 | 4.33492822966507 | 163 | 16 | 78 | 2 | 45 | 206 | 69817 | 69656 | Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 | blastn | 906 | 200 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium fastidiosum | ||
| 21328361 | 21328361 | PRJNA946307_P_NODE_143317_length_166_cov_2.444444_g142443_i0 | PRJNA946307 | 143317 | 166 | 2.444444 | 4.05777704 | Fretibacterium fastidiosum | 651822 | Bacteria | Bacteria | 169 | 1.32e-37 | NTclustered | gi|2869663113|emb|OZ209244.1| | 651822 | g142443 | i0 | 88.112 | 87.6144578313253 | 143 | 16 | 86 | 1 | 10 | 152 | 69969 | 70110 | Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 | blastn | 14544 | 169 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium fastidiosum | ||
| 21328991 | 21328991 | PRJNA946307_P_NODE_22577_length_269_cov_8.013636_g21703_i0 | PRJNA946307 | 22577 | 269 | 8.013636 | 21.55668084 | Jonquetella anthropi | 428712 | Bacteria | Bacteria | 460 | 3.45e-125 | NTclustered | gi|194410714|gb|EU840722.1| | 428712 | g21703 | i0 | 99.216 | 102.174721189591 | 255 | 2 | 95 | 0 | 1 | 255 | 315 | 61 | Jonquetella anthropi strain E3_33 23S ribosomal RNA gene, partial sequence | blastn | 27485 | 460 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Dethiosulfovibrionaceae | Jonquetella | Jonquetella anthropi | ||
| 22604807 | 22604807 | PRJNA946307_P_NODE_69578_length_199_cov_3.146667_g68704_i0 | PRJNA946307 | 69578 | 199 | 3.146667 | 6.26186733 | Fretibacterium fastidiosum | 651822 | Bacteria | Bacteria | 99 | 2.19e-16 | NTclustered | gi|2869663113|emb|OZ209244.1| | 651822 | g68704 | i0 | 87.952 | 0.834170854271357 | 83 | 10 | 42 | 0 | 18 | 100 | 1353822 | 1353740 | Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 | blastn | 166 | 99 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium fastidiosum |
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);;