RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA509429", tax_kingdom = "Pseudomonadati" and tax_phylum = "Abditibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Abditibacteriota · 5 ✖

tax_kingdom 1

  • Pseudomonadati · 5 ✖

bioproject 1

  • PRJNA509429 · 5 ✖

analysis 1

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
11964019 11964019 PRJNA509429_P_NODE_44190_length_168_cov_1.909774_g43362_i0 PRJNA509429 44190 168 1.909774 3.20842032 Abditibacteriota bacterium 2783868 Bacteria Bacteria 278 2.14e-70   NTclustered gi|2215576334|dbj|AP024152.1| 2783868 g43362 i0 96.429 142.452380952381 168 6 100 0 1 168 2851788 2851621 Abditibacteriota bacterium IAD-21 DNA, complete genome blastn 23932 278 1 Bacteria   Pseudomonadati Abditibacteriota         Abditibacteriota bacterium
13239112 13239112 PRJNA509429_P_NODE_19771_length_304_cov_1.810409_g18943_i0 PRJNA509429 19771 304 1.810409 5.50364336 Abditibacteriota bacterium 2783868 Bacteria Bacteria 291 5.51e-74   NTclustered gi|2215576334|dbj|AP024152.1| 2783868 g18943 i0 90.541 39.9671052631579 222 17 72 4 1 220 2850750 2850969 Abditibacteriota bacterium IAD-21 DNA, complete genome blastn 12150 291 1 Bacteria   Pseudomonadati Abditibacteriota         Abditibacteriota bacterium
17062518 17062518 PRJNA509429_P_NODE_25674_length_252_cov_3.009217_g24846_i0 PRJNA509429 25674 252 3.009217 7.58322684 Abditibacteriota bacterium 2783868 Bacteria Bacteria 316 7.34e-82   NTclustered gi|2215576334|dbj|AP024152.1| 2783868 g24846 i0 89.412 390.634920634921 255 22 100 5 1 252 2851571 2851319 Abditibacteriota bacterium IAD-21 DNA, complete genome blastn 98440 316 1 Bacteria   Pseudomonadati Abditibacteriota         Abditibacteriota bacterium
18336849 18336849 PRJNA509429_P_NODE_13035_length_395_cov_2.527778_g12214_i0 PRJNA509429 13035 395 2.527778 9.9847231 Abditibacteriota bacterium 2783868 Bacteria Bacteria 387 9.12e-103   NTclustered gi|2215576334|dbj|AP024152.1| 2783868 g12214 i0 84.5 73.3974683544304 400 53 100 9 1 395 2852107 2851712 Abditibacteriota bacterium IAD-21 DNA, complete genome blastn 28992 387 1 Bacteria   Pseudomonadati Abditibacteriota         Abditibacteriota bacterium
19611313 19611313 PRJNA509429_P_NODE_46716_length_161_cov_3.492063_g45888_i0 PRJNA509429 46716 161 3.492063 5.62222143 Abditibacteriota bacterium 2783868 Bacteria Bacteria 200 4.5099999999999985e-47   NTclustered gi|2215576334|dbj|AP024152.1| 2783868 g45888 i0 89.937 376.180124223602 159 10 99 2 1 159 2853381 2853533 Abditibacteriota bacterium IAD-21 DNA, complete genome blastn 60565 200 1 Bacteria   Pseudomonadati Abditibacteriota         Abditibacteriota 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);;