RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1169999" and tax_clade = "FCB group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • FCB group · 3 ✖

bioproject 1

  • PRJNA1169999 · 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
7418106 7418106 PRJNA1169999_P_NODE_3286_length_247_cov_0.885057_g3250_i0 PRJNA1169999 3286 247 0.885057 2.18609079 Chryseobacterium 59732 Bacteria Bacteria 217 7.479999999999999e-52   NTclustered gi|1774322755|gb|CP045734.1| 1813611 g3250 i0 82.917 11.8380566801619 240 41 97 0 6 245 3357824 3358063 Chryseobacterium indologenes. StR 03 DNA, complete genome blastn 2924 217 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Chryseobacterium Chryseobacterium cucumeris
24541165 24541165 PRJNA1169999_P_NODE_2860_length_250_cov_0.870056_g2824_i0 PRJNA1169999 2860 250 0.870056 2.17514 Chryseobacterium bernardetii 1241978 Bacteria Bacteria 385 1.97e-102   NTclustered gi|1519571667|gb|CP033932.1| 1241978 g2824 i0 94.4 65.7 250 14 100 0 1 250 690714 690465 Chryseobacterium bernardetii strain G0229 chromosome, complete genome blastn 16425 385 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Chryseobacterium Chryseobacterium bernardetii
24541167 24541167 PRJNA1169999_P_NODE_320_length_640_cov_1.488536_g287_i0 PRJNA1169999 320 640 1.488536 9.5266304 Hymenobacter sp. BRD128 2675878 Bacteria Bacteria 974 0   NTclustered gi|1847993467|gb|CP053908.1| 2675878 g287 i0 94.384 292.415625 641 25 100 11 4 640 339483 338850 Hymenobacter sp. BRD128 chromosome, complete genome blastn 187146 974 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Hymenobacteraceae Hymenobacter Hymenobacter sp. BRD128

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