RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax_phylum = "Candidatus Omnitrophota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Omnitrophota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA168635 · 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
364666 364666 PRJNA168635_P_NODE_5781_length_352_cov_1.719472_g5375_i0 PRJNA168635 5781 352 1.719472 6.05254144 Candidatus Omnitrophota bacterium 2035772 Bacteria Bacteria 346 1.3599999999999999e-90   NTclustered gi|2621701202|emb|OY759724.1| 2035772 g5375 i0 84.814 3.75568181818182 349 47 98 6 1 345 2374140 2373794 MAG: Candidatus Omnitrophota bacterium isolate 1a5844f9-839a-4d7b-a7f9-2444bab12bdd genome assembly, chromosome: 1 blastn 1322 346 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota bacterium
13118583 13118583 PRJNA168635_P_NODE_9651_length_268_cov_3.753425_g9236_i0 PRJNA168635 9651 268 3.753425 10.059179 Candidatus Velamenicoccus archaeovorus 1930593 Bacteria Bacteria 65.8 3.15e-6   NTclustered gi|1560991511|gb|CP019384.1| 1930593 g9236 i0 93.182 1.75746268656716 44 3 16 0 158 201 1519535 1519492 Candidatus Velamenicoccus archaeovorus strain LiM chromosome, complete genome blastn 471 65.8 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota       Candidatus Velamenicoccus Candidatus Velamenicoccus archaeovorus
22731184 22731184 PRJNA168635_P_NODE_9138_length_277_cov_2.697368_g8723_i0 PRJNA168635 9138 277 2.697368 7.47170936 Bacteria 2 Bacteria Bacteria 311 3.81e-80   NTclustered gi|354334900|gb|JN412734.1| 174292 g8723 i0 87.004 182.321299638989 277 35 100 1 1 277 2278 2553 Uncultured candidate division OP3 bacterium clone SKK-01 23S ribosomal RNA gene, partial sequence blastn 50503 311 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         uncultured Omnitrophica bacterium

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