RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJNA207719" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 2 ✖

bioproject 1

  • PRJNA207719 · 2 ✖

analysis 1

  • blastn · 2 ✖

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
1056078 1056078 PRJNA207719_P_NODE_581_length_266_cov_3.611814_g561_i0 PRJNA207719 581 266 3.611814 9.60742524 Deinococcus 1298 Bacteria Bacteria 405 1.62e-108   NTclustered gi|1095429301|gb|KY056229.1| 47478 g561 i0 95.076 134.973684210526 264 2 99 1 3 266 825 573 Deinococcus sp. strain 6004 16S ribosomal RNA gene, partial sequence blastn 35903 405 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
21457773 21457773 PRJNA207719_P_NODE_1117_length_175_cov_4.178082_g1097_i0 PRJNA207719 1117 175 4.178082 7.3116435 Deinococcus 1298 Bacteria Bacteria 158 3.0399999999999992e-34   NTclustered gi|470487735|ref|NR_076834.1| 309887 g1097 i0 95 100.268571428571 100 5 57 0 76 175 1300 1399 Deinococcus maricopensis strain LB-34 23S ribosomal RNA gene, complete sequence blastn 17547 158 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus maricopensis

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