RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJNA235310" and tax_clade = "Stenosarchaea group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Stenosarchaea group · 2 ✖

bioproject 1

  • PRJNA235310 · 2 ✖

analysis 1

  • blastn · 2 ✖
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
19493337 19493337 PRJNA235310_P_NODE_4516_length_175_cov_1.650794_g4490_i0 PRJNA235310 4516 175 1.650794 2.8888895 uncultured Methanocorpusculum sp. 176309 Archaea Archaea 54.7 0.004   NTclustered gi|2621784620|emb|OY781078.1| 176309 g4490 i0 88.889 0.8 45 3 25 2 74 117 1118629 1118672 MAG: uncultured Methanocorpusculum sp. isolate da2e5db0-0b8c-42b4-9ad7-c040378b94a4 genome assembly, chromosome: 1 blastn 140 54.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanocorpusculaceae Methanocorpusculum uncultured Methanocorpusculum sp.
20768877 20768877 PRJNA235310_P_NODE_2877_length_225_cov_1.045455_g2851_i0 PRJNA235310 2877 225 1.045455 2.35227375 Methanolobus psychrophilus 420950 Archaea Archaea 73.1 1.54e-8   NTclustered gi|409168338|gb|CP003083.1| 1094980 g2851 i0 97.674 2.90222222222222 43 0 20 1 53 95 2837736 2837777 Methanolobus psychrophilus R15 chromosome, complete genome blastn 653 73.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanolobus Methanolobus psychrophilus

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