RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1031674" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Archaea · 4 ✖

bioproject 1

  • PRJNA1031674 · 4 ✖

analysis 1

  • blastn · 4 ✖

tax_clade 0

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
8660031 8660031 PRJNA1031674_P_NODE_27167_length_242_cov_1.473373_g26956_i0 PRJNA1031674 27167 242 1.473373 3.56556266 Archaea 2157 Archaea Archaea 276 1.19e-69   NTclustered gi|42557759|emb|AJ627422.1| 29281 g26956 i0 87.19 17.5247933884298 242 31 100 0 1 242 40881 41122 Uncultured crenarchaeote genomic fragment 54d9 blastn 4241 276 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
11210261 11210261 PRJNA1031674_P_NODE_6549_length_341_cov_1.555970_g6338_i0 PRJNA1031674 6549 341 1.55597 5.3058577 root 1 Root_unresolved Root_unresolved 625 1.5099999999999995e-174   NTclustered gi|436492|gb|U00707.1|PSU00707 33866 g6338 i0 99.707 10.158357771261 341 1 100 0 1 341 3690 4030 Pyrococcus sp. Deep Vent DNA polymerase precursor gene, complete cds blastn 3464 625 1 Archaea   Methanobacteriati Methanobacteriota Thermococci Thermococcales Thermococcaceae Pyrococcus Pyrococcus sp.
11645437 11645437 PRJNA1031674_P_NODE_5710_length_358_cov_2.722807_g5500_i0 PRJNA1031674 5710 358 2.722807 9.74764906 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 656 0   NTclustered gi|937513727|gb|CP012850.1| 1353260 g5500 i0 99.721 18.8687150837989 358 1 100 0 1 358 849227 849584 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 6755 656 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
12920590 12920590 PRJNA1031674_P_NODE_6211_length_348_cov_1.076364_g6000_i0 PRJNA1031674 6211 348 1.076364 3.74574672 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 551 2.669999999999999e-152   NTclustered gi|937513727|gb|CP012850.1| 1353260 g6000 i0 95.402 43.7931034482759 348 13 100 2 1 348 848437 848093 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 15240 551 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus

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