RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1047321", tax_kingdom = "Pseudomonadati" and tax_phylum = "Abditibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Abditibacteriota · 3 ✖

tax_kingdom 1

  • Pseudomonadati · 3 ✖

bioproject 1

  • PRJNA1047321 · 3 ✖

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
9102009 9102009 PRJNA1047321_P_NODE_268_length_1290_cov_3.699260_g210_i0 PRJNA1047321 268 1290 3.69926 47.720454 Abditibacteriota bacterium 2783868 Bacteria Bacteria 2067 0   NTclustered gi|2215576334|dbj|AP024152.1| 2783868 g210 i0 97.377 230.497674418605 1220 23 94 7 1 1214 2851888 2850672 Abditibacteriota bacterium IAD-21 DNA, complete genome blastn 297342 2067 1 Bacteria   Pseudomonadati Abditibacteriota         Abditibacteriota bacterium
19300176 19300176 PRJNA1047321_P_NODE_1856_length_503_cov_2.111628_g1688_i0 PRJNA1047321 1856 503 2.111628 10.62148884 Abditibacteriota bacterium 2783868 Bacteria Bacteria 747 0   NTclustered gi|2215576334|dbj|AP024152.1| 2783868 g1688 i0 93.504 122.687872763419 508 24 100 6 1 503 2852464 2851961 Abditibacteriota bacterium IAD-21 DNA, complete genome blastn 61712 747 1 Bacteria   Pseudomonadati Abditibacteriota         Abditibacteriota bacterium
30920144 30920144 PRJNA1047321_P_NODE_6534_length_251_cov_0.865169_g6363_i0 PRJNA1047321 6534 251 0.865169 2.17157419 Abditibacteriaceae bacterium 2800791 Bacteria Bacteria 126 1.3099999999999998e-31   NR HEX8550703.1 2800791 g6363 i0 70.4 0.968127490039841 81 24 96.8 0 1 243 1457 1537 HEX8550703.1 hypothetical protein [Abditibacteriaceae bacterium] diamond 243 126 1 Bacteria   Pseudomonadati Abditibacteriota Abditibacteriia Abditibacteriales Abditibacteriaceae   Abditibacteriaceae 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);;