RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA533114 · 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
4945683 4945683 PRJNA533114_P_NODE_113544_length_243_cov_2.452941_g113292_i0 PRJNA533114 113544 243 2.452941 5.96064663 Geobacter 28231 Bacteria Bacteria 54.7 0.006   NTclustered gi|747129828|gb|CP009788.1| 345632 g113292 i0 100 0.238683127572016 29 0 12 0 83 111 969660 969688 Geobacter pickeringii strain G13, complete genome blastn 58 54.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter pickeringii
8157273 8157273 PRJNA533114_P_NODE_102107_length_248_cov_0.880000_g101855_i0 PRJNA533114 102107 248 0.88 2.1824 Geobacter sp. SVR 2495594 Bacteria Bacteria 113 1.01e-20   NTclustered gi|1976315905|dbj|AP024469.1| 2495594 g101855 i0 85.321 31.258064516129 109 16 44 0 16 124 1161308 1161200 Geobacter sp. SVR DNA, complete genome blastn 7752 113 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sp. SVR
11984345 11984345 PRJNA533114_P_NODE_80890_length_270_cov_1.253807_g80638_i0 PRJNA533114 80890 270 1.253807 3.3852789 uncultured Desulfobacter sp. 240139 Bacteria Bacteria 58.4 5.32e-4   NTclustered gi|2907625836|emb|OZ223396.1| 240139 g80638 i0 92.683 0.407407407407407 41 1 14 2 89 127 180261 180221 MAG: uncultured Desulfobacter sp. isolate 6c515263-4ca9-4785-8cb0-20be41d20dde genome assembly, chromosome: 23 blastn 110 58.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Desulfobacter uncultured Desulfobacter sp.
13258691 13258691 PRJNA533114_P_NODE_29551_length_420_cov_1.538905_g29299_i0 PRJNA533114 29551 420 1.538905 6.463401 uncultured Desulfobacterium sp. 201089 Bacteria Bacteria 54.7 0.011   NTclustered gi|2621785015|emb|OY781473.1| 201089 g29299 i0 100 0.0690476190476191 29 0 7 0 204 232 2952409 2952437 MAG: uncultured Desulfobacterium sp. isolate b5edb3ca-a369-423b-9e9e-493c49de4e5b genome assembly, chromosome: 1 blastn 29 54.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteriaceae Desulfobacterium uncultured Desulfobacterium sp.
13258991 13258991 PRJNA533114_P_NODE_51291_length_329_cov_2.816406_g51039_i0 PRJNA533114 51291 329 2.816406 9.26597574 Desulfococcus multivorans 897 Bacteria Bacteria 56.5 0.002   NTclustered gi|1092202713|gb|CP015381.1| 897 g51039 i0 100 0.182370820668693 30 0 9 0 12 41 3850748 3850719 Desulfococcus multivorans strain DSM 2059 chromosome, complete genome blastn 60 56.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfococcaceae Desulfococcus Desulfococcus multivorans
18356009 18356009 PRJNA533114_P_NODE_122315_length_232_cov_2.421384_g122063_i0 PRJNA533114 122315 232 2.421384 5.61761088 Desulfomonile tiedjei 2358 Bacteria Bacteria 56.5 0.002   NTclustered gi|390621545|gb|CP003360.1| 706587 g122063 i0 96.97 0.142241379310345 33 1 14 0 112 144 643442 643474 Desulfomonile tiedjei DSM 6799, complete genome blastn 33 56.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfomonilia Desulfomonilales Desulfomonilaceae Desulfomonile Desulfomonile tiedjei
20907538 20907538 PRJNA533114_P_NODE_74717_length_279_cov_1.985437_g74465_i0 PRJNA533114 74717 279 1.985437 5.53936923 Desulfarculia bacterium 3065862 Bacteria Bacteria 52.8 0.026   NTclustered gi|2621701822|emb|OY759352.1| 3065862 g74465 i0 100 0.100358422939068 28 0 10 0 162 189 2529376 2529349 MAG: Desulfarculia bacterium isolate c1361fd1-6016-418c-9b2d-a8e9625d1ec5 genome assembly, chromosome: 2 blastn 28 52.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfarculia       Desulfarculia bacterium

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