RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA437204" and tax_phylum = "Candidatus Melainabacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Melainabacteria · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA437204 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
1706662 1706662 PRJNA437204_P_NODE_115402_length_243_cov_1.811765_g115103_i0 PRJNA437204 115402 243 1.811765 4.40258895 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 278 3.3200000000000004e-70   NTclustered gi|1958007833|gb|CP064963.1| 2052166 g115103 i0 87.552 51.3991769547325 241 29 99 1 3 243 3679728 3679967 MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome blastn 12490 278 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
2983934 2983934 PRJNA437204_P_NODE_75163_length_257_cov_1.625000_g74864_i0 PRJNA437204 75163 257 1.625 4.17625 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 270 5.93e-68   NTclustered gi|2189472572|gb|CP091731.1| 2052166 g74864 i0 85.769 349.859922178988 260 32 100 5 1 257 598546 598803 MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome blastn 89914 270 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
20834232 20834232 PRJNA437204_P_NODE_39977_length_324_cov_1.840637_g39678_i0 PRJNA437204 39977 324 1.840637 5.96366388 Candidatus Gastranaerophilales bacterium 2137880 Bacteria Bacteria 433 9.299999999999999e-117   NTclustered gi|2729058672|emb|OZ006972.1| 2137880 g39678 i0 92.182 27.4351851851852 307 22 94 2 12 317 511295 510990 MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1 blastn 8889 433 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Gastranaerophilales     Candidatus Gastranaerophilales bacterium
22108999 22108999 PRJNA437204_P_NODE_3138_length_844_cov_1.906615_g2886_i0 PRJNA437204 3138 844 1.906615 16.0918306 Candidatus Gastranaerophilales bacterium 2137880 Bacteria Bacteria 1009 0   NTclustered gi|2729058729|emb|OZ007029.1| 2137880 g2886 i0 88.457 198.537914691943 849 80 99 17 1 841 1222677 1223515 MAG: Candidatus Gastranaerophilales bacterium isolate 6755_HET_CTRL_tig00013926_hicanu_large MAG genome assembly, chromosome: 1 blastn 167566 1009 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Gastranaerophilales     Candidatus Gastranaerophilales 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);;