RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1195374" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 7 ✖

bioproject 1

  • PRJNA1195374 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
1596195 1596195 PRJNA1195374_P_NODE_38762_length_360_cov_0.972125_g38418_i0 PRJNA1195374 38762 360 0.972125 3.49965 Deinococcus ficus 317577 Bacteria Bacteria 590 5.849999999999998e-164   NTclustered gi|1220362168|gb|CP021081.1| 317577 g38418 i0 98.225 362.561111111111 338 4 94 2 2 338 2341734 2342070 Deinococcus ficus strain CC-FR2-10, complete genome blastn 130522 590 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus ficus
6699280 6699280 PRJNA1195374_P_NODE_32626_length_395_cov_1.434783_g32282_i0 PRJNA1195374 32626 395 1.434783 5.66739285 Deinococcus metallilatus 1211322 Bacteria Bacteria 52.8 0.038   NTclustered gi|1609451317|gb|CP038512.1| 1211322 g32282 i0 100 0.0708860759493671 28 0 7 0 81 108 2220095 2220068 Deinococcus metallilatus strain MA1002 chromosome blastn 28 52.8 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus metallilatus
8695991 8695991 PRJNA1195374_P_NODE_8407_length_754_cov_1.602056_g8099_i0 PRJNA1195374 8407 754 1.602056 12.07950224 Deinococcus 1298 Bacteria Bacteria 56.5 0.006   NTclustered gi|1735477873|gb|CP031501.1| 1299 g8099 i0 100 0.635278514588859 30 0 4 0 209 238 236605 236576 Deinococcus radiodurans strain R1 dM1 chromosome II, complete sequence blastn 479 56.5 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiodurans
10525044 10525044 PRJNA1195374_P_NODE_27909_length_429_cov_2.323034_g27565_i0 PRJNA1195374 27909 429 2.323034 9.96581586 Thermus oshimai 56957 Bacteria Bacteria 56.5 0.003   NTclustered gi|2894814231|gb|CP178485.1| 56957 g27565 i0 97.059 0.144522144522145 34 0 8 1 127 159 750517 750484 Thermus oshimai strain Blanco chromosome, complete genome blastn 62 56.5 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus oshimai
19448286 19448286 PRJNA1195374_P_NODE_74696_length_248_cov_1.760000_g74352_i0 PRJNA1195374 74696 248 1.76 4.3648 Deinococcus actinosclerus 1768108 Bacteria Bacteria 174 4.59e-39   NTclustered gi|972944657|gb|CP013910.1| 1768108 g74352 i0 81.481 59.6572580645161 216 36 86 4 18 231 2204291 2204078 Deinococcus actinosclerus strain BM2 chromosome, complete genome blastn 14795 174 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus actinosclerus
21444733 21444733 PRJNA1195374_P_NODE_51657_length_305_cov_1.099138_g51313_i0 PRJNA1195374 51657 305 1.099138 3.3523709 Deinococcus 1298 Bacteria Bacteria 553 6.39e-153   NTclustered gi|1219686863|gb|MF524660.1| 47478 g51313 i0 99.344 103.373770491803 305 2 100 0 1 305 75 379 Deinococcus sp. strain MadaFrogSkinBac.DB-.3438 16S ribosomal RNA gene, partial sequence blastn 31529 553 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
23994984 23994984 PRJNA1195374_P_NODE_59699_length_281_cov_0.826923_g59355_i0 PRJNA1195374 59699 281 0.826923 2.32365363 Thermus 270 Bacteria Bacteria 52.8 0.026   NTclustered gi|320149275|gb|CP001962.1| 743525 g59355 i0 100 0.298932384341637 28 0 10 0 71 98 2011805 2011832 Thermus scotoductus SA-01, complete genome blastn 84 52.8 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus scotoductus

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