RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1046144" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 5 ✖

bioproject 1

  • PRJNA1046144 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
2723335 2723335 PRJNA1046144_P_NODE_67483_length_227_cov_1.537975_g67188_i0 PRJNA1046144 67483 227 1.537975 3.49120325 Deinococcus wulumuqiensis 980427 Bacteria Bacteria 403 4.85e-108   NTclustered gi|1819261009|gb|CP049357.1| 1288484 g67188 i0 98.678 46.942731277533 227 3 100 0 1 227 660091 660317 Deinococcus wulumuqiensis R12 chromosome, complete genome blastn 10656 403 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus wulumuqiensis
5275733 5275733 PRJNA1046144_P_NODE_70405_length_223_cov_4.103896_g70110_i0 PRJNA1046144 70405 223 4.103896 9.15168808 Deinococcus soli (ex Cha et al. 2016) 1309411 Bacteria Bacteria 412 7.88e-111   NTclustered gi|821341785|gb|CP011389.1| 1309411 g70110 i0 100 229.964125560538 223 0 100 0 1 223 1637240 1637462 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 51282 412 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
7824990 7824990 PRJNA1046144_P_NODE_43787_length_262_cov_1.445596_g43492_i0 PRJNA1046144 43787 262 1.445596 3.78746152 Deinococcus soli (ex Cha et al. 2016) 1309411 Bacteria Bacteria 479 9.249999999999999e-131   NTclustered gi|821341785|gb|CP011389.1| 1309411 g43492 i0 99.618 31.1030534351145 262 1 100 0 1 262 2832830 2833091 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 8149 479 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
10375969 10375969 PRJNA1046144_P_NODE_58189_length_234_cov_0.872727_g57894_i0 PRJNA1046144 58189 234 0.872727 2.04218118 Deinococcus grandis 57498 Bacteria Bacteria 283 6.829999999999999e-72   NTclustered gi|1751874559|dbj|AP021851.1| 57498 g57894 i0 89.177 3.71794871794872 231 20 98 4 6 234 211593 211366 Deinococcus grandis ATCC 43672 plasmid: pDEGR-2 DNA, complete genome blastn 870 283 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis
16749295 16749295 PRJNA1046144_P_NODE_43214_length_263_cov_1.927835_g42919_i0 PRJNA1046144 43214 263 1.927835 5.07020605 Deinococcus grandis 57498 Bacteria Bacteria 464 2.5999999999999993e-126   NTclustered gi|1751871007|dbj|AP021849.1| 57498 g42919 i0 98.485 291.342205323194 264 2 100 2 1 263 73735 73473 Deinococcus grandis ATCC 43672 DNA, complete genome blastn 76623 464 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);;