RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJEB81463" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJEB81463 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
2690640 2690640 PRJEB81463_P_NODE_27863_length_242_cov_1.639053_g27591_i0 PRJEB81463 27863 242 1.639053 3.96650826 Pelobacter propionicus 29543 Bacteria Bacteria 364 2.4699999999999992e-96   NTclustered gi|118501159|gb|CP000482.1| 338966 g27591 i0 93.802 1.28925619834711 242 15 100 0 1 242 3726914 3726673 Pelobacter propionicus DSM 2379, complete genome blastn 312 364 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Pelobacter Pelobacter propionicus
6518597 6518597 PRJEB81463_P_NODE_16526_length_269_cov_1.591837_g16254_i0 PRJEB81463 16526 269 1.591837 4.28204153 Pelobacter propionicus 29543 Bacteria Bacteria 387 5.95e-103   NTclustered gi|118501159|gb|CP000482.1| 338966 g16254 i0 92.593 1.00371747211896 270 19 100 1 1 269 2904138 2904407 Pelobacter propionicus DSM 2379, complete genome blastn 270 387 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Pelobacter Pelobacter propionicus
6518720 6518720 PRJEB81463_P_NODE_24106_length_247_cov_1.770115_g23834_i0 PRJEB81463 24106 247 1.770115 4.37218405 Pelobacter propionicus 29543 Bacteria Bacteria 401 1.9199999999999992e-107   NTclustered gi|118501159|gb|CP000482.1| 338966 g23834 i0 95.968 1.00404858299595 248 8 100 2 1 247 1658913 1659159 Pelobacter propionicus DSM 2379, complete genome blastn 248 401 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Pelobacter Pelobacter propionicus
9067778 9067778 PRJEB81463_P_NODE_21328_length_251_cov_1.640449_g21056_i0 PRJEB81463 21328 251 1.640449 4.11752699 Trichlorobacter lovleyi 313985 Bacteria Bacteria 459 1.1499999999999996e-124   NTclustered gi|189419341|gb|CP001089.1| 398767 g21056 i0 99.602 51.2669322709163 251 1 100 0 1 251 359414 359664 Geobacter lovleyi SZ, complete genome blastn 12868 459 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Trichlorobacter Trichlorobacter lovleyi
11618836 11618836 PRJEB81463_P_NODE_13430_length_285_cov_1.929245_g13158_i0 PRJEB81463 13430 285 1.929245 5.49834825 Desulfovibrio aminophilus 81425 Bacteria Bacteria 111 4.28e-20   NTclustered gi|2908463109|gb|CP168306.1| 81425 g13158 i0 85.321 0.382456140350877 109 15 38 1 12 119 1612410 1612518 MAG: Desulfovibrio aminophilus isolate Co chromosome, complete genome blastn 109 111 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio aminophilus
19265965 19265965 PRJEB81463_P_NODE_21476_length_251_cov_0.876404_g21204_i0 PRJEB81463 21476 251 0.876404 2.19977404 Syntrophobacter fumaroxidans 119484 Bacteria Bacteria 252 2.09e-62   NTclustered gi|116696516|gb|CP000478.1| 335543 g21204 i0 84.8 0.99601593625498 250 38 99 0 2 251 719697 719448 Syntrophobacter fumaroxidans MPOB, complete genome blastn 250 252 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophobacteria Syntrophobacterales Syntrophobacteraceae Syntrophobacter Syntrophobacter fumaroxidans

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