RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA674308" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 5 ✖

tax_phylum 1

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA674308 · 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
8819791 8819791 PRJNA674308_P_NODE_54747_length_152_cov_2.669903_g54512_i0 PRJNA674308 54747 152 2.669903 4.05825256 Halococcus 2249 Archaea Archaea 281 1.46e-71   NTclustered gi|2457522957|gb|OQ621512.1| 29286 g54512 i0 100 99.9078947368421 152 0 100 0 1 152 285 134 Halococcus sp. strain J-116 16S ribosomal RNA gene, partial sequence blastn 15186 281 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus sp.
12123898 12123898 PRJNA674308_P_NODE_14230_length_255_cov_2.242718_g13995_i0 PRJNA674308 14230 255 2.242718 5.7189309 uncultured marine archaeon 56763 Archaea Archaea 435 1.97e-117   NTclustered gi|166164176|gb|EU377222.1| 56763 g13995 i0 97.276 99.5019607843137 257 5 100 2 1 255 735 479 Uncultured marine archaeon clone Au-Fg10-Arch17 16S ribosomal RNA gene, partial sequence blastn 25373 435 1 Archaea               uncultured marine archaeon
21047250 21047250 PRJNA674308_P_NODE_30537_length_183_cov_1.320896_g30302_i0 PRJNA674308 30537 183 1.320896 2.41723968 Halomarina litorea 2961595 Archaea Archaea 303 3.9e-78   NTclustered gi|2270268912|gb|CP100448.1| 2961595 g30302 i0 96.703 13.3606557377049 182 6 99 0 2 183 361287 361106 Halomarina litorea strain BCD28 chromosome, complete genome blastn 2445 303 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Halomarina Halomarina litorea
21047483 21047483 PRJNA674308_P_NODE_6057_length_386_cov_1.670623_g5822_i0 PRJNA674308 6057 386 1.670623 6.44860478 Halomarina litorea 2961595 Archaea Archaea 697 0   NTclustered gi|2270268912|gb|CP100448.1| 2961595 g5822 i0 99.223 127.401554404145 386 3 100 0 1 386 363103 363488 Halomarina litorea strain BCD28 chromosome, complete genome blastn 49177 697 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Halomarina Halomarina litorea
23597403 23597403 PRJNA674308_P_NODE_11599_length_281_cov_1.142241_g11364_i0 PRJNA674308 11599 281 1.142241 3.20969721 Halomarina sp. 1977540 Archaea Archaea 475 1.2999999999999999e-129   NTclustered gi|2734853425|gb|PP819376.1| 1977540 g11364 i0 98.872 97.5978647686833 266 3 95 0 1 266 1298 1033 Halomarina sp. strain BHT-6 16S ribosomal RNA gene, partial sequence blastn 27425 475 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Halomarina Halomarina sp.

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