RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA1104180" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1104180 · 6 ✖
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
8673499 8673499 PRJNA1104180_P_NODE_2047_length_607_cov_1.986891_g1906_i0 PRJNA1104180 2047 607 1.986891 12.06042837 Candidatus Xiphinematobacter 134550 Bacteria Bacteria 664 0   NTclustered gi|939198278|gb|CP012665.1| 1704307 g1906 i0 89.827 134.505766062603 521 48 85 5 90 607 15161 15679 Candidatus Xiphinematobacter sp. Idaho Grape, complete genome blastn 81645 665 0.998496240601504 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria     Candidatus Xiphinematobacter Candidatus Xiphinematobacter sp. Idaho Grape
12499077 12499077 PRJNA1104180_P_NODE_15830_length_273_cov_1.010000_g15688_i0 PRJNA1104180 15830 273 1.01 2.7573 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 164 4.28e-47   NR TAG29148.1 2026799 g15688 i0 97.8 1 91 2 100 0 273 1 221 311 TAG29148.1 MAG: replicative DNA helicase, partial [Verrucomicrobiota bacterium] diamond 273 164 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28741469 28741469 PRJNA1104180_P_NODE_22727_length_247_cov_0.885057_g22584_i0 PRJNA1104180 22727 247 0.885057 2.18609079 Limisphaerales bacterium 2052186 Bacteria Bacteria 62.4 4.76e-9   NR MCC6820064.1 2052186 g22584 i0 63 0.558704453441296 46 17 55.9 0 139 2 1 46 MCC6820064.1 MMPL family transporter [Limisphaerales bacterium] diamond 138 62.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Limisphaerales     Limisphaerales bacterium
29783344 29783344 PRJNA1104180_P_NODE_23831_length_245_cov_0.895349_g23688_i0 PRJNA1104180 23831 245 0.895349 2.19360505 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 126 1.3599999999999999e-34   NR HLQ04515.1 2499141 g23688 i0 75.3 3.96734693877551 81 20 99.2 0 245 3 100 180 HLQ04515.1 glycosyltransferase family 2 protein [Verrucomicrobiia bacterium] diamond 972 126 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
31616291 31616291 PRJNA1104180_P_NODE_25916_length_242_cov_0.911243_g25773_i0 PRJNA1104180 25916 242 0.911243 2.20520806 Opitutaceae bacterium 2006848 Bacteria Bacteria 110 3.9e-26   NR MBL9213358.1 2006848 g25773 i0 65 0.991735537190083 80 28 99.2 0 3 242 452 531 MBL9213358.1 hypothetical protein [Opitutaceae bacterium] diamond 240 110 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
31860458 31860458 PRJNA1104180_P_NODE_22037_length_248_cov_0.880000_g21894_i0 PRJNA1104180 22037 248 0.88 2.1824 Bacteria 2 Bacteria Bacteria 171 3.81e-50   NR MEO6034882.1 2026799 g21894 i0 92.7 4.95967741935484 82 6 99.2 0 1 246 196 277 MEO6034882.1 NAD-dependent epimerase/dehydratase family protein [Verrucomicrobiota bacterium] diamond 1230 172 0.994186046511628 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);;