RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJEB48872" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJEB48872 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
1346207 1346207 PRJEB48872_P_NODE_301922_length_286_cov_1.708502_g286110_i0 PRJEB48872 301922 286 1.708502 4.88631572 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 196 1.15e-45   NTclustered gi|2874253860|emb|OY969916.1| 1672391 g286110 i0 81.377 1.72727272727273 247 41 86 5 42 286 274304 274547 MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 blastn 494 196 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia bacterium
1364335 1364335 PRJEB48872_P_NODE_678362_length_153_cov_1.798246_g662550_i0 PRJEB48872 678362 153 1.798246 2.75131638 Candidatus Roseilinea sp. 2838777 Bacteria Bacteria 139 9.35e-29   NTclustered gi|2314722916|dbj|AP024676.1| 2838777 g662550 i0 85 1.20915032679739 140 18 90 1 10 146 3495070 3494931 MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome blastn 185 139 1 Bacteria Candidatus Thermofonsia Clade 3 Bacillati Chloroflexota Candidatus Thermofontia     Candidatus Roseilinea Candidatus Roseilinea sp.
2265840 2265840 PRJEB48872_P_NODE_186342_length_410_cov_1.566038_g170538_i0 PRJEB48872 186342 410 1.566038 6.4207558 Chloroflexus 1107 Bacteria Bacteria 298 4.58e-76   NTclustered gi|470483916|ref|NR_076619.1| 152260 g170538 i0 82.32 160.539024390244 362 47 86 13 49 402 599 951 Chloroflexus aggregans strain MD-66 23S ribosomal RNA gene, complete sequence blastn 65821 298 1 Bacteria   Bacillati Chloroflexota Chloroflexia Chloroflexales Chloroflexaceae Chloroflexus Chloroflexus aggregans
4818529 4818529 PRJEB48872_P_NODE_280664_length_302_cov_2.011407_g264852_i0 PRJEB48872 280664 302 2.011407 6.07444914 Herpetosiphon 64 Bacteria Bacteria 231 3.36e-56   NTclustered gi|470482680|ref|NR_076546.1| 65 g264852 i0 87.143 222.208609271523 210 19 68 7 1 206 2647 2852 Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence blastn 67107 231 1 Bacteria   Bacillati Chloroflexota Chloroflexia Herpetosiphonales Herpetosiphonaceae Herpetosiphon Herpetosiphon aurantiacus
14118864 14118864 PRJEB48872_P_NODE_689852_length_151_cov_1.830357_g674040_i0 PRJEB48872 689852 151 1.830357 2.76383907 Candidatus Roseilinea sp. 2838777 Bacteria Bacteria 152 1.18e-32   NTclustered gi|2314722916|dbj|AP024676.1| 2838777 g674040 i0 84.868 51.9403973509934 152 22 100 1 1 151 3494626 3494777 MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome blastn 7843 152 1 Bacteria Candidatus Thermofonsia Clade 3 Bacillati Chloroflexota Candidatus Thermofontia     Candidatus Roseilinea Candidatus Roseilinea sp.

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