RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA795983 · 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
4608359 4608359 PRJNA795983_S_NODE_14984_length_337_cov_3.098485_g14859_i0 PRJNA795983 14984 337 3.098485 10.44189445 Deinococcus sp. 47478 Bacteria Bacteria 619 6.95e-173   NTclustered gi|2648560497|gb|PP129705.1| 47478 g14859 i0 100 109.816023738872 335 0 99 0 1 335 19 353 Deinococcus sp. strain YIM_134068 16S ribosomal RNA gene, partial sequence blastn 37008 619 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
14808719 14808719 PRJNA795983_S_NODE_32792_length_259_cov_1.553763_g32667_i0 PRJNA795983 32792 259 1.553763 4.02424617 Deinococcus ficus 317577 Bacteria Bacteria 366 7.42e-97   NTclustered gi|1220362168|gb|CP021081.1| 317577 g32667 i0 94.894 227.46332046332 235 11 90 1 10 243 2341602 2341836 Deinococcus ficus strain CC-FR2-10, complete genome blastn 58913 366 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus ficus
16519385 16519385 PRJNA795983_S_NODE_19913_length_308_cov_1.204255_g19788_i0 PRJNA795983 19913 308 1.204255 3.7091054 Deinococcus 1298 Bacteria Bacteria 453 6.75e-123   NTclustered gi|1392964945|gb|CP029494.1| 2202254 g19788 i0 93.226 221.100649350649 310 18 100 3 1 308 396113 395805 Deinococcus irradiatisoli strain 17bor-2 chromosome, complete genome blastn 68099 453 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus irradiatisoli
25006525 25006525 PRJNA795983_S_NODE_28380_length_273_cov_1.445000_g28255_i0 PRJNA795983 28380 273 1.445 3.94485 Deinococcus taeanensis 2737050 Bacteria Bacteria 377 3.64e-100   NTclustered gi|2105694697|gb|CP083456.1| 2737050 g28255 i0 91.667 177.384615384615 276 17 100 3 1 273 1770 1498 Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence blastn 48426 377 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus taeanensis

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