contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJEB64798" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9055115 | 9055115 | PRJEB64798_P_NODE_200188_length_167_cov_4.466102_g198422_i0 | PRJEB64798 | 200188 | 167 | 4.466102 | 7.45839034 | Fretibacterium fastidiosum | 651822 | Bacteria | Bacteria | 206 | 1.02e-48 | NTclustered | gi|2869663113|emb|OZ209244.1| | 651822 | g198422 | i0 | 89.506 | 88.4670658682635 | 162 | 17 | 97 | 0 | 2 | 163 | 2027776 | 2027937 | Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 | blastn | 14774 | 206 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium fastidiosum | ||
| 9056233 | 9056233 | PRJEB64798_P_NODE_45428_length_291_cov_650.090909_g43663_i0 | PRJEB64798 | 45428 | 291 | 650.090909 | 1891.76454519 | Fretibacterium sp. feline oral taxon 218 | 1577289 | Bacteria | Bacteria | 414 | 2.9799999999999998e-111 | NTclustered | gi|728056019|gb|KM462177.1| | 1577289 | g43663 | i0 | 92.44 | 100.061855670103 | 291 | 21 | 100 | 1 | 1 | 291 | 1035 | 1324 | Fretibacterium sp. feline oral taxon 218 clone UJ037 16S ribosomal RNA gene, partial sequence | blastn | 29118 | 414 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium sp. feline oral taxon 218 | ||
| 9921746 | 9921746 | PRJEB64798_P_NODE_59848_length_252_cov_2.551724_g58083_i0 | PRJEB64798 | 59848 | 252 | 2.551724 | 6.43034448 | Thermanaerovibrio | 81461 | Bacteria | Bacteria | 87.9 | 6.26e-13 | NTclustered | gi|470485441|ref|NR_076701.1| | 81462 | g58083 | i0 | 88 | 49.3452380952381 | 75 | 8 | 30 | 1 | 16 | 90 | 211 | 284 | Thermanaerovibrio acidaminovorans strain Su883 23S ribosomal RNA gene, complete sequence | blastn | 12435 | 87.9 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Thermanaerovibrio | Thermanaerovibrio acidaminovorans | ||
| 10330055 | 10330055 | PRJEB64798_P_NODE_14169_length_530_cov_1559.122661_g12507_i0 | PRJEB64798 | 14169 | 530 | 1559.122661 | 8263.3501033 | Synergistales bacterium canine oral taxon 180 | 1151724 | Bacteria | Bacteria | 616 | 1.4699999999999994e-171 | NTclustered | gi|373137633|gb|JQ298400.1| | 1151724 | g12507 | i0 | 98.841 | 64.9849056603774 | 345 | 4 | 65 | 0 | 1 | 345 | 345 | 1 | Synergistales bacterium canine oral taxon 180 clone PZ081 16S ribosomal RNA gene, partial sequence | blastn | 34442 | 616 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistales bacterium canine oral taxon 180 | ||||
| 12880224 | 12880224 | PRJEB64798_P_NODE_119071_length_207_cov_3.018987_g117305_i0 | PRJEB64798 | 119071 | 207 | 3.018987 | 6.24930309 | Cloacibacillus porcorum | 1197717 | Bacteria | Bacteria | 161 | 2.8799999999999997e-35 | NTclustered | gi|1050315908|gb|CP016757.1| | 1197717 | g117305 | i0 | 80.952 | 10.1207729468599 | 210 | 27 | 100 | 8 | 1 | 207 | 637342 | 637541 | Cloacibacillus porcorum strain CL-84 chromosome, complete genome | blastn | 2095 | 161 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Cloacibacillus | Cloacibacillus porcorum | ||
| 12880386 | 12880386 | PRJEB64798_P_NODE_130211_length_198_cov_4.436242_g128445_i0 | PRJEB64798 | 130211 | 198 | 4.436242 | 8.78375916 | Fretibacterium fastidiosum | 651822 | Bacteria | Bacteria | 198 | 2.0799999999999998e-46 | NTclustered | gi|2869663113|emb|OZ209244.1| | 651822 | g128445 | i0 | 85.096 | 4.19191919191919 | 208 | 16 | 97 | 5 | 1 | 193 | 2028058 | 2028265 | Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 | blastn | 830 | 198 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium fastidiosum | ||
| 13746390 | 13746390 | PRJEB64798_P_NODE_16051_length_497_cov_113.026786_g14358_i0 | PRJEB64798 | 16051 | 497 | 113.026786 | 561.74312642 | Fretibacterium | 1434006 | Bacteria | Bacteria | 571 | 3.009999999999999e-158 | NTclustered | gi|373137751|gb|JQ298459.1| | 1151722 | g14358 | i0 | 99.679 | 62.7706237424547 | 312 | 1 | 63 | 0 | 1 | 312 | 312 | 1 | Synergistales bacterium canine oral taxon 178 clone QA061 16S ribosomal RNA gene, partial sequence | blastn | 31197 | 571 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistales bacterium canine oral taxon 178 | ||||
| 15021540 | 15021540 | PRJEB64798_P_NODE_63332_length_244_cov_6.861538_g61567_i0 | PRJEB64798 | 63332 | 244 | 6.861538 | 16.74215272 | Thermovirga | 336260 | Bacteria | Bacteria | 147 | 9.81e-31 | NTclustered | gi|470489387|ref|NR_076926.1| | 336261 | g61567 | i0 | 82.84 | 16.1475409836066 | 169 | 23 | 68 | 4 | 11 | 175 | 886 | 720 | Thermovirga lienii strain Cas60314 23S ribosomal RNA gene, complete sequence | blastn | 3940 | 147 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Thermovirgaceae | Thermovirga | Thermovirga lienii | ||
| 17978457 | 17978457 | PRJEB64798_P_NODE_138815_length_194_cov_3.137931_g137049_i0 | PRJEB64798 | 138815 | 194 | 3.137931 | 6.08758614 | uncultured Dethiosulfovibrio sp. | 185448 | Bacteria | Bacteria | 134 | 5.81e-27 | NTclustered | gi|2621705290|emb|OY763420.1| | 185448 | g137049 | i0 | 91 | 92.0618556701031 | 100 | 8 | 52 | 1 | 55 | 154 | 2373911 | 2373813 | MAG: uncultured Dethiosulfovibrio sp. isolate 94f88398-021e-4021-9552-bf231e535e7d genome assembly, chromosome: 1 | blastn | 17860 | 134 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Dethiosulfovibrionaceae | Dethiosulfovibrio | uncultured Dethiosulfovibrio sp. | ||
| 17979284 | 17979284 | PRJEB64798_P_NODE_192835_length_169_cov_4.433333_g191069_i0 | PRJEB64798 | 192835 | 169 | 4.433333 | 7.49233277 | Fretibacterium fastidiosum | 651822 | Bacteria | Bacteria | 71.3 | 3.9e-8 | NTclustered | gi|2869663113|emb|OZ209244.1| | 651822 | g191069 | i0 | 93.617 | 0.715976331360947 | 47 | 3 | 28 | 0 | 119 | 165 | 277585 | 277539 | Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 | blastn | 121 | 71.3 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium fastidiosum | ||
| 23081649 | 23081649 | PRJEB64798_P_NODE_859_length_1814_cov_44.779603_g625_i0 | PRJEB64798 | 859 | 1814 | 44.779603 | 812.30199842 | Fretibacterium fastidiosum | 651822 | Bacteria | Bacteria | 1676 | 0 | NTclustered | gi|2869663113|emb|OZ209244.1| | 651822 | g625 | i0 | 83.669 | 565.469128996692 | 1837 | 241 | 99 | 51 | 2 | 1808 | 68366 | 70173 | Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 | blastn | 1025761 | 1676 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium fastidiosum | ||
| 24355549 | 24355549 | PRJEB64798_P_NODE_860_length_1813_cov_42.679138_g625_i1 | PRJEB64798 | 860 | 1813 | 42.679138 | 773.77277194 | Fretibacterium fastidiosum | 651822 | Bacteria | Bacteria | 1620 | 0 | NTclustered | gi|2869663113|emb|OZ209244.1| | 651822 | g625 | i1 | 83.115 | 566.124655267512 | 1836 | 252 | 99 | 50 | 2 | 1807 | 68366 | 70173 | Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 | blastn | 1026384 | 1620 | 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);;