RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA825466" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA825466 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
3371311 3371311 PRJNA825466_P_NODE_8083_length_306_cov_2.725322_g7982_i0 PRJNA825466 8083 306 2.725322 8.33948532 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 132 3.56e-26   NTclustered gi|2874253860|emb|OY969916.1| 1672391 g7982 i0 75.333 42.6601307189542 300 60 96 12 2 294 273058 273350 MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 blastn 13054 132 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia bacterium
14848492 14848492 PRJNA825466_P_NODE_21432_length_247_cov_0.885057_g21331_i0 PRJNA825466 21432 247 0.885057 2.18609079 Roseiflexus sp. RS-1 357808 Bacteria Bacteria 257 4.41e-64   NTclustered gi|148566298|gb|CP000686.1| 357808 g21331 i0 85.657 133.259109311741 251 29 100 7 1 247 2807546 2807299 Roseiflexus sp. RS-1, complete genome blastn 32915 257 1 Bacteria   Bacillati Chloroflexota Chloroflexia Chloroflexales Roseiflexaceae Roseiflexus Roseiflexus sp. RS-1
25454728 25454728 PRJNA825466_P_NODE_11360_length_279_cov_1.121359_g11259_i0 PRJNA825466 11360 279 1.121359 3.12859161 Roseiflexus 120961 Bacteria Bacteria 220 6.66e-53   NTclustered gi|470482403|ref|NR_076530.1| 120962 g11259 i0 85.321 4.20430107526882 218 27 77 5 50 265 1442 1228 Roseiflexus castenholzii strain HLO8 23S ribosomal RNA gene, complete sequence blastn 1173 220 1 Bacteria   Bacillati Chloroflexota Chloroflexia Chloroflexales Roseiflexaceae Roseiflexus Roseiflexus castenholzii

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