RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1196438" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1196438 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
1598013 1598013 PRJNA1196438_P_NODE_62182_length_255_cov_1.708791_g61755_i0 PRJNA1196438 62182 255 1.708791 4.35741705 Pelobacter propionicus 29543 Bacteria Bacteria 387 5.589999999999998e-103   NTclustered gi|118501159|gb|CP000482.1| 338966 g61755 i0 94.444 0.988235294117647 252 13 98 1 5 255 3327706 3327455 Pelobacter propionicus DSM 2379, complete genome blastn 252 387 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Pelobacter Pelobacter propionicus
1598020 1598020 PRJNA1196438_P_NODE_62622_length_254_cov_2.502762_g62195_i0 PRJNA1196438 62622 254 2.502762 6.35701548 uncultured Mailhella sp. 1981031 Bacteria Bacteria 119 2.2400000000000002e-22   NTclustered gi|2729058701|emb|OZ007001.1| 1981031 g62195 i0 79.07 13.1732283464567 172 36 68 0 83 254 1296871 1297042 MAG: uncultured Mailhella sp. isolate metabat2_pooled_hifiasm.920 MAG genome assembly, chromosome: 1 blastn 3346 119 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Mailhella uncultured Mailhella sp.
13076808 13076808 PRJNA1196438_P_NODE_49491_length_274_cov_1.547264_g49064_i0 PRJNA1196438 49491 274 1.547264 4.23950336 Desulfosediminicola flagellatus 2569541 Bacteria Bacteria 54.7 0.007   NTclustered gi|1861338670|gb|CP050698.1| 2569541 g49064 i0 92.105 0.138686131386861 38 3 14 0 65 102 145054 145091 Desulfosediminicola flagellatus strain IMCC35005 chromosome, complete genome blastn 38 54.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfocapsaceae Desulfosediminicola Desulfosediminicola flagellatus
23275115 23275115 PRJNA1196438_P_NODE_14639_length_312_cov_4.355649_g14213_i0 PRJNA1196438 14639 312 4.355649 13.58962488 Desulfovibrio piger 901 Bacteria Bacteria 117 1.02e-21   NTclustered gi|1102127722|emb|LT630450.1| 901 g14213 i0 81.333 3.13141025641026 150 22 47 6 5 151 1661094 1661240 Desulfovibrio piger isolate FI11049 genome assembly, chromosome: I blastn 977 117 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio piger
23275679 23275679 PRJNA1196438_P_NODE_68139_length_249_cov_0.886364_g67712_i0 PRJNA1196438 68139 249 0.886364 2.20704636 Pelobacter propionicus 29543 Bacteria Bacteria 377 3.27e-100   NTclustered gi|118501159|gb|CP000482.1| 338966 g67712 i0 93.976 1 249 15 100 0 1 249 830463 830711 Pelobacter propionicus DSM 2379, complete genome blastn 249 377 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Pelobacter Pelobacter propionicus

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