RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJEB49404" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB49404 · 6 ✖

analysis 1

  • blastn · 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
2649200 2649200 PRJEB49404_P_NODE_260943_length_291_cov_2.829365_g247142_i0 PRJEB49404 260943 291 2.829365 8.23345215 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 396 1.08e-105   NTclustered gi|2874253690|emb|OY969416.1| 412056 g247142 i0 91.379 101.759450171821 290 24 99 1 3 291 1316154 1316443 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 blastn 29612 396 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
2656377 2656377 PRJEB49404_P_NODE_411803_length_209_cov_2.100000_g398002_i0 PRJEB49404 411803 209 2.1 4.389 Sulfuriroseicoccus oceanibius 2707525 Bacteria Bacteria 110 1.07e-19   NTclustered gi|1953472588|gb|CP066776.1| 2707525 g398002 i0 78.495 64.8755980861244 186 26 86 13 1 180 631368 631545 Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome blastn 13559 110 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Sulfuriroseicoccus Sulfuriroseicoccus oceanibius
3942427 3942427 PRJEB49404_P_NODE_618144_length_156_cov_1.401709_g604343_i0 PRJEB49404 618144 156 1.401709 2.18666604 Opitutus sp. GAS368 1882749 Bacteria Bacteria 121 3.47e-23   NTclustered gi|1085764882|emb|LT629735.1| 1882749 g604343 i0 87.5 1.45512820512821 104 13 67 0 1 104 1414071 1413968 Opitutus sp. GAS368 genome assembly, chromosome: I blastn 227 121 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Opitutus Opitutus sp. GAS368
3943674 3943674 PRJEB49404_P_NODE_644964_length_151_cov_1.464286_g631163_i0 PRJEB49404 644964 151 1.464286 2.21107186 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 219 1.15e-52   NTclustered gi|2874253690|emb|OY969416.1| 412056 g631163 i0 92.763 3.71523178807947 152 10 100 1 1 151 1315792 1315943 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 blastn 561 219 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
9036444 9036444 PRJEB49404_P_NODE_470488_length_190_cov_1.549669_g456687_i0 PRJEB49404 470488 190 1.549669 2.9443711 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 276 8.9e-70   NTclustered gi|2621704341|emb|OY760937.1| 2499141 g456687 i0 93.085 269.484210526316 188 13 99 0 1 188 3992073 3991886 MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1 blastn 51202 276 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
17965772 17965772 PRJEB49404_P_NODE_572695_length_165_cov_1.261905_g558894_i0 PRJEB49404 572695 165 1.261905 2.08214325 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 209 7.74e-50   NTclustered gi|2874253690|emb|OY969416.1| 412056 g558894 i0 90.625 2.92727272727273 160 12 97 3 6 165 1316990 1317146 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 blastn 483 209 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);;