RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA640143" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA640143 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
1886114 1886114 PRJNA640143_S_NODE_24222_length_179_cov_2.697183_g24012_i0 PRJNA640143 24222 179 2.697183 4.82795757 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 217 5.0799999999999996e-52   NTclustered gi|2874253931|emb|OY970256.1| 2283092 g24012 i0 92.715 44.854748603352 151 10 84 1 3 153 359829 359680 MAG: Pyrinomonadaceae bacterium isolate MFD09212.bin.c.2 genome assembly, chromosome: 1 blastn 8029 217 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
2430650 2430650 PRJNA640143_S_NODE_27822_length_166_cov_1.046512_g27612_i0 PRJNA640143 27822 166 1.046512 1.73720992 Bacteria 2 Bacteria Bacteria 285 1.26e-72   NTclustered gi|31789363|gb|AY281352.1| 171953 g27612 i0 97.59 136.066265060241 166 4 100 0 1 166 2842 3007 Uncultured Acidobacteria bacterium clone 23k22 genomic sequence blastn 22587 285 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
8262885 8262885 PRJNA640143_S_NODE_11827_length_252_cov_1.576744_g11617_i0 PRJNA640143 11827 252 1.576744 3.97339488 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 285 2.07e-72   NTclustered gi|2874254027|emb|OY970352.1| 171953 g11617 i0 87.55 73.3968253968254 249 28 98 2 1 247 2367168 2366921 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1 blastn 18496 285 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
12089180 12089180 PRJNA640143_S_NODE_17810_length_207_cov_8.370588_g17600_i0 PRJNA640143 17810 207 8.370588 17.32711716 Holophagales bacterium 2478486 Bacteria Bacteria 180 7.96e-41   NTclustered gi|1958024485|gb|CP064972.1| 2478486 g17600 i0 85.714 78.5314009661836 175 20 84 5 35 207 1452787 1452958 Holophagales bacterium isolate EsbW_18-Q3-R4-48_BAT3C.4_cln chromosome, complete genome blastn 16256 180 1 Bacteria   Pseudomonadati Acidobacteriota Holophagae Holophagales     Holophagales bacterium
13363794 13363794 PRJNA640143_S_NODE_11351_length_256_cov_88.305936_g11141_i0 PRJNA640143 11351 256 88.305936 226.06319616 Acidobacteriota bacterium 1978231 Bacteria Bacteria 298 2.71e-76   NTclustered gi|1958093598|gb|CP065003.1| 1978231 g11141 i0 90.991 38.31640625 222 19 86 1 1 221 317473 317252 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome blastn 9809 298 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
17187564 17187564 PRJNA640143_S_NODE_11154_length_258_cov_107.601810_g10944_i0 PRJNA640143 11154 258 107.60181 277.6126698 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 289 1.64e-73   NTclustered gi|76574288|gb|DQ139436.1| 171953 g10944 i0 90.135 49.593023255814 223 20 86 2 37 258 1 222 Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence blastn 12795 289 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
22287284 22287284 PRJNA640143_S_NODE_6118_length_336_cov_52.267559_g5908_i0 PRJNA640143 6118 336 52.267559 175.61899824 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 425 1.62e-114   NTclustered gi|217038899|gb|EU810989.1| 171953 g5908 i0 90.491 257.136904761905 326 26 96 5 8 331 1 323 Uncultured Acidobacteria bacterium clone 01QD9 23S ribosomal RNA gene, partial sequence blastn 86398 425 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
23562446 23562446 PRJNA640143_S_NODE_19959_length_196_cov_44.327044_g19749_i0 PRJNA640143 19959 196 44.327044 86.88100624 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 215 2.04e-51   NTclustered gi|217038899|gb|EU810989.1| 171953 g19749 i0 90.244 334.234693877551 164 16 84 0 8 171 1 164 Uncultured Acidobacteria bacterium clone 01QD9 23S ribosomal RNA gene, partial sequence blastn 65510 215 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota 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);;