RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 4 ✖

bioproject 1

  • PRJNA631119 · 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
7529758 7529758 PRJNA631119_P_NODE_27226_length_264_cov_1.560209_g27108_i0 PRJNA631119 27226 264 1.560209 4.11895176 root 1 Root_unresolved Root_unresolved 488 1.5499999999999999e-133   NTclustered gi|155128|gb|J04639.1|TTHTAQP1A 271 g27108 i0 100 55.5416666666667 264 0 100 0 1 264 1713 1450 Thermus aquaticus DNA polymerase (PolI) gene blastn 14663 488 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus aquaticus
8804844 8804844 PRJNA631119_P_NODE_29747_length_254_cov_2.701657_g29629_i0 PRJNA631119 29747 254 2.701657 6.86220878 Bacteria 2 Bacteria Bacteria 470 5.37e-128   NTclustered gi|155128|gb|J04639.1|TTHTAQP1A 271 g29629 i0 100 47.8976377952756 254 0 100 0 1 254 792 539 Thermus aquaticus DNA polymerase (PolI) gene blastn 12166 470 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus aquaticus
10080324 10080324 PRJNA631119_P_NODE_27048_length_265_cov_1.109375_g26930_i0 PRJNA631119 27048 265 1.109375 2.93984375 Aminithiophilus 3029078 Bacteria Bacteria 135 2.3400000000000003e-27   NTclustered gi|2041259188|gb|CP074691.1| 2268202 g26930 i0 78.605 11.3698113207547 215 38 80 8 1 211 825111 825321 Synergistota bacterium strain L-13 chromosome, complete genome blastn 3013 135 1 Bacteria   Thermotogati Synergistota         Synergistota bacterium
14632243 14632243 PRJNA631119_P_NODE_5252_length_496_cov_3.016548_g5134_i0 PRJNA631119 5252 496 3.016548 14.96207808 Deinococcus ficus 317577 Bacteria Bacteria 54.7 0.013   NTclustered gi|1220365708|gb|CP021084.1| 317577 g5134 i0 100 0.0584677419354839 29 0 6 0 182 210 134507 134479 Deinococcus ficus strain CC-FR2-10 plasmid pDFI3, complete sequence blastn 29 54.7 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus ficus

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