RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA599208 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
6950492 6950492 PRJNA599208_P_NODE_2846_length_523_cov_42.631687_g2659_i0 PRJNA599208 2846 523 42.631687 222.96372301 Aquiluna borgnonia 2499157 Bacteria Bacteria 773 0   NTclustered gi|1850312474|gb|CP054056.1| 2499157 g2659 i0 93.524 152.889101338432 525 24 100 6 1 523 855924 856440 Aquiluna borgnonia strain 15G-AUS-rot chromosome, complete genome blastn 79961 773 1 Bacteria Luna-1 subcluster Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Aquiluna Aquiluna borgnonia
8794284 8794284 PRJNA599208_P_NODE_6727_length_290_cov_149.750988_g6531_i0 PRJNA599208 6727 290 149.750988 434.2778652 Aquiluna 529881 Bacteria Bacteria 470 6.259999999999999e-128   NTclustered gi|1850312474|gb|CP054056.1| 2499157 g6531 i0 95.862 177.658620689655 290 12 100 0 1 290 854420 854709 Aquiluna borgnonia strain 15G-AUS-rot chromosome, complete genome blastn 51521 470 1 Bacteria Luna-1 subcluster Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Aquiluna Aquiluna borgnonia
12051432 12051432 PRJNA599208_P_NODE_4630_length_379_cov_286.210526_g4435_i0 PRJNA599208 4630 379 286.210526 1084.73789354 Aquiluna borgnonia 2499157 Bacteria Bacteria 627 4.7199999999999986e-175   NTclustered gi|1850312474|gb|CP054056.1| 2499157 g4435 i0 96.579 294.617414248021 380 9 99 4 1 378 855910 855533 Aquiluna borgnonia strain 15G-AUS-rot chromosome, complete genome blastn 111660 627 1 Bacteria Luna-1 subcluster Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Aquiluna Aquiluna borgnonia
13895488 13895488 PRJNA599208_P_NODE_15671_length_156_cov_103.184874_g15475_i0 PRJNA599208 15671 156 103.184874 160.96840344 Microbacteriaceae 85023 Bacteria Bacteria 267 4.2199999999999997e-67   NTclustered gi|1666461687|gb|CP040509.1| 232537 g15475 i0 97.436 179.641025641026 156 4 100 0 1 156 477551 477706 Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome blastn 28024 267 1 Bacteria Luna-1 subcluster Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Rhodoluna Rhodoluna limnophila
19698738 19698738 PRJNA599208_P_NODE_2036_length_642_cov_104.515702_g1870_i0 PRJNA599208 2036 642 104.515702 670.99080684 Candidatus Aquiluna sp. UB-MaderosW2red 1855377 Bacteria Bacteria 732 0   NTclustered gi|1081426101|emb|LT627734.1| 1855377 g1870 i0 89.673 247.216510903427 581 50 90 9 67 641 1310289 1309713 Candidatus Aquiluna sp. UB-MaderosW2red genome assembly, chromosome: I blastn 158713 732 1 Bacteria Luna-1 subcluster Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Aquiluna Candidatus Aquiluna sp. UB-MaderosW2red
22818613 22818613 PRJNA599208_P_NODE_13078_length_178_cov_1.078014_g12882_i0 PRJNA599208 13078 178 1.078014 1.91886492 Aquiluna 529881 Bacteria Bacteria 108 3.17e-19   NTclustered gi|1850312474|gb|CP054056.1| 2499157 g12882 i0 85.577 103.893258426966 104 14 58 1 75 178 856138 856240 Aquiluna borgnonia strain 15G-AUS-rot chromosome, complete genome blastn 18493 108 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);;