RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA312107", 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 · 3 ✖

tax_kingdom 1

tax_clade 1

  • Luna-1 subcluster · 3 ✖

bioproject 1

  • PRJNA312107 · 3 ✖

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
2928173 2928173 PRJNA312107_P_NODE_15063_length_188_cov_1.496403_g14897_i0 PRJNA312107 15063 188 1.496403 2.81323764 Rhodoluna lacicola 529884 Bacteria Bacteria 248 1.91e-61   NTclustered gi|649018083|gb|CP007490.1| 529884 g14897 i0 90.86 4.49468085106383 186 15 98 1 5 188 919589 919404 Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome blastn 845 248 1 Bacteria Luna-1 subcluster Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Rhodoluna Rhodoluna lacicola
4891448 4891448 PRJNA312107_P_NODE_13024_length_202_cov_1.836601_g12858_i0 PRJNA312107 13024 202 1.836601 3.70993402 Rhodoluna 529883 Bacteria Bacteria 346 7.2e-91   NTclustered gi|1666461687|gb|CP040509.1| 232537 g12858 i0 97.525 184.420792079208 202 5 100 0 1 202 478415 478616 Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome blastn 37253 346 1 Bacteria Luna-1 subcluster Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Rhodoluna Rhodoluna limnophila
15091344 15091344 PRJNA312107_P_NODE_18452_length_169_cov_2.166667_g18286_i0 PRJNA312107 18452 169 2.166667 3.66166723 Rhodoluna 529883 Bacteria Bacteria 279 5.95e-71   NTclustered gi|1666461687|gb|CP040509.1| 232537 g18286 i0 96.45 241.449704142012 169 6 100 0 1 169 477885 478053 Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome blastn 40805 279 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);;