RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA670521 · 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
8291292 8291292 PRJNA670521_P_NODE_20587_length_416_cov_1.807580_g19844_i0 PRJNA670521 20587 416 1.80758 7.5195328 Thermus brockianus 56956 Bacteria Bacteria 54.7 0.011   NTclustered gi|1102955210|gb|CP016312.1| 56956 g19844 i0 92.5 0.192307692307692 40 0 9 3 355 392 283075 283113 Thermus brockianus strain GE-1 chromosome, complete genome blastn 80 54.7 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus brockianus
12644247 12644247 PRJNA670521_P_NODE_8730_length_603_cov_3.577358_g8000_i0 PRJNA670521 8730 603 3.577358 21.57146874 Bacteria 2 Bacteria Bacteria 1109 0   NTclustered gi|281313262|gb|GU214163.1| 158789 g8000 i0 99.834 105.512437810945 603 1 100 0 1 603 765 163 Uncultured Deinococcus sp. clone IAFpp8j45 16S ribosomal RNA gene, partial sequence blastn 63624 1109 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus uncultured Deinococcus sp.
17216010 17216010 PRJNA670521_P_NODE_12594_length_511_cov_1.237443_g11858_i0 PRJNA670521 12594 511 1.237443 6.32333373 Trueperaceae bacterium 2026798 Bacteria Bacteria 693 0   NTclustered gi|2621706202|emb|OY764543.1| 2026798 g11858 i0 91.085 576.350293542074 516 41 100 4 1 511 2559909 2559394 MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1 blastn 294515 693 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
19016610 19016610 PRJNA670521_P_NODE_53975_length_286_cov_1.516432_g53230_i0 PRJNA670521 53975 286 1.516432 4.33699552 Deinococcus 1298 Bacteria Bacteria 239 1.89e-58   NTclustered gi|485099143|ref|NR_102538.1| 432329 g53230 i0 82.578 384.888111888112 287 34 97 12 7 282 20 301 Deinococcus peraridilitoris strain KR-200 23S ribosomal RNA gene, complete sequence blastn 110078 239 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus peraridilitoris
19765122 19765122 PRJNA670521_P_NODE_57856_length_278_cov_1.009756_g57111_i0 PRJNA670521 57856 278 1.009756 2.80712168 Deinococcus aquaticus 328692 Bacteria Bacteria 453 5.999999999999999e-123   NTclustered gi|2444120906|gb|CP115165.1| 328692 g57111 i0 96.043 200.543165467626 278 11 100 0 1 278 715913 716190 Deinococcus aquaticus strain PB-314 chromosome, complete genome blastn 55751 453 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquaticus

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