RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA255848" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA255848 · 4 ✖

analysis 1

  • diamond · 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
9985098 9985098 PRJNA255848_P_NODE_42368_length_164_cov_0.886957_g42050_i0 PRJNA255848 42368 164 0.886957 1.45460948 Pedosphaera 1032526 Bacteria Bacteria 102 6.25e-25   NR PHX95918.1 2024890 g42050 i0 92.6 3.95121951219512 54 4 98.8 0 1 162 108 161 PHX95918.1 MAG: hypothetical protein CK546_00005 [Pedosphaera sp.] diamond 648 102 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Pedosphaerae Pedosphaerales Pedosphaeraceae Pedosphaera Pedosphaera sp.
28828503 28828503 PRJNA255848_P_NODE_47248_length_161_cov_0.910714_g46930_i0 PRJNA255848 47248 161 0.910714 1.46624954 Bacteria 2 Bacteria Bacteria 74.3 8.4e-15   NR MEA2011983.1 2026799 g46930 i0 60.4 3.93167701863354 53 21 98.8 0 159 1 35 87 MEA2011983.1 phosphohydrolase [Verrucomicrobiota bacterium] diamond 633 74.3 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
29726289 29726289 PRJNA255848_P_NODE_18250_length_233_cov_1.135870_g17932_i0 PRJNA255848 18250 233 1.13587 2.6465771 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 42.4 0.0414   NR HEY3862872.1 2499141 g17932 i0 48.5 0.424892703862661 33 17 42.5 0 91 189 193 225 HEY3862872.1 3'(2'),5'-bisphosphate nucleotidase CysQ [Verrucomicrobiia bacterium] diamond 99 42.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
30263901 30263901 PRJNA255848_P_NODE_45952_length_162_cov_0.902655_g45634_i0 PRJNA255848 45952 162 0.902655 1.4623011 Luteolibacter yonseiensis 1144680 Bacteria Bacteria 92.4 2.25e-21   NR WP_200350219.1 1144680 g45634 i0 75.9 1 54 13 100 0 1 162 121 174 WP_200350219.1 GDSL-type esterase/lipase family protein [Luteolibacter yonseiensis] diamond 162 92.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter yonseiensis

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