RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJEB80557" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 3 ✖

tax_phylum 1

tax_kingdom 1

bioproject 1

  • PRJEB80557 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
9924604 9924604 PRJEB80557_S_NODE_29308_length_178_cov_2062.744186_g28912_i0 PRJEB80557 29308 178 2062.744186 3671.68465108 root 1 Root_unresolved Root_unresolved 78.7 2.48e-10   NTclustered gi|262264245|emb|AM490769.1| 115547 g28912 i0 97.826 4.15730337078652 46 0 25 1 96 140 95 50 Uncultured archaeon 16S rRNA gene, clone SS_LKC22_arch_1 blastn 740 78.7 1 Archaea               uncultured archaeon
9924634 9924634 PRJEB80557_S_NODE_37288_length_161_cov_7769.705357_g36892_i0 PRJEB80557 37288 161 7769.705357 12509.22562477 root 1 Root_unresolved Root_unresolved 86.1 1.32e-12   NTclustered gi|262264245|emb|AM490769.1| 115547 g36892 i0 100 28.6273291925466 46 0 29 0 21 66 50 95 Uncultured archaeon 16S rRNA gene, clone SS_LKC22_arch_1 blastn 4609 86.1 1 Archaea               uncultured archaeon
20540046 20540046 PRJEB80557_S_NODE_27017_length_185_cov_5.551471_g26621_i0 PRJEB80557 27017 185 5.551471 10.27022135 Vulcanisaeta moutnovskia 985052 Archaea Archaea 52.8 0.016   NTclustered gi|323706731|gb|CP002529.1| 985053 g26621 i0 100 0.151351351351351 28 0 15 0 48 75 336127 336100 Vulcanisaeta moutnovskia 768-28, complete genome blastn 28 52.8 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Vulcanisaeta Vulcanisaeta moutnovskia

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