RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA946307" and tax_clade = "Candidatus Porisulfidus"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Candidatus Porisulfidus · 3 ✖

bioproject 1

  • PRJNA946307 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
2202838 2202838 PRJNA946307_P_NODE_59022_length_209_cov_2.837500_g58148_i0 PRJNA946307 59022 209 2.8375 5.930375 uncultured candidatus Porisulfidus sp. 3039487 Bacteria Bacteria 93.5 1.08e-14   NTclustered gi|2621706121|emb|OY764335.1| 3039487 g58148 i0 89.189 0.354066985645933 74 8 35 0 13 86 1291020 1291093 MAG: uncultured candidatus Porisulfidus sp. isolate 93d2c08f-77fa-417a-97c6-1065e5bfdc34 genome assembly, chromosome: 1 blastn 74 93.5 1 Bacteria Candidatus Porisulfidus Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales     uncultured candidatus Porisulfidus sp.
7303930 7303930 PRJNA946307_P_NODE_121446_length_174_cov_3.072000_g120572_i0 PRJNA946307 121446 174 3.072 5.34528 uncultured candidatus Porisulfidus sp. 3039487 Bacteria Bacteria 254 3.74e-63   NTclustered gi|2621706121|emb|OY764335.1| 3039487 g120572 i0 95.092 251.028735632184 163 5 92 2 15 174 1299686 1299524 MAG: uncultured candidatus Porisulfidus sp. isolate 93d2c08f-77fa-417a-97c6-1065e5bfdc34 genome assembly, chromosome: 1 blastn 43679 254 1 Bacteria Candidatus Porisulfidus Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales     uncultured candidatus Porisulfidus sp.
9855590 9855590 PRJNA946307_P_NODE_60788_length_206_cov_1.133758_g59914_i0 PRJNA946307 60788 206 1.133758 2.33554148 uncultured candidatus Porisulfidus sp. 3039487 Bacteria Bacteria 97.1 8.2e-16   NTclustered gi|2621706121|emb|OY764335.1| 3039487 g59914 i0 79.851 5.13106796116505 134 26 65 1 34 166 1639062 1639195 MAG: uncultured candidatus Porisulfidus sp. isolate 93d2c08f-77fa-417a-97c6-1065e5bfdc34 genome assembly, chromosome: 1 blastn 1057 97.1 1 Bacteria Candidatus Porisulfidus Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales     uncultured candidatus Porisulfidus 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);;