RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA724011" 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

  • PRJNA724011 · 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
1986898 1986898 PRJNA724011_P_NODE_81782_length_273_cov_2.835000_g80759_i0 PRJNA724011 81782 273 2.835 7.73955 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 394 3.61e-105   NTclustered gi|2874253885|emb|OY970060.1| 171953 g80759 i0 92.701 155.542124542125 274 19 100 1 1 273 4841649 4841922 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1 blastn 42463 394 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
9638903 9638903 PRJNA724011_P_NODE_112548_length_207_cov_9.208955_g111525_i0 PRJNA724011 112548 207 9.208955 19.06253685 Acidobacteriota bacterium 1978231 Bacteria Bacteria 311 2.71e-80   NTclustered gi|1958098837|gb|CP065005.1| 1978231 g111525 i0 93.72 125.700483091787 207 13 100 0 1 207 4652302 4652096 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome blastn 26020 311 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
10914548 10914548 PRJNA724011_P_NODE_26509_length_546_cov_2.911205_g25493_i0 PRJNA724011 26509 546 2.911205 15.8951793 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 54.7 0.015   NTclustered gi|2874253760|emb|OY969701.1| 2283092 g25493 i0 100 0.0531135531135531 29 0 5 0 289 317 3859450 3859478 MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1 blastn 29 54.7 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
13464255 13464255 PRJNA724011_P_NODE_2131_length_1955_cov_75.934113_g1837_i0 PRJNA724011 2131 1955 75.934113 1484.51190915 Acidobacteriota bacterium 1978231 Bacteria Bacteria 2732 0   NTclustered gi|1958098837|gb|CP065005.1| 1978231 g1837 i0 92.368 127.612276214834 1926 136 98 11 37 1955 4650330 4648409 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome blastn 249482 2732 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
22387961 22387961 PRJNA724011_P_NODE_26798_length_543_cov_1.542553_g25782_i0 PRJNA724011 26798 543 1.542553 8.37606279 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 291 1.04e-73   NTclustered gi|2893358426|emb|OZ220718.1| 2910147 g25782 i0 79.224 7.94475138121547 438 75 79 14 3 432 1182741 1182312 MAG: Vicinamibacterales bacterium isolate 0ce2d42f-2bf0-44bc-a671-070680eb922c genome assembly, chromosome: 1 blastn 4314 291 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
23663896 23663896 PRJNA724011_P_NODE_79259_length_279_cov_1.378641_g78236_i0 PRJNA724011 79259 279 1.378641 3.84640839 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 52.8 0.026   NTclustered gi|2874253678|emb|OY969112.1| 171953 g78236 i0 100 0.100358422939068 28 0 10 0 117 144 1217834 1217861 MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
23664009 23664009 PRJNA724011_P_NODE_93059_length_252_cov_1.117318_g92036_i0 PRJNA724011 93059 252 1.117318 2.81564136 Bryobacterales bacterium F-183 2802972 Bacteria Bacteria 174 4.67e-39   NTclustered gi|2131941663|dbj|AP025252.1| 2802972 g92036 i0 79.608 13.6111111111111 255 42 99 7 1 251 634770 634522 Bryobacterales bacterium F-183 DNA, nearly complete genome blastn 3430 174 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium F-183
24937362 24937362 PRJNA724011_P_NODE_76500_length_285_cov_1.452830_g75477_i0 PRJNA724011 76500 285 1.45283 4.1405655 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 257 5.2e-64   NTclustered gi|2874253692|emb|OY969418.1| 171953 g75477 i0 91.534 4.10175438596491 189 13 66 3 1 188 498539 498725 MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1 blastn 1169 257 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);;