RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA942359" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA942359 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
6026277 6026277 PRJNA942359_P_NODE_6825_length_325_cov_2.678571_g6710_i0 PRJNA942359 6825 325 2.678571 8.70535575 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 379 1.23e-100   NTclustered gi|575456455|gb|CP007128.1| 861299 g6710 i0 87.842 12.7076923076923 329 32 100 6 1 325 3043619 3043943 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 4130 379 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
8911718 8911718 PRJNA942359_P_NODE_8687_length_294_cov_1.972851_g8572_i0 PRJNA942359 8687 294 1.972851 5.80018194 Gemmatimonas 173479 Bacteria Bacteria 403 6.5399999999999995e-108   NTclustered gi|470475286|ref|NR_076270.1| 173480 g8572 i0 91.554 116.462585034014 296 19 100 5 1 294 835 544 Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence blastn 34240 403 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas aurantiaca
9851092 9851092 PRJNA942359_P_NODE_4748_length_377_cov_1.812500_g4633_i0 PRJNA942359 4748 377 1.8125 6.833125 Gemmatimonas groenlandica 2732249 Bacteria Bacteria 366 1.1299999999999996e-96   NTclustered gi|1839994010|gb|CP053085.1| 2732249 g4633 i0 84.474 98.5358090185676 380 49 99 10 1 376 1101539 1101912 Gemmatimonas groenlandica strain TET16 chromosome, complete genome blastn 37148 366 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas groenlandica
12402149 12402149 PRJNA942359_P_NODE_1990_length_554_cov_1.866944_g1876_i0 PRJNA942359 1990 554 1.866944 10.34286976 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 697 0   NTclustered gi|575456455|gb|CP007128.1| 861299 g1876 i0 89.483 91.5018050541516 561 45 100 14 1 554 3043714 3043161 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 50692 697 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
16225979 16225979 PRJNA942359_P_NODE_2573_length_489_cov_7.175481_g2459_i0 PRJNA942359 2573 489 7.1754810000000004 35.08810209 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 601 3.78e-167   NTclustered gi|575456455|gb|CP007128.1| 861299 g2459 i0 88.956 67.2167689161554 498 39 100 15 1 489 3042810 3042320 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 32869 601 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
18774631 18774631 PRJNA942359_P_NODE_1335_length_669_cov_3.776846_g1227_i0 PRJNA942359 1335 669 3.776846 25.26709974 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 1053 0   NTclustered gi|575456455|gb|CP007128.1| 861299 g1227 i0 95.089 140.919282511211 672 28 100 5 1 669 3042853 3043522 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 94275 1053 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis

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