RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA407368" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA407368 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
2965763 2965763 PRJNA407368_S_NODE_1883_length_452_cov_78.404255_g1785_i0 PRJNA407368 1883 452 78.404255 354.3872326 Tepidiforma bonchosmolovskayae 2601677 Bacteria Bacteria 222 3.15e-53   NTclustered gi|1756502384|gb|CP042829.1| 2601677 g1785 i0 78.531 115.980088495575 354 64 76 11 108 452 2202170 2202520 Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome blastn 52423 222 1 Bacteria   Bacillati Chloroflexota Tepidiformia Tepidiformales Tepidiformaceae Tepidiforma Tepidiforma bonchosmolovskayae
8068383 8068383 PRJNA407368_S_NODE_3967_length_291_cov_33.015267_g3865_i0 PRJNA407368 3967 291 33.015267 96.07442697 Candidatus Chlorohelix allophototropha 3003348 Bacteria Bacteria 366 8.48e-97   NTclustered gi|2530750984|gb|CP128400.1| 3003348 g3865 i0 89.726 735.137457044674 292 23 99 6 2 291 320385 320671 Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence blastn 213925 366 1 Bacteria   Bacillati Chloroflexota Chloroflexia Candidatus Chloroheliales Candidatus Chloroheliaceae Candidatus Chlorohelix Candidatus Chlorohelix allophototropha
9343216 9343216 PRJNA407368_S_NODE_2708_length_365_cov_27.607143_g2606_i0 PRJNA407368 2708 365 27.607143 100.76607195 Candidatus Chlorohelix allophototropha 3003348 Bacteria Bacteria 379 1.3999999999999995e-100   NTclustered gi|2530750984|gb|CP128400.1| 3003348 g2606 i0 85.831 606.380821917808 367 41 100 7 1 365 320643 321000 Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence blastn 221329 379 1 Bacteria   Bacillati Chloroflexota Chloroflexia Candidatus Chloroheliales Candidatus Chloroheliaceae Candidatus Chlorohelix Candidatus Chlorohelix allophototropha
10619009 10619009 PRJNA407368_S_NODE_3649_length_306_cov_35.310469_g3547_i0 PRJNA407368 3649 306 35.310469 108.05003514 Candidatus Chlorohelix allophototropha 3003348 Bacteria Bacteria 320 7.09e-83   NTclustered gi|2530750984|gb|CP128400.1| 3003348 g3547 i0 87.413 425.683006535948 286 27 93 4 22 306 320340 320063 Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence blastn 130259 320 1 Bacteria   Bacillati Chloroflexota Chloroflexia Candidatus Chloroheliales Candidatus Chloroheliaceae Candidatus Chlorohelix Candidatus Chlorohelix allophototropha

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