RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA315314" and tax_clade = "delta/epsilon subdivisions"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • delta/epsilon subdivisions · 5 ✖

bioproject 1

  • PRJNA315314 · 5 ✖

analysis 1

  • blastn · 5 ✖

tax_phylum 0

tax_kingdom 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
1065366 1065366 PRJNA315314_S_NODE_29681_length_155_cov_54.301587_g29360_i0 PRJNA315314 29681 155 54.301587 84.16745985 Pseudomonadati 3379134 Bacteria Bacteria 254 3.25e-63   NTclustered gi|26801211|emb|AJ532713.1| 34034 g29360 i0 97.315 96.1290322580645 149 4 96 0 4 152 910 762 Uncultured delta proteobacterium partial 16S rRNA gene, clone JG34-KF-14 blastn 14900 254 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium
4208288 4208288 PRJNA315314_S_NODE_7544_length_293_cov_56.170455_g7223_i0 PRJNA315314 7544 293 56.170455 164.57943315 uncultured delta proteobacterium 34034 Bacteria Bacteria 486 6.2799999999999984e-133   NTclustered gi|375245443|gb|JQ653850.1| 34034 g7223 i0 97.872 94.6825938566553 282 4 96 2 2 283 1 280 Uncultured delta proteobacterium clone 199 16S ribosomal RNA gene, partial sequence blastn 27742 486 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium
20782301 20782301 PRJNA315314_S_NODE_19577_length_186_cov_187.063694_g19256_i0 PRJNA315314 19577 186 187.063694 347.93847084 uncultured delta proteobacterium 34034 Bacteria Bacteria 200 5.369999999999999e-47   NTclustered gi|2874253674|emb|OY969108.1| 34034 g19256 i0 88.554 210.134408602151 166 17 88 2 1 164 1543951 1544116 MAG: uncultured delta proteobacterium isolate MFD01828.bin.c.1 genome assembly, chromosome: 1 blastn 39085 200 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium
21467117 21467117 PRJNA315314_S_NODE_29677_length_155_cov_77.230159_g29356_i0 PRJNA315314 29677 155 77.230159 119.70674645 root 1 Root_unresolved Root_unresolved 137 3.42e-28   NTclustered gi|2874253659|emb|OY969087.1| 34034 g29356 i0 83.019 190.296774193548 159 20 100 7 1 155 1501746 1501901 MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1 blastn 29496 137 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium
25291347 25291347 PRJNA315314_S_NODE_10040_length_255_cov_504.871681_g9719_i0 PRJNA315314 10040 255 504.871681 1287.42278655 Pseudomonadota 1224 Bacteria Bacteria 466 6.98e-127   NTclustered gi|202950689|emb|FM206054.1| 34034 g9719 i0 100 104.917647058824 252 0 99 0 1 252 252 1 Uncultured delta proteobacterium partial 16S rRNA gene, clone GW_1 blastn 26754 466 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium

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