RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA558770" 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 · 4 ✖

bioproject 1

  • PRJNA558770 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
539923 539923 PRJNA558770_P_NODE_245461_length_234_cov_2.412060_g243456_i0 PRJNA558770 245461 234 2.41206 5.6442204 Aquiluna sp. KACHI24 2968831 Bacteria Bacteria 78.7 3.46e-10   NTclustered gi|2283401075|dbj|AP026677.1| 2968831 g243456 i0 91.228 1.6709401709401701 57 5 24 0 3 59 405725 405781 Aquiluna sp. KACHI24 DNA, complete genome blastn 391 78.7 1 Bacteria Luna-1 subcluster Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Aquiluna Aquiluna sp. KACHI24
10744103 10744103 PRJNA558770_P_NODE_239469_length_234_cov_2.552764_g237464_i0 PRJNA558770 239469 234 2.552764 5.97346776 Candidatus Rhodoluna planktonica 535712 Bacteria Bacteria 121 5.66e-23   NTclustered gi|1092201385|gb|CP015208.1| 535712 g237464 i0 95.946 2.31196581196581 74 3 32 0 2 75 1178578 1178505 Candidatus Rhodoluna planktonica strain MWH-Dar1 chromosome, complete genome blastn 541 121 1 Bacteria Luna-1 subcluster Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Rhodoluna Candidatus Rhodoluna planktonica
10745359 10745359 PRJNA558770_P_NODE_324709_length_233_cov_7.595960_g322704_i0 PRJNA558770 324709 233 7.59596 17.6985868 Aquiluna borgnonia 2499157 Bacteria Bacteria 401 1.7999999999999993e-107   NTclustered gi|1850312474|gb|CP054056.1| 2499157 g322704 i0 97.845 152.532188841202 232 5 99 0 1 232 856112 856343 Aquiluna borgnonia strain 15G-AUS-rot chromosome, complete genome blastn 35540 401 1 Bacteria Luna-1 subcluster Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Aquiluna Aquiluna borgnonia
24765047 24765047 PRJNA558770_P_NODE_181340_length_234_cov_4.582915_g179335_i0 PRJNA558770 181340 234 4.582915 10.7240211 Rhodoluna lacicola 529884 Bacteria Bacteria 111 3.41e-20   NTclustered gi|649018083|gb|CP007490.1| 529884 g179335 i0 95.652 0.58974358974359 69 3 29 0 162 230 47101 47169 Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome blastn 138 111 1 Bacteria Luna-1 subcluster Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Rhodoluna Rhodoluna lacicola

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