RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA560932 · 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
544481 544481 PRJNA560932_P_NODE_19381_length_400_cov_1.293578_g19025_i0 PRJNA560932 19381 400 1.293578 5.174312 Deinococcus actinosclerus 1768108 Bacteria Bacteria 678 0   NTclustered gi|972944657|gb|CP013910.1| 1768108 g19025 i0 98.196 299.775 388 7 97 0 1 388 74314 74701 Deinococcus actinosclerus strain BM2 chromosome, complete genome blastn 119910 678 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus actinosclerus
1130564 1130564 PRJNA560932_P_NODE_22761_length_371_cov_2.302013_g22405_i0 PRJNA560932 22761 371 2.302013 8.54046823 Deinococcus 1298 Bacteria Bacteria 612 1.2899999999999999e-170   NTclustered gi|1192789104|gb|KY744731.1| 47478 g22405 i0 96.486 103.792452830189 370 13 99 0 1 370 365 734 Deinococcus sp. strain 16B18A 16S ribosomal RNA gene, partial sequence blastn 38507 617 0.991896272285251 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
4958670 4958670 PRJNA560932_P_NODE_57324_length_248_cov_0.880000_g56968_i0 PRJNA560932 57324 248 0.88 2.1824 Deinococcus 1298 Bacteria Bacteria 342 1.1899999999999999e-89   NTclustered gi|2706837832|gb|CP149782.1| 3112952 g56968 i0 91.6 2.31451612903226 250 17 100 4 1 248 1882949 1883196 Deinococcus sp. VB142 chromosome 1, complete sequence blastn 574 342 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. VB142
17122319 17122319 PRJNA560932_P_NODE_29194_length_333_cov_1.076923_g28838_i0 PRJNA560932 29194 333 1.076923 3.58615359 Deinococcus actinosclerus 1768108 Bacteria Bacteria 538 1.98e-148   NTclustered gi|972944657|gb|CP013910.1| 1768108 g28838 i0 95.796 201.873873873874 333 14 100 0 1 333 3086361 3086029 Deinococcus actinosclerus strain BM2 chromosome, complete genome blastn 67224 538 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus actinosclerus
18396405 18396405 PRJNA560932_P_NODE_19815_length_396_cov_0.897833_g19459_i0 PRJNA560932 19815 396 0.897833 3.55541868 Deinococcus taeanensis 2737050 Bacteria Bacteria 575 1.8199999999999995e-159   NTclustered gi|2105694697|gb|CP083456.1| 2737050 g19459 i0 92.965 235.136363636364 398 23 100 5 1 396 1900 1506 Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence blastn 93114 575 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus taeanensis
24770774 24770774 PRJNA560932_P_NODE_16940_length_427_cov_1.584746_g16584_i0 PRJNA560932 16940 427 1.584746 6.76686542 Meiothermus ruber 277 Bacteria Bacteria 52.8 0.041   NTclustered gi|290469363|gb|CP001743.1| 504728 g16584 i0 100 0.131147540983607 28 0 7 0 102 129 1397038 1397011 Meiothermus ruber DSM 1279, complete genome blastn 56 52.8 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Meiothermus Meiothermus ruber
25356844 25356844 PRJNA560932_P_NODE_13360_length_479_cov_1.103448_g13006_i0 PRJNA560932 13360 479 1.103448 5.28551592 Deinococcus 1298 Bacteria Bacteria 863 0   NTclustered gi|2706837832|gb|CP149782.1| 3112952 g13006 i0 99.165 192.129436325678 479 4 100 0 1 479 1455448 1454970 Deinococcus sp. VB142 chromosome 1, complete sequence blastn 92030 863 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. VB142

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