RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA806354" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 4 ✖

bioproject 1

  • PRJNA806354 · 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
805906 805906 PRJNA806354_P_NODE_13021_length_393_cov_1.431250_g12912_i0 PRJNA806354 13021 393 1.43125 5.6248125 Deinococcus sp. NW-56 2080419 Bacteria Bacteria 682 0   NTclustered gi|1339790003|gb|CP026516.1| 2080419 g12912 i0 98.698 315.094147582697 384 5 98 0 1 384 544149 544532 Deinococcus sp. NW-56 chromosome, complete genome blastn 123832 682 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. NW-56
7184301 7184301 PRJNA806354_P_NODE_35766_length_250_cov_0.870056_g35657_i0 PRJNA806354 35766 250 0.870056 2.17514 Deinococcus aetherius 200252 Bacteria Bacteria 357 4.28e-94   NTclustered gi|2281894955|dbj|AP026560.1| 200252 g35657 i0 92.49 173.028 253 13 100 5 1 250 82022 81773 Deinococcus aetherius ST0316 DNA, complete genome blastn 43257 357 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aetherius
9734098 9734098 PRJNA806354_P_NODE_36008_length_250_cov_0.870056_g35899_i0 PRJNA806354 36008 250 0.870056 2.17514 Thermus thermophilus 274 Bacteria Bacteria 429 8.949999999999998e-116   NTclustered gi|1955389301|dbj|AP024307.1| 274 g35899 i0 97.6 10.052 250 6 100 0 1 250 2278 2029 Thermus thermophilus HB5008 plasmid pHB5008c DNA, complete sequence blastn 2513 429 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus thermophilus
25449015 25449015 PRJNA806354_P_NODE_19860_length_326_cov_1.205534_g19751_i0 PRJNA806354 19860 326 1.205534 3.93004084 Deinococcus 1298 Bacteria Bacteria 457 5.56e-124   NTclustered gi|1751871007|dbj|AP021849.1| 57498 g19751 i0 94.333 195.733128834356 300 14 99 3 25 323 423781 423484 Deinococcus grandis ATCC 43672 DNA, complete genome blastn 63809 457 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis

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