RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA781453", tax_phylum = "Deinococcota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 4 ✖

tax_phylum 1

  • Deinococcota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA781453 · 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
762856 762856 PRJNA781453_P_NODE_35001_length_248_cov_0.880000_g34886_i0 PRJNA781453 35001 248 0.88 2.1824 Thermus sp. NEB1569 2918899 Bacteria Bacteria 375 1.1699999999999999e-99   NTclustered gi|2199052145|gb|CP092445.1| 2918899 g34886 i0 93.952 9.18548387096774 248 15 100 0 1 248 2072079 2071832 Thermus sp. NEB1569 chromosome, complete genome blastn 2278 375 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus sp. NEB1569
12242640 12242640 PRJNA781453_P_NODE_4990_length_670_cov_1.892797_g4884_i0 PRJNA781453 4990 670 1.892797 12.6817399 Deinococcus aquaticus 328692 Bacteria Bacteria 977 0   NTclustered gi|2444120906|gb|CP115165.1| 328692 g4884 i0 92.985 10.5611940298507 670 47 100 0 1 670 1758152 1757483 Deinococcus aquaticus strain PB-314 chromosome, complete genome blastn 7076 977 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquaticus
14790691 14790691 PRJNA781453_P_NODE_11572_length_436_cov_2.457300_g11458_i0 PRJNA781453 11572 436 2.4573 10.713828 Deinococcus grandis 57498 Bacteria Bacteria 601 3.3299999999999996e-167   NTclustered gi|1751871007|dbj|AP021849.1| 57498 g11458 i0 91.514 4.17660550458716 436 37 100 0 1 436 3016038 3016473 Deinococcus grandis ATCC 43672 DNA, complete genome blastn 1821 601 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis
27274894 27274894 PRJNA781453_P_NODE_31483_length_253_cov_1.516667_g31368_i0 PRJNA781453 31483 253 1.516667 3.83716751 Truepera radiovictrix 332249 Bacteria Bacteria 52 2.29e-5   NR WP_013178266.1 332249 g31368 i0 40.5 0.936758893280632 79 44 92.5 2 20 253 240 316 WP_013178266.1 Ig-like domain-containing protein [Truepera radiovictrix] diamond 237 52 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix

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