RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1182301 · 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
2869004 2869004 PRJNA1182301_P_NODE_19703_length_289_cov_1.972222_g19578_i0 PRJNA1182301 19703 289 1.972222 5.69972158 Desulfococcus multivorans 897 Bacteria Bacteria 311 4e-80   NTclustered gi|1092202713|gb|CP015381.1| 897 g19578 i0 86.111 1.99307958477509 288 40 99 0 2 289 2302678 2302391 Desulfococcus multivorans strain DSM 2059 chromosome, complete genome blastn 576 311 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfococcaceae Desulfococcus Desulfococcus multivorans
5421117 5421117 PRJNA1182301_P_NODE_12965_length_317_cov_3.118852_g12840_i0 PRJNA1182301 12965 317 3.118852 9.88676084 Desulfococcus multivorans 897 Bacteria Bacteria 309 1.6e-79   NTclustered gi|84616844|emb|CT009609.1| 897 g12840 i0 84.227 10.8044164037855 317 50 100 0 1 317 47544 47860 Desulfococcus multivorans vrl island blastn 3425 309 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfococcaceae Desulfococcus Desulfococcus multivorans
10522477 10522477 PRJNA1182301_P_NODE_44609_length_256_cov_1.683060_g44484_i0 PRJNA1182301 44609 256 1.68306 4.3086336 Candidatus Electronema aureum 2005002 Bacteria Bacteria 254 5.94e-63   NTclustered gi|2322424202|emb|OW818638.1| 2005002 g44484 i0 86.192 214.140625 239 28 93 4 1 237 335 570 Candidatus Electronema aureum isolate ENR-cMAG genome assembly, chromosome: 1 blastn 54820 254 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Candidatus Electronema Candidatus Electronema aureum
15622071 15622071 PRJNA1182301_P_NODE_65733_length_234_cov_2.372671_g65608_i0 PRJNA1182301 65733 234 2.372671 5.55205014 Desulfurivibrio alkaliphilus 427923 Bacteria Bacteria 80.5 9.61e-11   NTclustered gi|296923907|gb|CP001940.1| 589865 g65608 i0 77.07 4.88461538461539 157 25 65 9 20 170 1787833 1787984 Desulfurivibrio alkaliphilus AHT2, complete genome blastn 1143 80.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfurivibrio Desulfurivibrio alkaliphilus
21995217 21995217 PRJNA1182301_P_NODE_3378_length_487_cov_4.398551_g3254_i0 PRJNA1182301 3378 487 4.398551 21.42094337 Pseudodesulfovibrio aespoeensis 182210 Bacteria Bacteria 503 1.09e-137   NTclustered gi|316941978|gb|CP002431.1| 643562 g3254 i0 85.744 27.7104722792608 477 66 98 2 11 486 1834670 1834195 Pseudodesulfovibrio aespoeensis Aspo-2 chromosome, complete genome blastn 13495 503 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Pseudodesulfovibrio Pseudodesulfovibrio aespoeensis
21995439 21995439 PRJNA1182301_P_NODE_43438_length_257_cov_2.516304_g43313_i0 PRJNA1182301 43438 257 2.516304 6.46690128 Desulfococcus multivorans 897 Bacteria Bacteria 438 1.5399999999999995e-118   NTclustered gi|84616844|emb|CT009609.1| 897 g43313 i0 97.647 43.4396887159533 255 6 99 0 1 255 39531 39277 Desulfococcus multivorans vrl island blastn 11164 438 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfococcaceae Desulfococcus Desulfococcus multivorans
24544895 24544895 PRJNA1182301_P_NODE_49460_length_250_cov_2.909605_g49335_i0 PRJNA1182301 49460 250 2.909605 7.2740125 Pseudodesulfovibrio profundus 57320 Bacteria Bacteria 287 5.7e-73   NTclustered gi|1248817418|emb|LT907975.1| 57320 g49335 i0 87.5 24.268 248 31 99 0 3 250 540398 540151 Desulfovibrio profundus strain 500-1 genome assembly, chromosome: DPRO blastn 6067 287 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Pseudodesulfovibrio Pseudodesulfovibrio profundus

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