RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA743294" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA743294 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
721966 721966 PRJNA743294_P_NODE_25341_length_327_cov_2.405512_g24885_i0 PRJNA743294 25341 327 2.405512 7.86602424 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 566 8.879999999999998e-157   NTclustered gi|112980873|gb|DQ829677.1| 171953 g24885 i0 97.859 208.415902140673 327 7 100 0 1 327 1944 1618 Uncultured Acidobacteria bacterium clone DON3 23S ribosomal RNA gene, partial sequence blastn 68152 566 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
3273345 3273345 PRJNA743294_P_NODE_30823_length_300_cov_2.044053_g30367_i0 PRJNA743294 30823 300 2.044053 6.132159 Tunturiibacter psychrotolerans 3069686 Bacteria Bacteria 87.9 7.65e-13   NTclustered gi|2750702178|gb|CP132942.1| 3069686 g30367 i0 96.226 0.46 53 2 18 0 188 240 5381513 5381565 Tunturiibacter psychrotolerans strain X5P6 chromosome blastn 138 87.9 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Tunturiibacter Tunturiibacter psychrotolerans
4550488 4550488 PRJNA743294_P_NODE_24564_length_332_cov_1.196911_g24108_i0 PRJNA743294 24564 332 1.196911 3.97374452 Luteitalea pratensis 1855912 Bacteria Bacteria 536 7.079999999999999e-148   NTclustered gi|1016914409|gb|CP015136.1| 1855912 g24108 i0 97.749 129.430722891566 311 7 94 0 3 313 653291 653601 Luteitalea pratensis strain DSM 100886 chromosome, complete genome blastn 42971 536 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales Vicinamibacteraceae Luteitalea Luteitalea pratensis
14750933 14750933 PRJNA743294_P_NODE_30352_length_302_cov_2.017467_g29896_i0 PRJNA743294 30352 302 2.017467 6.09275034 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 209 1.58e-49   NTclustered gi|2874253709|emb|OY969474.1| 171953 g29896 i0 83.945 44.5662251655629 218 35 72 0 68 285 4851118 4850901 MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1 blastn 13459 209 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
16024594 16024594 PRJNA743294_P_NODE_28973_length_308_cov_6.157447_g28517_i0 PRJNA743294 28973 308 6.157447 18.96493676 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 255 2.04e-63   NTclustered gi|217038917|gb|EU811008.1| 171953 g28517 i0 81.818 260.36038961039 308 52 99 3 1 306 387 82 Uncultured Acidobacteria bacterium clone 01QCW 23S ribosomal RNA gene, partial sequence blastn 80191 255 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
17300405 17300405 PRJNA743294_P_NODE_8414_length_542_cov_3.157783_g7958_i0 PRJNA743294 8414 542 3.157783 17.11518386 uncultured Granulicella sp. 1241325 Bacteria Bacteria 433 1.63e-116   NTclustered gi|2626255659|emb|OY843766.1| 1241325 g7958 i0 86.667 94.7970479704797 390 52 72 0 152 541 2345179 2344790 MAG: uncultured Granulicella sp. isolate e6d70442-04f8-4699-a368-e2225de37168 genome assembly, chromosome: 1 blastn 51380 433 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Granulicella uncultured Granulicella sp.

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