RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA986481" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA986481 · 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
974027 974027 PRJNA986481_P_NODE_7461_length_594_cov_1.866055_g6963_i0 PRJNA986481 7461 594 1.866055 11.0843667 Pseudogemmatithrix spongiicola 3062599 Bacteria Bacteria 462 2.29e-125   NTclustered gi|2557479348|gb|CP130613.1| 3062599 g6963 i0 82.927 11.8888888888889 533 72 88 17 44 568 1509547 1510068 Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome blastn 7062 462 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Pseudogemmatithrix Pseudogemmatithrix spongiicola
4801650 4801650 PRJNA986481_P_NODE_47904_length_254_cov_2.868293_g47379_i0 PRJNA986481 47904 254 2.868293 7.28546422 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 58.4 4.96e-4   NTclustered gi|2874253978|emb|OY970303.1| 412054 g47379 i0 92.683 0.161417322834646 41 1 16 2 215 254 536403 536364 MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 blastn 41 58.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
14025946 14025946 PRJNA986481_P_NODE_27971_length_310_cov_1.927203_g27446_i0 PRJNA986481 27971 310 1.927203 5.9743293 Pseudomonadati 3379134 Bacteria Bacteria 309 1.5600000000000002e-79   NTclustered gi|226088597|dbj|AP009153.1| 379066 g27446 i0 89.958 163.029032258065 239 24 77 0 39 277 1047643 1047405 Gemmatimonas aurantiaca T-27 DNA, complete genome blastn 50539 309 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas aurantiaca
17551499 17551499 PRJNA986481_P_NODE_38694_length_265_cov_1.898148_g38169_i0 PRJNA986481 38694 265 1.898148 5.0300922 Pseudogemmatithrix spongiicola 3062599 Bacteria Bacteria 278 3.67e-70   NTclustered gi|2557479348|gb|CP130613.1| 3062599 g38169 i0 89.498 28.6490566037736 219 23 83 0 19 237 925290 925072 Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome blastn 7592 278 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Pseudogemmatithrix Pseudogemmatithrix spongiicola

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