RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1028258" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1028258 · 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
163287 163287 PRJNA1028258_P_NODE_122801_length_242_cov_1.358382_g122238_i0 PRJNA1028258 122801 242 1.358382 3.28728444 Geomonas subterranea 2847989 Bacteria Bacteria 52.8 0.022   NTclustered gi|2060227305|gb|CP077683.1| 2847989 g122238 i0 100 0.231404958677686 28 0 12 0 203 230 4637665 4637638 Geomonas subterranea strain RG2 chromosome, complete genome blastn 56 52.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geomonas Geomonas subterranea
5267956 5267956 PRJNA1028258_P_NODE_58005_length_334_cov_1.875472_g57442_i0 PRJNA1028258 58005 334 1.875472 6.26407648 Desulfarculus baarsii 453230 Bacteria Bacteria 54.7 0.009   NTclustered gi|301638057|gb|CP002085.1| 644282 g57442 i0 96.875 0.179640718562874 32 1 10 0 102 133 270484 270453 Desulfarculus baarsii DSM 2075, complete genome blastn 60 54.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfarculia Desulfarculales Desulfarculaceae Desulfarculus Desulfarculus baarsii
11643963 11643963 PRJNA1028258_P_NODE_70710_length_305_cov_2.351695_g70147_i0 PRJNA1028258 70710 305 2.351695 7.17266975 Syntrophotalea acetylenica 29542 Bacteria Bacteria 143 1.64e-29   NTclustered gi|1109565244|gb|CP015455.1| 29542 g70147 i0 78.39 192.344262295082 236 39 75 8 3 230 780792 781023 Syntrophotalea acetylenica strain DSM 3246 chromosome, complete genome blastn 58665 143 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Syntrophotaleaceae Syntrophotalea Syntrophotalea acetylenica
15467011 15467011 PRJNA1028258_P_NODE_178553_length_225_cov_0.846154_g177990_i0 PRJNA1028258 178553 225 0.846154 1.9038465 Desulfuromonas thiophila 57664 Bacteria Bacteria 134 6.95e-27   NTclustered gi|2621701248|emb|OY759968.1| 57664 g177990 i0 87.719 100.76 114 14 51 0 75 188 3612 3499 MAG: Desulfuromonas thiophila isolate 5d13b52e-9f0b-4035-9b75-2cca1ad4870f genome assembly, chromosome: 1 blastn 22671 134 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas thiophila
16740518 16740518 PRJNA1028258_P_NODE_136714_length_234_cov_0.860606_g136151_i0 PRJNA1028258 136714 234 0.860606 2.01381804 Solidesulfovibrio carbinolicus 296842 Bacteria Bacteria 279 8.83e-71   NTclustered gi|1566432249|gb|CP026538.1| 296842 g136151 i0 88.362 1.98290598290598 232 27 99 0 3 234 4054498 4054729 Solidesulfovibrio carbinolicus strain DSM 3852 chromosome, complete genome blastn 464 279 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Solidesulfovibrio Solidesulfovibrio carbinolicus
16740628 16740628 PRJNA1028258_P_NODE_144054_length_232_cov_1.625767_g143491_i0 PRJNA1028258 144054 232 1.625767 3.77177944 Desulfuromonas versatilis 2802975 Bacteria Bacteria 52.8 0.021   NTclustered gi|2065532709|dbj|AP024355.1| 2802975 g143491 i0 100 0.120689655172414 28 0 12 0 176 203 4633240 4633267 Desulfuromonas versatilis NIT-T3 DNA, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas versatilis
18015444 18015444 PRJNA1028258_P_NODE_139035_length_234_cov_0.860606_g138472_i0 PRJNA1028258 139035 234 0.860606 2.01381804 Pseudodesulfovibrio methanolicus 3126690 Bacteria Bacteria 54.7 0.006   NTclustered gi|2696623852|gb|CP146609.1| 3126690 g138472 i0 100 0.123931623931624 29 0 12 0 83 111 1179482 1179510 Pseudodesulfovibrio methanolicus strain 5S69 chromosome, complete genome blastn 29 54.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Pseudodesulfovibrio Pseudodesulfovibrio methanolicus

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