RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA745553" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA745553 · 8 ✖

analysis 1

  • diamond · 8 ✖

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
27242334 27242334 PRJNA745553_S_NODE_19243_length_282_cov_1.416268_g19048_i0 PRJNA745553 19243 282 1.416268 3.99387576 Desulfovibrio sp. 885 Bacteria Bacteria 112 5.77e-28   NR MCX4309192.1 885 g19048 i0 100 1.14893617021277 54 0 57.4 0 21 182 244 297 MCX4309192.1 PHP domain-containing protein [Desulfovibrio sp.] diamond 324 112 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
27968712 27968712 PRJNA745553_S_NODE_17945_length_291_cov_4.417431_g17750_i0 PRJNA745553 17945 291 4.417431 12.85472421 Desulfovibrio sp. 885 Bacteria Bacteria 144 6.2999999999999986e-43   NR MCX4310619.1 885 g17750 i0 100 1.44329896907216 70 0 72.2 0 270 61 14 83 MCX4310619.1 KOW motif-containing protein [Desulfovibrio sp.] diamond 420 144 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
28221181 28221181 PRJNA745553_S_NODE_886_length_797_cov_23.262431_g774_i0 PRJNA745553 886 797 23.262431 185.40157507 Desulfovibrio sp. 885 Bacteria Bacteria 481 2.15e-167   NR MCX4310245.1 885 g774 i0 99.6 0.895859473023839 238 1 89.6 0 21 734 82 319 MCX4310245.1 aminopeptidase [Desulfovibrio sp.] diamond 714 481 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
29989610 29989610 PRJNA745553_S_NODE_29711_length_214_cov_5.517730_g29516_i0 PRJNA745553 29711 214 5.51773 11.8079422 Desulfovibrio sp. 885 Bacteria Bacteria 122 3.1000000000000003e-30   NR MCX4309225.1 885 g29516 i0 100 0.883177570093458 63 0 88.3 0 24 212 508 570 MCX4309225.1 homocysteine S-methyltransferase family protein [Desulfovibrio sp.] diamond 189 122 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
30306001 30306001 PRJNA745553_S_NODE_27712_length_235_cov_2.191358_g27517_i0 PRJNA745553 27712 235 2.191358 5.1496913 Desulfarculus baarsii 453230 Bacteria Bacteria 62.8 2.77e-9   NR WP_013257361.1 453230 g27517 i0 65.2 2.60425531914894 46 16 58.7 0 3 140 435 480 WP_013257361.1 cysteine--tRNA ligase [Desulfarculus baarsii] diamond 612 62.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfarculia Desulfarculales Desulfarculaceae Desulfarculus Desulfarculus baarsii
30379051 30379051 PRJNA745553_S_NODE_6332_length_463_cov_3.602564_g6138_i0 PRJNA745553 6332 463 3.602564 16.67987132 Bacteria 2 Bacteria Bacteria 45.8 0.0248   NR MBF0222522.1 2053307 g6138 i0 37.4 1.08207343412527 99 54 64.1 4 39 335 250 340 MBF0222522.1 NADH:ubiquinone reductase (Na(+)-transporting) subunit B [Desulfobulbaceae bacterium] diamond 501 45.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae   Desulfobulbaceae bacterium
31632915 31632915 PRJNA745553_S_NODE_3396_length_568_cov_3.555556_g3212_i0 PRJNA745553 3396 568 3.555556 20.19555808 Desulfovibrio sp. 885 Bacteria Bacteria 203 2.04e-64   NR MCX4310708.1 885 g3212 i0 99 0.538732394366197 102 1 53.9 0 567 262 2 103 MCX4310708.1 STAS-like domain-containing protein [Desulfovibrio sp.] diamond 306 203 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
31759448 31759448 PRJNA745553_S_NODE_21917_length_264_cov_3.026178_g21722_i0 PRJNA745553 21917 264 3.026178 7.98910992 uncultured Desulfobacterales bacterium HF 246132 Bacteria Bacteria 46.6 5.88e-4   NR ADI17936.1 710741 g21722 i0 71 0.704545454545455 31 9 35.2 0 11 103 81 111 ADI17936.1 hypothetical protein [uncultured Desulfobacterales bacterium HF0200_07G10] diamond 186 46.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     uncultured Desulfobacterales bacterium HF0200_07G10

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