RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1143173" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1143173 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
2837060 2837060 PRJNA1143173_P_NODE_29063_length_260_cov_5.941176_g29037_i0 PRJNA1143173 29063 260 5.941176 15.4470576 Gemmatimonas phototrophica 1379270 Bacteria Bacteria 265 2.8e-66   NTclustered gi|1015602748|gb|CP011454.1| 1379270 g29037 i0 85.171 2.14615384615385 263 34 100 5 1 260 1785640 1785380 Gemmatimonas phototrophica strain AP64, complete genome blastn 558 265 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas phototrophica
13039675 13039675 PRJNA1143173_P_NODE_13291_length_299_cov_7.623894_g13265_i0 PRJNA1143173 13291 299 7.623894 22.79544306 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 106 2.1e-18   NTclustered gi|575462059|gb|CP007130.1| 861299 g13265 i0 85.577 2.00334448160535 104 11 34 4 192 293 66618 66517 Gemmatirosa kalamazoonesis strain KBS708 plasmid 2, complete sequence blastn 599 106 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
15589206 15589206 PRJNA1143173_P_NODE_28513_length_262_cov_2.756614_g28487_i0 PRJNA1143173 28513 262 2.756614 7.22232868 Pseudogemmatithrix spongiicola 3062599 Bacteria Bacteria 484 1.99e-132   NTclustered gi|2557479348|gb|CP130613.1| 3062599 g28487 i0 100 2 262 0 100 0 1 262 2511352 2511613 Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome blastn 524 484 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Pseudogemmatithrix Pseudogemmatithrix spongiicola
16863368 16863368 PRJNA1143173_P_NODE_27834_length_264_cov_2.753927_g27808_i0 PRJNA1143173 27834 264 2.753927 7.27036728 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 278 3.65e-70   NTclustered gi|2874253978|emb|OY970303.1| 412054 g27808 i0 86.747 81.3674242424242 249 33 94 0 1 249 1306947 1306699 MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 blastn 21481 278 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
23238398 23238398 PRJNA1143173_P_NODE_16879_length_296_cov_2.524664_g16853_i0 PRJNA1143173 16879 296 2.524664 7.47300544 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 158 5.66e-34   NTclustered gi|2874253789|emb|OY969773.1| 412054 g16853 i0 76.825 3.19256756756757 315 51 99 17 2 296 72321 72633 MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 blastn 945 158 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales 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);;