RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA797475 · 5 ✖

analysis 1

  • blastn · 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
5885111 5885111 PRJNA797475_P_NODE_8045_length_363_cov_0.893103_g7946_i0 PRJNA797475 8045 363 0.893103 3.24196389 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 577 4.589999999999998e-160   NTclustered gi|2874254065|emb|OY970130.1| 412056 g7946 i0 95.33 160.584022038567 364 15 100 2 1 363 5153780 5154142 MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1 blastn 58292 577 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
9709596 9709596 PRJNA797475_P_NODE_17928_length_268_cov_1.579487_g17829_i0 PRJNA797475 17928 268 1.579487 4.23302516 Prosthecobacter vanneervenii 48466 Bacteria Bacteria 479 9.499999999999996e-131   NTclustered gi|12583975|gb|AF245379.1|AF245379 48466 g17829 i0 98.881 167.652985074627 268 3 100 0 1 268 1476 1743 Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence blastn 44931 479 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Prosthecobacter Prosthecobacter vanneervenii
12260954 12260954 PRJNA797475_P_NODE_26750_length_245_cov_0.895349_g26651_i0 PRJNA797475 26750 245 0.895349 2.19360505 Opitutus terrae 107709 Bacteria Bacteria 326 1.18e-84   NTclustered gi|177839040|gb|CP001032.1| 452637 g26651 i0 90.763 2.03265306122449 249 16 100 5 1 245 4393585 4393340 Opitutus terrae PB90-1, complete genome blastn 498 326 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Opitutus Opitutus terrae
12261026 12261026 PRJNA797475_P_NODE_4830_length_455_cov_1.494764_g4732_i0 PRJNA797475 4830 455 1.494764 6.8011762 uncultured Verrucomicrobiota bacterium 156588 Bacteria Bacteria 780 0   NTclustered gi|2021776877|gb|MW858385.1| 156588 g4732 i0 97.582 93.3230769230769 455 11 100 0 1 455 465 11 Uncultured Verrucomicrobia bacterium clone Chel7-1-18 16S ribosomal RNA gene, partial sequence blastn 42462 780 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         uncultured Verrucomicrobiota bacterium
22458615 22458615 PRJNA797475_P_NODE_28018_length_244_cov_0.900585_g27919_i0 PRJNA797475 28018 244 0.900585 2.1974274 Opitutus sp. GAS368 1882749 Bacteria Bacteria 241 4.38e-59   NTclustered gi|1085764882|emb|LT629735.1| 1882749 g27919 i0 84.426 1 244 38 100 0 1 244 59659 59416 Opitutus sp. GAS368 genome assembly, chromosome: I blastn 244 241 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Opitutus Opitutus sp. GAS368

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