RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax_phylum = "Vulcanimicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Vulcanimicrobiota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1148190 · 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
2848486 2848486 PRJNA1148190_P_NODE_575643_length_252_cov_1.452514_g564470_i0 PRJNA1148190 575643 252 1.452514 3.66033528 Vulcanimicrobiota bacterium 3107663 Bacteria Bacteria 204 5.96e-48   NTclustered gi|2874253824|emb|OY969808.1| 3107663 g564470 i0 82.895 1.20238095238095 228 37 90 2 12 238 1486523 1486749 MAG: Candidatus Eremiobacteraeota bacterium isolate MFD04463.bin.c.1 genome assembly, chromosome: 1 blastn 303 204 1 Bacteria   Bacillati Vulcanimicrobiota         Vulcanimicrobiota bacterium
6677043 6677043 PRJNA1148190_P_NODE_701146_length_245_cov_0.895349_g689973_i0 PRJNA1148190 701146 245 0.895349 2.19360505 Vulcanimicrobiota bacterium 3107663 Bacteria Bacteria 217 7.41e-52   NTclustered gi|2874253918|emb|OY970243.1| 3107663 g689973 i0 83.133 49.8489795918367 249 30 99 11 1 244 138390 138631 MAG: Candidatus Eremiobacteraeota bacterium isolate MFD09603.bin.1.33 genome assembly, chromosome: 1 blastn 12213 217 1 Bacteria   Bacillati Vulcanimicrobiota         Vulcanimicrobiota bacterium
6677874 6677874 PRJNA1148190_P_NODE_770866_length_242_cov_0.911243_g759693_i0 PRJNA1148190 770866 242 0.911243 2.20520806 Vulcanimicrobium alpinum 3016050 Bacteria Bacteria 80.5 1e-10   NTclustered gi|2416250577|dbj|AP025523.1| 3016050 g759693 i0 88.06 0.276859504132231 67 8 28 0 28 94 304485 304419 Vulcanimicrobium alpinum WC8-2 DNA, complete genome blastn 67 80.5 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae Vulcanimicrobium Vulcanimicrobium alpinum
19420902 19420902 PRJNA1148190_P_NODE_371596_length_293_cov_1.050000_g360423_i0 PRJNA1148190 371596 293 1.05 3.0765 Vulcanimicrobiota bacterium 3107663 Bacteria Bacteria 65.8 3.49e-6   NTclustered gi|2874254010|emb|OY970335.1| 3107663 g360423 i0 87.097 0.21160409556314 62 3 21 4 213 273 303922 303979 MAG: Candidatus Eremiobacteraeota bacterium isolate MFD10064.bin.c.2 genome assembly, chromosome: 1 blastn 62 65.8 1 Bacteria   Bacillati Vulcanimicrobiota         Vulcanimicrobiota bacterium
20692048 20692048 PRJNA1148190_P_NODE_112697_length_499_cov_1.967136_g101535_i0 PRJNA1148190 112697 499 1.967136 9.81600864 Vulcanimicrobiota bacterium 3107663 Bacteria Bacteria 274 9.56e-69   NTclustered gi|2874253824|emb|OY969808.1| 3107663 g101535 i0 79.469 18.7995991983968 414 63 81 16 27 429 3740742 3740340 MAG: Candidatus Eremiobacteraeota bacterium isolate MFD04463.bin.c.1 genome assembly, chromosome: 1 blastn 9381 274 1 Bacteria   Bacillati Vulcanimicrobiota         Vulcanimicrobiota bacterium
23251543 23251543 PRJNA1148190_P_NODE_715199_length_244_cov_1.567251_g704026_i0 PRJNA1148190 715199 244 1.567251 3.82409244 Vulcanimicrobiota bacterium 3107663 Bacteria Bacteria 305 1.53e-78   NTclustered gi|2874254122|emb|OY970207.1| 3107663 g704026 i0 90.83 113.262295081967 229 19 98 2 13 240 479949 479722 MAG: Candidatus Eremiobacteraeota bacterium isolate MFD10113.bin.c.5 genome assembly, chromosome: 1 blastn 27636 305 1 Bacteria   Bacillati Vulcanimicrobiota         Vulcanimicrobiota 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);;