RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA437204" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA437204 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
10635422 10635422 PRJNA437204_P_NODE_102729_length_246_cov_0.890173_g102430_i0 PRJNA437204 102729 246 0.890173 2.18982558 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 303 5.56e-78   NTclustered gi|2874253885|emb|OY970060.1| 171953 g102430 i0 89.3 127.186991869919 243 24 99 2 4 246 4840509 4840269 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1 blastn 31288 303 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
11911057 11911057 PRJNA437204_P_NODE_28450_length_363_cov_1.293103_g28151_i0 PRJNA437204 28450 363 1.293103 4.69396389 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 176 1.96e-39   NTclustered gi|2621701250|emb|OY759970.1| 2910147 g28151 i0 81.092 69.534435261708 238 30 63 14 133 362 3363834 3364064 MAG: Vicinamibacterales bacterium isolate d8048395-9ec3-4be5-9403-ce9d0d334964 genome assembly, chromosome: 1 blastn 25241 176 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
18283190 18283190 PRJNA437204_P_NODE_105275_length_246_cov_0.890173_g104976_i0 PRJNA437204 105275 246 0.890173 2.18982558 Granulicella sp. 5B5 1617967 Bacteria Bacteria 141 4.61e-29   NTclustered gi|1886125103|gb|CP046444.1| 1617967 g104976 i0 78.07 45.0609756097561 228 46 92 4 21 246 556961 556736 Granulicella sp. 5B5 chromosome, complete genome blastn 11085 141 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Granulicella Granulicella sp. 5B5
22109242 22109242 PRJNA437204_P_NODE_44218_length_314_cov_0.958506_g43919_i0 PRJNA437204 44218 314 0.958506 3.00970884 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 139 2.19e-28   NTclustered gi|2874254159|emb|OY970389.1| 2283092 g43919 i0 80.628 38.8248407643312 191 28 58 7 92 273 5418267 5418457 MAG: Pyrinomonadaceae bacterium isolate MFD09206.bin.c.1 genome assembly, chromosome: 1 blastn 12191 139 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
23384876 23384876 PRJNA437204_P_NODE_46599_length_308_cov_1.302128_g46300_i0 PRJNA437204 46599 308 1.302128 4.01055424 Thermoanaerobaculaceae bacterium 2699758 Bacteria Bacteria 52.8 0.029   NTclustered gi|2874254005|emb|OY970330.1| 2699758 g46300 i0 96.774 0.100649350649351 31 1 10 0 31 61 8347319 8347349 MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1 blastn 31 52.8 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia Thermoanaerobaculales Thermoanaerobaculaceae   Thermoanaerobaculaceae bacterium
23385836 23385836 PRJNA437204_P_NODE_96919_length_248_cov_0.880000_g96620_i0 PRJNA437204 96919 248 0.88 2.1824 Thermoanaerobaculaceae bacterium 2699758 Bacteria Bacteria 311 3.35e-80   NTclustered gi|2874254005|emb|OY970330.1| 2699758 g96620 i0 90.456 53.3266129032258 241 16 95 6 1 236 4220454 4220692 MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1 blastn 13225 311 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia Thermoanaerobaculales Thermoanaerobaculaceae   Thermoanaerobaculaceae bacterium
24659744 24659744 PRJNA437204_P_NODE_87340_length_250_cov_0.870056_g87041_i0 PRJNA437204 87340 250 0.870056 2.17514 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 60.2 1.35e-4   NTclustered gi|2621701418|emb|OY760136.1| 2910147 g87041 i0 97.143 1.076 35 1 14 0 63 97 2645198 2645232 MAG: Vicinamibacterales bacterium isolate f9e760c9-8bbe-4e76-9a0a-40d6f1fb97b8 genome assembly, chromosome: 1 blastn 269 60.2 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales 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);;