RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJEB11748" and tax_phylum = "Synergistota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Synergistota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJEB11748 · 7 ✖

analysis 1

  • blastn · 7 ✖

tax_clade 0

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
6086938 6086938 PRJEB11748_P_NODE_244445_length_250_cov_6.650794_g242262_i0 PRJEB11748 244445 250 6.650794 16.626985 Pyramidobacter 638847 Bacteria Bacteria 187 5.949999999999998e-43   NTclustered gi|2188906985|dbj|AP025585.1| 638849 g242262 i0 82.629 1.74 213 35 85 2 15 226 2217942 2217731 Pyramidobacter piscolens CE91-St28 DNA, complete genome blastn 435 187 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Dethiosulfovibrionaceae Pyramidobacter Pyramidobacter piscolens
11187504 11187504 PRJEB11748_P_NODE_296049_length_221_cov_5.331250_g293866_i0 PRJEB11748 296049 221 5.33125 11.7820625 Pyramidobacter 638847 Bacteria Bacteria 279 8.25e-71   NTclustered gi|167996909|gb|EU379932.1| 352165 g293866 i0 92 34.0226244343891 200 15 90 1 23 221 1838 2037 Synergistes sp. W5455 16S ribosomal RNA gene, 16S-23S ribosomal RNA intergenic spacer, 23S ribosomal RNA gene, 23S-5S ribosomal RNA intergenic spacer, and 5S ribosomal RNA gene, complete sequence blastn 7519 279 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Dethiosulfovibrionaceae Pyramidobacter Pyramidobacter piscolens
15318115 15318115 PRJEB11748_P_NODE_198513_length_285_cov_2.200893_g196330_i0 PRJEB11748 198513 285 2.200893 6.27254505 Fretibacterium fastidiosum 651822 Bacteria Bacteria 322 1.82e-83   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g196330 i0 90.535 0.852631578947368 243 23 85 0 21 263 1523129 1522887 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 243 322 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
15318570 15318570 PRJEB11748_P_NODE_220913_length_267_cov_1.577670_g218730_i0 PRJEB11748 220913 267 1.57767 4.2123789 Thermanaerovibrio acidaminovorans 81462 Bacteria Bacteria 52.8 0.024   NTclustered gi|269099254|gb|CP001818.1| 525903 g218730 i0 96.774 0.116104868913858 31 1 12 0 24 54 1469920 1469890 Thermanaerovibrio acidaminovorans DSM 6589, complete genome blastn 31 52.8 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae Thermanaerovibrio Thermanaerovibrio acidaminovorans
17867506 17867506 PRJEB11748_P_NODE_191895_length_291_cov_1.304348_g189712_i0 PRJEB11748 191895 291 1.304348 3.79565268 Pyramidobacter piscolens 638849 Bacteria Bacteria 368 2.36e-97   NTclustered gi|167996909|gb|EU379932.1| 352165 g189712 i0 89.931 12.6460481099656 288 25 98 3 1 286 2989 3274 Synergistes sp. W5455 16S ribosomal RNA gene, 16S-23S ribosomal RNA intergenic spacer, 23S ribosomal RNA gene, 23S-5S ribosomal RNA intergenic spacer, and 5S ribosomal RNA gene, complete sequence blastn 3680 368 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Dethiosulfovibrionaceae Pyramidobacter Pyramidobacter piscolens
17867988 17867988 PRJEB11748_P_NODE_217395_length_269_cov_7.966346_g215212_i0 PRJEB11748 217395 269 7.966346 21.42947074 Thermanaerovibrio acidaminovorans 81462 Bacteria Bacteria 412 9.81e-111   NTclustered gi|269099254|gb|CP001818.1| 525903 g215212 i0 98.298 0.87360594795539 235 4 87 0 19 253 925605 925839 Thermanaerovibrio acidaminovorans DSM 6589, complete genome blastn 235 412 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae Thermanaerovibrio Thermanaerovibrio acidaminovorans
20417925 20417925 PRJEB11748_P_NODE_274437_length_232_cov_9.941520_g272254_i0 PRJEB11748 274437 232 9.94152 23.0643264 Pyramidobacter sp. YE332 3068894 Bacteria Bacteria 342 1.0999999999999999e-89   NTclustered gi|2601021520|gb|CP133038.1| 3068894 g272254 i0 95.794 1.82758620689655 214 6 91 3 18 228 978192 977979 Pyramidobacter sp. YE332 chromosome, complete genome blastn 424 342 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Dethiosulfovibrionaceae Pyramidobacter Pyramidobacter sp. YE332

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;