RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJEB28062" and tax_phylum = "Ignavibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ignavibacteriota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB28062 · 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
8951877 8951877 PRJEB28062_P_NODE_47788_length_518_cov_22.346067_g45442_i0 PRJEB28062 47788 518 22.346067 115.75262706 Ignavibacteriaceae bacterium 2651163 Bacteria Bacteria 121 1.37e-22   NTclustered gi|2621700951|emb|OY759785.1| 2651163 g45442 i0 94.872 19.3474903474903 78 3 15 1 65 142 3637535 3637459 MAG: Ignavibacteriaceae bacterium isolate e3da2468-0b18-4b5b-bfd4-73ebec91e4fc genome assembly, chromosome: 1 blastn 10022 121 1 Bacteria FCB group Pseudomonadati Ignavibacteriota Ignavibacteria Ignavibacteriales Ignavibacteriaceae   Ignavibacteriaceae bacterium
10227494 10227494 PRJEB28062_P_NODE_41189_length_565_cov_50.695122_g38855_i0 PRJEB28062 41189 565 50.695122 286.4274393 Ignavibacterium sp. 2651167 Bacteria Bacteria 898 0   NTclustered gi|2314740639|dbj|AP026678.1| 2651167 g38855 i0 97.18 92.4070796460177 532 14 94 1 24 555 3218486 3219016 MAG: Ignavibacterium sp. KatS3mg037 DNA, complete genome blastn 52210 898 1 Bacteria FCB group Pseudomonadati Ignavibacteriota Ignavibacteria Ignavibacteriales Ignavibacteriaceae Ignavibacterium Ignavibacterium sp.
12778761 12778761 PRJEB28062_P_NODE_62411_length_441_cov_10.586957_g60051_i0 PRJEB28062 62411 441 10.586957 46.68848037 Ignavibacterium sp. 2651167 Bacteria Bacteria 209 2.39e-49   NTclustered gi|2108406931|gb|CP070637.1| 2651167 g60051 i0 79.522 12.281179138322 293 60 66 0 30 322 1226579 1226287 MAG: Ignavibacterium sp. isolate bin94 chromosome blastn 5416 209 1 Bacteria FCB group Pseudomonadati Ignavibacteriota Ignavibacteria Ignavibacteriales Ignavibacteriaceae Ignavibacterium Ignavibacterium sp.

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