RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJEB55122" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • PVC group · 3 ✖

bioproject 1

  • PRJEB55122 · 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
2267020 2267020 PRJEB55122_P_NODE_29602_length_193_cov_1.805556_g29205_i0 PRJEB55122 29602 193 1.805556 3.48472308 Lacipirellula 2691417 Bacteria Bacteria 346 6.82e-91   NTclustered gi|523452695|gb|KF183115.1| 120965 g29205 i0 98.964 94 193 2 100 0 1 193 4 196 Uncultured planctomycete clone M2-076 16S ribosomal RNA gene, partial sequence blastn 18142 346 1 Bacteria PVC group Pseudomonadati Planctomycetota         uncultured Planctomycetota bacterium
11599297 11599297 PRJEB55122_P_NODE_26530_length_207_cov_1.310127_g26133_i0 PRJEB55122 26530 207 1.310127 2.71196289 Lacipirellula limnantheis 2528024 Bacteria Bacteria 381 2.0299999999999995e-101   NTclustered gi|1712529062|gb|CP036339.1| 2528024 g26133 i0 100 258.323671497585 206 0 99 0 1 206 5169708 5169503 Lacipirellula limnantheis strain I41 chromosome blastn 53473 381 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Lacipirellula Lacipirellula limnantheis
19246335 19246335 PRJEB55122_P_NODE_23616_length_223_cov_0.896552_g23219_i0 PRJEB55122 23616 223 0.896552 1.99931096 Lacipirellula limnantheis 2528024 Bacteria Bacteria 390 3.689999999999999e-104   NTclustered gi|1712529062|gb|CP036339.1| 2528024 g23219 i0 98.206 71.0089686098655 223 4 100 0 1 223 5170625 5170403 Lacipirellula limnantheis strain I41 chromosome blastn 15835 390 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Lacipirellula Lacipirellula limnantheis

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