RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA797655" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA797655 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
782452 782452 PRJNA797655_S_NODE_128181_length_221_cov_2.966292_g127576_i0 PRJNA797655 128181 221 2.966292 6.55550532 uncultured Pseudodesulfovibrio sp. 2035858 Bacteria Bacteria 54.7 0.005   NTclustered gi|2621786040|emb|OY782498.1| 2035858 g127576 i0 100 0.131221719457014 29 0 13 0 187 215 839858 839886 MAG: uncultured Pseudodesulfovibrio sp. isolate 038b3505-f79f-4a2f-9017-89aa3695c727 genome assembly, chromosome: 1 blastn 29 54.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Pseudodesulfovibrio uncultured Pseudodesulfovibrio sp.
3334481 3334481 PRJNA797655_S_NODE_159243_length_200_cov_2.140127_g158638_i0 PRJNA797655 159243 200 2.140127 4.280254 Desulfobacterales bacterium 2044940 Bacteria Bacteria 69.4 1.73e-7   NTclustered gi|2621780237|emb|OY776524.1| 2044940 g158638 i0 95.349 0.625 43 2 22 0 72 114 5982874 5982916 MAG: Desulfobacterales bacterium isolate 4b92870f-ba81-4c82-9d98-8a89c3612312 genome assembly, chromosome: 1 blastn 125 69.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
23735617 23735617 PRJNA797655_S_NODE_139819_length_213_cov_1.411765_g139214_i0 PRJNA797655 139819 213 1.411765 3.00705945 Pseudodesulfovibrio aespoeensis 182210 Bacteria Bacteria 383 5.8499999999999996e-102   NTclustered gi|316941978|gb|CP002431.1| 643562 g139214 i0 99.061 7 213 2 100 0 1 213 1760049 1760261 Pseudodesulfovibrio aespoeensis Aspo-2 chromosome, complete genome blastn 1491 383 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Pseudodesulfovibrio Pseudodesulfovibrio aespoeensis

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