RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA478247" and tax_kingdom = "Bacillati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Bacillati · 8 ✖

bioproject 1

  • PRJNA478247 · 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
1097152 1097152 PRJNA478247_P_NODE_3241_length_165_cov_2.536765_g3135_i0 PRJNA478247 3241 165 2.536765 4.18566225 Blastococcus 38501 Bacteria Bacteria 305 9.59e-79   NTclustered gi|507148190|ref|NR_102997.1| 138336 g3135 i0 100 391.236363636364 165 0 100 0 1 165 2345 2509 Blastococcus saxobsidens strain DD2 23S ribosomal RNA gene, complete sequence blastn 64554 305 1 Bacteria   Bacillati Actinomycetota Actinomycetes Geodermatophilales Geodermatophilaceae Blastococcus Blastococcus saxobsidens
3648284 3648284 PRJNA478247_P_NODE_1603_length_290_cov_2.900383_g1497_i0 PRJNA478247 1603 290 2.900383 8.4111107 Arthrobacter 1663 Bacteria Bacteria 433 8.21e-117   NTclustered gi|2921126289|gb|CP102608.1| 619291 g1497 i0 95.273 311.662068965517 275 10 94 3 1 274 459350 459078 Arthrobacter sp. N1 chromosome, complete genome blastn 90382 433 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Arthrobacter Arthrobacter sp. N1
10025457 10025457 PRJNA478247_P_NODE_3508_length_154_cov_5.672000_g3402_i0 PRJNA478247 3508 154 5.672 8.73488 Bacillati 1783272 Bacteria Bacteria 270 3.2099999999999992e-68   NTclustered gi|1883577788|gb|CP059343.1| 1272 g3402 i0 100 124.038961038961 146 0 95 0 1 146 1048593 1048448 Kocuria varians strain 80 chromosome, complete genome blastn 19102 272 0.992647058823529 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Kocuria Kocuria varians
18299347 18299347 PRJNA478247_P_NODE_2955_length_180_cov_2.066225_g2849_i0 PRJNA478247 2955 180 2.066225 3.719205 Friedmanniella luteola 546871 Bacteria Bacteria 300 4.94e-77   NTclustered gi|1085823321|emb|LT629749.1| 546871 g2849 i0 96.667 350.127777777778 180 6 100 0 1 180 1464051 1463872 Friedmanniella luteola strain DSM 21741 genome assembly, chromosome: I blastn 63023 300 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Friedmanniella Friedmanniella luteola
18948640 18948640 PRJNA478247_P_NODE_1175_length_364_cov_3.570149_g1069_i0 PRJNA478247 1175 364 3.570149 12.99534236 Gordonia 2053 Bacteria Bacteria 516 1.02e-141   NTclustered gi|2714293900|gb|CP136137.1| 40516 g1069 i0 95.107 372.656593406593 327 16 91 0 38 364 3354 3028 Gordonia hydrophobica strain 1610/1b chromosome blastn 135647 516 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Gordoniaceae Gordonia Gordonia hydrophobica
20849381 20849381 PRJNA478247_P_NODE_3277_length_164_cov_1.503704_g3171_i0 PRJNA478247 3277 164 1.503704 2.46607456 Kocuria palustris 71999 Bacteria Bacteria 292 7.41e-75   NTclustered gi|923033569|gb|CP012507.1| 71999 g3171 i0 98.78 321.609756097561 164 2 100 0 1 164 218430 218267 Kocuria palustris strain MU14/1, complete genome blastn 52744 292 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Kocuria Kocuria palustris
24673862 24673862 PRJNA478247_P_NODE_1800_length_265_cov_2.580508_g1694_i0 PRJNA478247 1800 265 2.580508 6.8383462 Kocuria sp. KD4 2719588 Bacteria Bacteria 442 1.2299999999999995e-119   NTclustered gi|1826585035|gb|CP050449.1| 2719588 g1694 i0 98.79 353.449056603774 248 3 94 0 1 248 1836634 1836387 Kocuria sp. KD4 chromosome, complete genome blastn 93664 442 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Kocuria Kocuria sp. KD4
24673869 24673869 PRJNA478247_P_NODE_500_length_640_cov_7.384615_g405_i0 PRJNA478247 500 640 7.384615 47.261536 Streptomyces sp. GQFP 2907545 Bacteria Bacteria 63.9 2.94e-5   NTclustered gi|2181538142|gb|CP089312.1| 2907545 g405 i0 95 0.2828125 40 2 6 0 25 64 7470618 7470579 Streptomyces sp. GQFP chromosome blastn 181 63.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. GQFP

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