RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA638138" 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 · 4 ✖

bioproject 1

  • PRJNA638138 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
6987889 6987889 PRJNA638138_P_NODE_23786_length_248_cov_0.880000_g23571_i0 PRJNA638138 23786 248 0.88 2.1824 Lacipirellula limnantheis 2528024 Bacteria Bacteria 246 9.59e-61   NTclustered gi|1712529062|gb|CP036339.1| 2528024 g23571 i0 84.898 2.22177419354839 245 35 98 2 1 244 493243 493486 Lacipirellula limnantheis strain I41 chromosome blastn 551 246 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Lacipirellula Lacipirellula limnantheis
8262799 8262799 PRJNA638138_P_NODE_7207_length_375_cov_1.274834_g6992_i0 PRJNA638138 7207 375 1.274834 4.7806275 Urbifossiella limnaea 2528023 Bacteria Bacteria 289 2.5e-73   NTclustered gi|1712585314|gb|CP036273.1| 2528023 g6992 i0 86.742 2.20533333333333 264 30 70 5 111 372 7416884 7416624 Urbifossiella limnaea strain ETA_A1 chromosome, complete genome blastn 827 289 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella limnaea
14638252 14638252 PRJNA638138_P_NODE_21132_length_250_cov_0.870056_g20917_i0 PRJNA638138 21132 250 0.870056 2.17514 Bremerella volcania 2527984 Bacteria Bacteria 71.3 6.25e-8   NTclustered gi|1712647354|gb|CP036289.1| 2527984 g20917 i0 84.722 0.288 72 9 28 2 7 77 1008811 1008881 Bremerella volcania strain Pan97 chromosome, complete genome blastn 72 71.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Bremerella Bremerella volcania
19736101 19736101 PRJNA638138_P_NODE_22056_length_249_cov_1.750000_g21841_i0 PRJNA638138 22056 249 1.75 4.3575 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 252 2.07e-62   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g21841 i0 85.833 5.33333333333333 240 30 96 4 3 240 7350685 7350448 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 1328 252 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae 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);;