RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA900028", tax_clade = "delta/epsilon subdivisions" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 4 ✖

tax_clade 1

  • delta/epsilon subdivisions · 4 ✖

bioproject 1

  • PRJNA900028 · 4 ✖

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
5072893 5072893 PRJNA900028_P_NODE_148784_length_165_cov_0.879310_g148035_i0 PRJNA900028 148784 165 0.87931 1.4508615 Bacteria 2 Bacteria Bacteria 305 9.59e-79   NTclustered gi|2442652011|gb|OQ422878.1| 34034 g148035 i0 100 100.242424242424 165 0 100 0 1 165 348 512 Uncultured delta proteobacterium clone KCM_3_1_26 16S ribosomal RNA gene, partial sequence blastn 16540 305 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium
20371268 20371268 PRJNA900028_P_NODE_176416_length_162_cov_1.353982_g175667_i0 PRJNA900028 176416 162 1.353982 2.19345084 Myxococcota 2818505 Bacteria Bacteria 300 4.36e-77   NTclustered gi|146428836|gb|EF219652.1| 34034 g175667 i0 100 98.6049382716049 162 0 100 0 1 162 169 8 Uncultured delta proteobacterium clone AI-1M_A12 16S ribosomal RNA gene, partial sequence blastn 15974 300 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium
21277030 21277030 PRJNA900028_P_NODE_180877_length_162_cov_0.902655_g180128_i0 PRJNA900028 180877 162 0.902655 1.4623011 uncultured delta proteobacterium 34034 Bacteria Bacteria 200 4.549999999999998e-47   NTclustered gi|2874253999|emb|OY970324.1| 34034 g180128 i0 88.889 153.432098765432 162 18 100 0 1 162 2293186 2293025 MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1 blastn 24856 200 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium
28571599 28571599 PRJNA900028_P_NODE_146927_length_165_cov_0.879310_g146178_i0 PRJNA900028 146927 165 0.87931 1.4508615 Lujinxingia vulgaris 2600176 Bacteria Bacteria 50.4 1.67e-5   NR WP_146981724.1 2600176 g146178 i0 48 0.909090909090909 50 25 89.1 1 153 7 145 194 WP_146981724.1 Kazal-type serine protease inhibitor family protein [Lujinxingia vulgaris] diamond 150 50.4 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria Bradymonadales Lujinxingiaceae Lujinxingia Lujinxingia vulgaris

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