RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB43370" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJEB43370 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
6438333 6438333 PRJEB43370_P_NODE_2666_length_265_cov_1.439815_g2623_i0 PRJEB43370 2666 265 1.439815 3.81550975 Pseudomonadati 3379134 Bacteria Bacteria 151 8.85e-45   NR MCC5815248.1 178 g2623 i0 77.3 35.8641509433962 88 20 99.6 0 1 264 33 120 MCC5815248.1 glycine dehydrogenase (aminomethyl-transferring) [Leptospira sp.] diamond 9504 152 0.993421052631579 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
6438368 6438368 PRJEB43370_P_NODE_6186_length_184_cov_1.540741_g6143_i0 PRJEB43370 6186 184 1.540741 2.83496344 Bacteria 2 Bacteria Bacteria 112 2.0100000000000003e-27   NR MDR1030175.1 166 g6143 i0 87.9 34.0434782608696 58 7 94.6 0 9 182 345 402 MDR1030175.1 decarboxylating NADP(+)-dependent phosphogluconate dehydrogenase [Treponema sp.] diamond 6264 113 0.991150442477876 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27633867 27633867 PRJEB43370_P_NODE_9824_length_164_cov_0.904348_g9781_i0 PRJEB43370 9824 164 0.904348 1.48313072 Spirochaetia bacterium 2053615 Bacteria Bacteria 69.7 3.88e-12   NR MDH5654478.1 2053615 g9781 i0 57.4 0.98780487804878 54 23 98.8 0 2 163 371 424 MDH5654478.1 hypothetical protein [Spirochaetia bacterium] diamond 162 69.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
29748911 29748911 PRJEB43370_P_NODE_8391_length_167_cov_0.881356_g8348_i0 PRJEB43370 8391 167 0.881356 1.47186452 Leptospira sp. 178 Bacteria Bacteria 41.2 0.0473   NR MCC5814721.1 178 g8348 i0 36.4 0.988023952095808 55 35 98.8 0 167 3 2 56 MCC5814721.1 methylcrotonoyl-CoA carboxylase [Leptospira sp.] diamond 165 41.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
30033582 30033582 PRJEB43370_P_NODE_2571_length_270_cov_1.176471_g2528_i0 PRJEB43370 2571 270 1.176471 3.1764717 Spirochaetia bacterium 2053615 Bacteria Bacteria 46.2 0.00293   NR HUX50597.1 2053615 g2528 i0 39.4 0.733333333333333 66 35 73.3 2 204 7 194 254 HUX50597.1 ABC transporter substrate-binding protein [Spirochaetia bacterium] diamond 198 46.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
31132335 31132335 PRJEB43370_P_NODE_8015_length_168_cov_0.873950_g7972_i0 PRJEB43370 8015 168 0.87395 1.468236 Spirochaeta 146 Bacteria Bacteria 97.4 7.24e-22   NR MCA1753670.1 28185 g7972 i0 78.2 3.92857142857143 55 12 98.2 0 167 3 296 350 MCA1753670.1 NAD-glutamate dehydrogenase [Spirochaeta sp.] diamond 660 97.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Spirochaeta Spirochaeta sp.

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