RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA674048" and tax_clade = "Luna-1 subcluster"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Luna-1 subcluster · 5 ✖

bioproject 1

  • PRJNA674048 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
3193923 3193923 PRJNA674048_P_NODE_13563_length_245_cov_10.775510_g13360_i0 PRJNA674048 13563 245 10.77551 26.3999995 Rhodoluna lacicola 529884 Bacteria Bacteria 429 8.739999999999998e-116   NTclustered gi|649018083|gb|CP007490.1| 529884 g13360 i0 98.361 163.49387755102 244 4 99 0 1 244 520215 519972 Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome blastn 40056 429 1 Bacteria Luna-1 subcluster Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Rhodoluna Rhodoluna lacicola
8296417 8296417 PRJNA674048_P_NODE_2487_length_730_cov_28.703377_g2333_i0 PRJNA674048 2487 730 28.703377 209.5346521 Rhodoluna lacicola 529884 Bacteria Bacteria 1343 0   NTclustered gi|649018083|gb|CP007490.1| 529884 g2333 i0 99.863 167.408219178082 730 1 100 0 1 730 518304 519033 Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome blastn 122208 1343 1 Bacteria Luna-1 subcluster Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Rhodoluna Rhodoluna lacicola
13397149 13397149 PRJNA674048_P_NODE_14471_length_236_cov_2.117647_g14268_i0 PRJNA674048 14471 236 2.117647 4.99764692 Aquiluna borgnonia 2499157 Bacteria Bacteria 414 2.34e-111   NTclustered gi|1850312474|gb|CP054056.1| 2499157 g14268 i0 98.305 141.131355932203 236 4 100 0 1 236 855997 856232 Aquiluna borgnonia strain 15G-AUS-rot chromosome, complete genome blastn 33307 414 1 Bacteria Luna-1 subcluster Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Aquiluna Aquiluna borgnonia
17221089 17221089 PRJNA674048_P_NODE_15114_length_230_cov_2.828729_g14911_i0 PRJNA674048 15114 230 2.828729 6.5060767 Aquiluna borgnonia 2499157 Bacteria Bacteria 403 4.92e-108   NTclustered gi|1850312474|gb|CP054056.1| 2499157 g14911 i0 98.261 276.882608695652 230 4 100 0 1 230 856190 856419 Aquiluna borgnonia strain 15G-AUS-rot chromosome, complete genome blastn 63683 403 1 Bacteria Luna-1 subcluster Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Aquiluna Aquiluna borgnonia
24117922 24117922 PRJNA674048_P_NODE_2339_length_758_cov_98.297602_g2187_i0 PRJNA674048 2339 758 98.297602 745.09582316 Microbacteriaceae 85023 Bacteria Bacteria 684 0   NTclustered gi|1666461687|gb|CP040509.1| 232537 g2187 i0 99.208 186.34036939314 379 3 98 0 379 757 478931 479309 Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome blastn 141246 684 1 Bacteria Luna-1 subcluster Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Rhodoluna Rhodoluna limnophila

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