RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA674048" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA674048 · 5 ✖

analysis 1

  • diamond · 5 ✖
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
21045702 21045702 PRJNA674048_P_NODE_30097_length_165_cov_0.896552_g29894_i0 PRJNA674048 30097 165 0.896552 1.4793108 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 106 2.63e-27   NR MCX7827560.1 2499141 g29894 i0 100 1 55 0 100 0 1 165 62 116 MCX7827560.1 SLC13 family permease [Verrucomicrobiia bacterium] diamond 165 106 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
27018479 27018479 PRJNA674048_P_NODE_33642_length_156_cov_2.542056_g33439_i0 PRJNA674048 33642 156 2.542056 3.96560736 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 102 7.8e-24   NR MBN9691045.1 2026799 g33439 i0 96.1 0.980769230769231 51 2 98.1 0 155 3 12 62 MBN9691045.1 efflux transporter outer membrane subunit [Verrucomicrobiota bacterium] diamond 153 102 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28786904 28786904 PRJNA674048_P_NODE_31987_length_163_cov_0.912281_g31784_i0 PRJNA674048 31987 163 0.912281 1.48701803 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 94 2.8400000000000003e-21   NR HVR65458.1 2499141 g31784 i0 78.8 0.957055214723926 52 11 95.7 0 162 7 101 152 HVR65458.1 agmatinase [Verrucomicrobiia bacterium] diamond 156 94 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
30472953 30472953 PRJNA674048_P_NODE_24713_length_177_cov_1.007812_g24510_i0 PRJNA674048 24713 177 1.007812 1.78382724 Bacteria 2 Bacteria Bacteria 101 2.39e-23   NR HSY54503.1 2006848 g24510 i0 81 5.89830508474576 58 11 98.3 0 176 3 32 89 HSY54503.1 transketolase [Opitutaceae bacterium] diamond 1044 101 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
30555500 30555500 PRJNA674048_P_NODE_31173_length_164_cov_0.904348_g30970_i0 PRJNA674048 31173 164 0.904348 1.48313072 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 41.2 0.0445   NR MBS0658504.1 2026799 g30970 i0 43.9 0.75 41 23 75 0 2 124 177 217 MBS0658504.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 123 41.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota 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);;