RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA993416" 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

  • PRJNA993416 · 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
16278680 16278680 PRJNA993416_P_NODE_15433_length_243_cov_0.905882_g15328_i0 PRJNA993416 15433 243 0.905882 2.20129326 Deinococcus sp. VB343 3385567 Bacteria Bacteria 433 6.69e-117   NTclustered gi|2905211496|gb|CP179945.1| 3385567 g15328 i0 98.765 24.8518518518519 243 3 100 0 1 243 2772314 2772072 Deinococcus sp. VB343 chromosome 1, complete sequence blastn 6039 433 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. VB343
18827590 18827590 PRJNA993416_P_NODE_14495_length_245_cov_1.651163_g14390_i0 PRJNA993416 14495 245 1.651163 4.04534935 Deinococcus sp. VB343 3385567 Bacteria Bacteria 453 5.1900000000000006e-123   NTclustered gi|2905211496|gb|CP179945.1| 3385567 g14390 i0 100 2 245 0 100 0 1 245 849564 849808 Deinococcus sp. VB343 chromosome 1, complete sequence blastn 490 453 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. VB343
20102542 20102542 PRJNA993416_P_NODE_9356_length_280_cov_1.164251_g9251_i0 PRJNA993416 9356 280 1.164251 3.2599028 Deinococcus gobiensis 502394 Bacteria Bacteria 501 2.13e-137   NTclustered gi|379998737|gb|CP002191.1| 745776 g9251 i0 98.929 12.9285714285714 280 3 100 0 1 280 851213 850934 Deinococcus gobiensis I-0, complete genome blastn 3620 501 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus gobiensis

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