RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA169559" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA169559 · 5 ✖

analysis 1

  • blastn · 5 ✖

tax_clade 0

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
5468344 5468344 PRJNA169559_P_NODE_31745_length_257_cov_8.614035_g29669_i0 PRJNA169559 31745 257 8.614035 22.13806995 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 54.7 0.006   NTclustered gi|2874253836|emb|OY969886.1| 171953 g29669 i0 96.875 0.124513618677043 32 1 12 0 44 75 2338574 2338543 MAG: uncultured Acidobacteriota bacterium isolate MFD10007.bin.c.1 genome assembly, chromosome: 1 blastn 32 54.7 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
9293289 9293289 PRJNA169559_P_NODE_6328_length_675_cov_84.348297_g4877_i0 PRJNA169559 6328 675 84.348297 569.35100475 uncultured Granulicella sp. 1241325 Bacteria Bacteria 1042 0   NTclustered gi|2626255659|emb|OY843766.1| 1241325 g4877 i0 94.527 125.782222222222 676 35 100 2 1 675 3194607 3193933 MAG: uncultured Granulicella sp. isolate e6d70442-04f8-4699-a368-e2225de37168 genome assembly, chromosome: 1 blastn 84903 1042 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Granulicella uncultured Granulicella sp.
10568879 10568879 PRJNA169559_P_NODE_1029_length_1591_cov_62.464149_g532_i0 PRJNA169559 1029 1591 62.464149 993.80461059 uncultured Granulicella sp. 1241325 Bacteria Bacteria 2617 0   NTclustered gi|2836016426|emb|OZ196157.1| 1241325 g532 i0 96.361 98.7762413576367 1594 53 100 5 1 1591 1018306 1019897 MAG: uncultured Granulicella sp. isolate 532c3363-cb9a-4ff4-a964-62ae8f4e4543 genome assembly, chromosome: 1 blastn 157153 2617 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Granulicella uncultured Granulicella sp.
10569270 10569270 PRJNA169559_P_NODE_7949_length_602_cov_83.949389_g6351_i0 PRJNA169559 7949 602 83.949389 505.37532178 Terriglobus roseus 392734 Bacteria Bacteria 1051 0   NTclustered gi|390410848|gb|CP003379.1| 926566 g6351 i0 98.173 94.1013289036545 602 11 100 0 1 602 926797 927398 Terriglobus roseus DSM 18391, complete genome blastn 56649 1051 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terriglobus Terriglobus roseus
23316916 23316916 PRJNA169559_P_NODE_1019_length_1602_cov_59.736173_g526_i0 PRJNA169559 1019 1602 59.736173 956.97349146 Terriglobus roseus 392734 Bacteria Bacteria 2680 0   NTclustered gi|390410848|gb|CP003379.1| 926566 g526 i0 96.836 97.7609238451935 1612 35 100 14 1 1602 2078639 2077034 Terriglobus roseus DSM 18391, complete genome blastn 156613 2680 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terriglobus Terriglobus roseus

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