RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA795663" 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

  • PRJNA795663 · 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
779226 779226 PRJNA795663_S_NODE_11061_length_185_cov_2.195946_g10956_i0 PRJNA795663 11061 185 2.195946 4.0625001 Gemmatimonas groenlandica 2732249 Bacteria Bacteria 259 8.67e-65   NTclustered gi|1839994010|gb|CP053085.1| 2732249 g10956 i0 91.892 121.545945945946 185 15 100 0 1 185 1104144 1104328 Gemmatimonas groenlandica strain TET16 chromosome, complete genome blastn 22486 259 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas groenlandica
2491862 2491862 PRJNA795663_S_NODE_9602_length_196_cov_1.773585_g9497_i0 PRJNA795663 9602 196 1.773585 3.4762266 Gemmatimonas 173479 Bacteria Bacteria 278 2.57e-70   NTclustered gi|470475286|ref|NR_076270.1| 173480 g9497 i0 92.386 47.6632653061224 197 12 100 3 1 196 676 482 Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence blastn 9342 278 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas aurantiaca
3768030 3768030 PRJNA795663_S_NODE_16883_length_157_cov_0.966667_g16778_i0 PRJNA795663 16883 157 0.966667 1.51766719 Gemmatimonas 173479 Bacteria Bacteria 243 7.159999999999999e-60   NTclustered gi|470475286|ref|NR_076270.1| 173480 g16778 i0 95.395 27.8407643312102 152 7 97 0 1 152 638 789 Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence blastn 4371 243 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas aurantiaca
3768101 3768101 PRJNA795663_S_NODE_743_length_611_cov_2.836237_g657_i0 PRJNA795663 743 611 2.836237 17.32940807 Gemmatimonas 173479 Bacteria Bacteria 841 0   NTclustered gi|1015602748|gb|CP011454.1| 1379270 g657 i0 92.193 99.4828150572831 602 36 98 11 16 611 2076419 2075823 Gemmatimonas phototrophica strain AP64, complete genome blastn 60784 846 0.994089834515366 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas phototrophica

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