RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA533623" and tax_phylum = "Rhodothermota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Rhodothermota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA533623 · 6 ✖
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
14535401 14535401 PRJNA533623_P_NODE_44532_length_320_cov_8.258687_g42758_i0 PRJNA533623 44532 320 8.258687 26.4277984 Rubrivirga sp. IMCC43871 3391575 Bacteria Bacteria 263 1.27e-65   NTclustered gi|2890853429|gb|CP177355.1| 3391575 g42758 i0 83.624 97.86875 287 40 88 5 1 280 807150 806864 Rubrivirga sp. IMCC43871 chromosome, complete genome blastn 31318 263 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae Rubrivirga Rubrivirga sp. IMCC43871
22182851 22182851 PRJNA533623_P_NODE_24518_length_466_cov_9.706173_g22756_i0 PRJNA533623 24518 466 9.706173 45.23076618 Rubrivirga sp. IMCC45206 3391614 Bacteria Bacteria 154 1.2099999999999999e-32   NTclustered gi|2890849321|gb|CP177357.1| 3391614 g22756 i0 86 19.1738197424893 150 13 32 8 207 354 1387011 1386868 Rubrivirga sp. IMCC45206 chromosome, complete genome blastn 8935 154 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae Rubrivirga Rubrivirga sp. IMCC45206
24732073 24732073 PRJNA533623_P_NODE_24580_length_465_cov_20.002475_g22818_i0 PRJNA533623 24580 465 20.002475 93.01150875 Rubricoccaceae bacterium 2838334 Bacteria Bacteria 255 1.32e-78   NR HEX8299395.1 2838334 g22818 i0 95.7 0.896774193548387 139 6 89.7 0 443 27 31 169 HEX8299395.1 peptidylprolyl isomerase [Rubricoccaceae bacterium] diamond 417 255 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae   Rubricoccaceae bacterium
26934488 26934488 PRJNA533623_P_NODE_18742_length_541_cov_10.764583_g17002_i0 PRJNA533623 18742 541 10.764583 58.23639403 Pseudomonadati 3379134 Bacteria Bacteria 61.6 2.01e-8   NR WP_012843495.1 29549 g17002 i0 37 5.61182994454713 108 63 59.9 2 126 449 42 144 WP_012843495.1 Hsp20/alpha crystallin family protein [Rhodothermus marinus] diamond 3036 62 0.993548387096774 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rhodothermaceae Rhodothermus Rhodothermus marinus
29004561 29004561 PRJNA533623_P_NODE_27808_length_433_cov_11.400538_g26038_i0 PRJNA533623 27808 433 11.400538 49.36432954 Salinibacter ruber 146919 Bacteria Bacteria 45.1 0.0448   NR WP_259258313.1 146919 g26038 i0 31.3 0.575057736720554 83 53 57.5 1 433 185 392 470 WP_259258313.1 hypothetical protein [Salinibacter ruber] diamond 249 45.1 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Salinibacteraceae Salinibacter Salinibacter ruber
30060956 30060956 PRJNA533623_P_NODE_51411_length_288_cov_2.290749_g49632_i0 PRJNA533623 51411 288 2.290749 6.59735712 Rubrivirga 1434037 Bacteria Bacteria 111 4.07e-28   NR WP_349256311.1 1434037 g49632 i0 67.4 3.91666666666667 95 31 99 0 286 2 118 212 WP_349256311.1 MULTISPECIES: deoxyribose-phosphate aldolase [Rubrivirga] diamond 1128 111 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Rubricoccaceae Rubrivirga  

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