RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA867519" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 3 ✖

bioproject 1

  • PRJNA867519 · 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
8500944 8500944 PRJNA867519_P_NODE_16987_length_289_cov_1.388889_g16833_i0 PRJNA867519 16987 289 1.388889 4.01388921 Deinococcus puniceus 1182568 Bacteria Bacteria 401 2.3099999999999993e-107   NTclustered gi|1028459476|gb|CP011387.1| 1182568 g16833 i0 91.696 17.121107266436 289 24 100 0 1 289 415757 416045 Deinococcus puniceus strain DY1, complete genome blastn 4948 401 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus puniceus
9776142 9776142 PRJNA867519_P_NODE_33288_length_241_cov_1.505952_g33134_i0 PRJNA867519 33288 241 1.505952 3.62934432 Deinococcus sp. KNUC1210 2917691 Bacteria Bacteria 407 4.0199999999999995e-109   NTclustered gi|2197029603|gb|CP092190.1| 2917691 g33134 i0 97.095 1 241 7 100 0 1 241 122037 121797 Deinococcus sp. KNUC1210 chromosome, complete genome blastn 241 407 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. KNUC1210
14876021 14876021 PRJNA867519_P_NODE_13492_length_318_cov_1.428571_g13338_i0 PRJNA867519 13492 318 1.428571 4.54285578 Thermus brockianus 56956 Bacteria Bacteria 54.7 0.008   NTclustered gi|1102955210|gb|CP016312.1| 56956 g13338 i0 92.5 0.251572327044025 40 0 12 3 124 161 283075 283113 Thermus brockianus strain GE-1 chromosome, complete genome blastn 80 54.7 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus brockianus

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