RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1120203" and tax_clade = "SAR86 cluster"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • SAR86 cluster · 4 ✖

bioproject 1

  • PRJNA1120203 · 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
9203573 9203573 PRJNA1120203_P_NODE_97088_length_244_cov_0.900585_g96072_i0 PRJNA1120203 97088 244 0.900585 2.1974274 SAR86 cluster bacterium HIMB1674 3138949 Bacteria Bacteria 435 1.87e-117   NTclustered gi|2798661071|gb|CP151794.1| 3138949 g96072 i0 98.77 1 244 3 100 0 1 244 1210047 1210290 SAR86 cluster bacterium HIMB1674 chromosome, complete genome blastn 244 435 1 Bacteria SAR86 cluster Pseudomonadati Pseudomonadota Gammaproteobacteria       SAR86 cluster bacterium HIMB1674
10479204 10479204 PRJNA1120203_P_NODE_89829_length_247_cov_0.885057_g88813_i0 PRJNA1120203 89829 247 0.885057 2.18609079 uncultured SAR86 cluster bacterium 648174 Bacteria Bacteria 211 3.48e-50   NTclustered gi|2308952804|emb|OX044367.1| 648174 g88813 i0 82.186 22.4534412955466 247 42 99 2 1 246 433879 433634 MAG: uncultured SAR86 cluster bacterium isolate A_MB256 genome assembly, chromosome: A_MB256_contig-1 blastn 5546 211 1 Bacteria SAR86 cluster Pseudomonadati Pseudomonadota Gammaproteobacteria       uncultured SAR86 cluster bacterium
13029171 13029171 PRJNA1120203_P_NODE_84391_length_249_cov_0.875000_g83375_i0 PRJNA1120203 84391 249 0.875 2.17875 SAR86 cluster bacterium HIMB1674 3138949 Bacteria Bacteria 411 3.2299999999999996e-110   NTclustered gi|2798661071|gb|CP151794.1| 3138949 g83375 i0 96.748 0.987951807228916 246 8 99 0 4 249 1249284 1249039 SAR86 cluster bacterium HIMB1674 chromosome, complete genome blastn 246 411 1 Bacteria SAR86 cluster Pseudomonadati Pseudomonadota Gammaproteobacteria       SAR86 cluster bacterium HIMB1674
23227685 23227685 PRJNA1120203_P_NODE_80899_length_250_cov_0.870056_g79883_i0 PRJNA1120203 80899 250 0.870056 2.17514 SAR86 cluster bacterium HIMB1674 3138949 Bacteria Bacteria 424 4.16e-114   NTclustered gi|2798661071|gb|CP151794.1| 3138949 g79883 i0 97.2 1 250 7 100 0 1 250 1447151 1446902 SAR86 cluster bacterium HIMB1674 chromosome, complete genome blastn 250 424 1 Bacteria SAR86 cluster Pseudomonadati Pseudomonadota Gammaproteobacteria       SAR86 cluster bacterium HIMB1674

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