RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1120203" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1120203 · 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
7928348 7928348 PRJNA1120203_P_NODE_83787_length_249_cov_0.875000_g82771_i0 PRJNA1120203 83787 249 0.875 2.17875 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 244 3.46e-60   NTclustered gi|2108314823|gb|CP070670.1| 2026742 g82771 i0 84.677 1.87951807228916 248 34 99 4 1 246 2773398 2773643 MAG: Gemmatimonadetes bacterium isolate bin741 chromosome blastn 468 244 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
7928483 7928483 PRJNA1120203_P_NODE_92387_length_246_cov_0.890173_g91371_i0 PRJNA1120203 92387 246 0.890173 2.18982558 Gemmatimonas groenlandica 2732249 Bacteria Bacteria 167 7.61e-37   NTclustered gi|1839994010|gb|CP053085.1| 2732249 g91371 i0 81.773 2.54065040650406 203 33 82 4 46 246 4248002 4247802 Gemmatimonas groenlandica strain TET16 chromosome, complete genome blastn 625 167 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas groenlandica
11754164 11754164 PRJNA1120203_P_NODE_96990_length_244_cov_0.900585_g95974_i0 PRJNA1120203 96990 244 0.900585 2.1974274 uncultured Gemmatimonadaceae bacterium 246130 Bacteria Bacteria 246 9.409999999999999e-61   NTclustered gi|2874253995|emb|OY970320.1| 246130 g95974 i0 85.02 1.01229508196721 247 32 100 5 1 244 3072078 3071834 MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1 blastn 247 246 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   uncultured Gemmatimonadaceae bacterium
14303324 14303324 PRJNA1120203_P_NODE_100152_length_243_cov_0.905882_g99136_i0 PRJNA1120203 100152 243 0.905882 2.20129326 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 167 7.5e-37   NTclustered gi|2874253938|emb|OY970263.1| 412054 g99136 i0 80 65.2716049382716 230 42 94 4 8 235 3309234 3309007 MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1 blastn 15861 167 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
18127302 18127302 PRJNA1120203_P_NODE_94275_length_245_cov_0.895349_g93259_i0 PRJNA1120203 94275 245 0.895349 2.19360505 Pseudogemmatithrix spongiicola 3062599 Bacteria Bacteria 148 2.74e-31   NTclustered gi|2557479348|gb|CP130613.1| 3062599 g93259 i0 78.175 2.05714285714286 252 41 100 10 1 245 2692531 2692775 Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome blastn 504 148 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Pseudogemmatithrix Pseudogemmatithrix spongiicola

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