RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA946307", tax_clade = "Luna-1 subcluster" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 4 ✖

tax_kingdom 1

tax_clade 1

  • Luna-1 subcluster · 4 ✖

bioproject 1

  • PRJNA946307 · 4 ✖

analysis 1

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
1260916 1260916 PRJNA946307_P_NODE_8501_length_472_cov_1563.472813_g7678_i0 PRJNA946307 8501 472 1563.472813 7379.59167736 Aquiluna 529881 Bacteria Bacteria 610 6.0399999999999996e-170   NTclustered gi|1850312474|gb|CP054056.1| 2499157 g7678 i0 90.693 170.427966101695 462 37 97 6 15 472 855010 854551 Aquiluna borgnonia strain 15G-AUS-rot chromosome, complete genome blastn 80442 610 1 Bacteria Luna-1 subcluster Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Aquiluna Aquiluna borgnonia
2200829 2200829 PRJNA946307_P_NODE_10002_length_425_cov_1869.750000_g9155_i0 PRJNA946307 10002 425 1869.75 7946.4375 Aquiluna borgnonia 2499157 Bacteria Bacteria 531 4.32e-146   NTclustered gi|1850312474|gb|CP054056.1| 2499157 g9155 i0 89.252 179.557647058824 428 41 100 5 1 425 854572 854997 Aquiluna borgnonia strain 15G-AUS-rot chromosome, complete genome blastn 76312 531 1 Bacteria Luna-1 subcluster Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Aquiluna Aquiluna borgnonia
2203432 2203432 PRJNA946307_P_NODE_9282_length_446_cov_2063.979849_g8444_i0 PRJNA946307 9282 446 2063.979849 9205.35012654 Aquiluna borgnonia 2499157 Bacteria Bacteria 575 2.0699999999999995e-159   NTclustered gi|1850312474|gb|CP054056.1| 2499157 g8444 i0 89.978 178.367713004484 449 40 100 5 1 446 854551 854997 Aquiluna borgnonia strain 15G-AUS-rot chromosome, complete genome blastn 79552 575 1 Bacteria Luna-1 subcluster Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Aquiluna Aquiluna borgnonia
6031362 6031362 PRJNA946307_P_NODE_9385_length_443_cov_1607.195431_g8546_i0 PRJNA946307 9385 443 1607.195431 7119.87575933 Aquiluna borgnonia 2499157 Bacteria Bacteria 540 7.499999999999998e-149   NTclustered gi|1850312474|gb|CP054056.1| 2499157 g8546 i0 88.767 178.769751693002 454 33 100 13 1 443 854997 854551 Aquiluna borgnonia strain 15G-AUS-rot chromosome, complete genome blastn 79195 540 1 Bacteria Luna-1 subcluster Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Aquiluna Aquiluna borgnonia

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