RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA827593" 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

  • PRJNA827593 · 4 ✖

analysis 1

  • blastn · 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
13574944 13574944 PRJNA827593_P_NODE_50511_length_281_cov_1.956731_g50212_i0 PRJNA827593 50511 281 1.956731 5.49841411 Congregicoccus parvus 3081749 Bacteria Bacteria 182 3.17e-41   NTclustered gi|2599616993|dbj|AP028972.1| 3081749 g50212 i0 88.158 3.16370106761566 152 18 54 0 78 229 336856 337007 Opitutales bacterium ASA1 DNA, complete genome blastn 889 182 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Alterococcaceae Congregicoccus Congregicoccus parvus
14849013 14849013 PRJNA827593_P_NODE_25212_length_418_cov_1.101449_g24913_i0 PRJNA827593 25212 418 1.101449 4.60405682 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 106 3.04e-18   NTclustered gi|2874253779|emb|OY969763.1| 412056 g24913 i0 90.244 5.17942583732057 82 6 19 2 28 108 4740831 4740911 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1 blastn 2165 106 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
16531001 16531001 PRJNA827593_P_NODE_32493_length_361_cov_1.871528_g32194_i0 PRJNA827593 32493 361 1.871528 6.75621608 Luteolibacter 518753 Bacteria Bacteria 111 5.57e-20   NTclustered gi|2836248208|gb|CP121322.1| 1962973 g32194 i0 91.463 20.9058171745152 82 6 22 1 234 314 2178768 2178849 MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome blastn 7547 111 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter sp.
22498548 22498548 PRJNA827593_P_NODE_7138_length_840_cov_2.696219_g6869_i0 PRJNA827593 7138 840 2.696219 22.6482396 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 130 3.8e-25   NTclustered gi|2874254019|emb|OY970344.1| 412056 g6869 i0 91.667 10.422619047619 96 5 11 3 304 397 4024516 4024610 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 blastn 8755 130 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae 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);;