RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA816047 · 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
26150177 26150177 PRJNA816047d_S_NODE_69373_length_275_cov_2.774775_g67538_i0 PRJNA816047 69373 275 2.774775 7.63063125 Candidatus Organicella extenuata 2841811 Bacteria Bacteria 93.5 1.49e-14   NTclustered gi|2569232906|gb|CP128385.1| 2841811 g67538 i0 91.176 6.43272727272727 68 6 25 0 158 225 109047 109114 MAG: Candidatus Organicella extenuata isolate MAG_Ga0307966_1000010 chromosome, complete genome blastn 1769 93.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota       Candidatus Organicella Candidatus Organicella extenuata
26273883 26273883 PRJNA816047a_S_NODE_42478_length_320_cov_1.870445_g39818_i0 PRJNA816047 42478 320 1.870445 5.985424 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 156 2.22e-33   NTclustered gi|2874254019|emb|OY970344.1| 412056 g39818 i0 81.72 3.659375 186 34 58 0 1 186 3628622 3628807 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 blastn 1171 156 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
26282504 26282504 PRJNA816047d_S_NODE_150310_length_215_cov_4.672840_g148475_i0 PRJNA816047 150310 215 4.67284 10.046606 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 62.1 3.15e-5   NTclustered gi|2874254065|emb|OY970130.1| 412056 g148475 i0 97.222 0.297674418604651 36 1 17 0 43 78 3380873 3380908 MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1 blastn 64 62.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
26421657 26421657 PRJNA816047d_S_NODE_62799_length_286_cov_2.553648_g60964_i0 PRJNA816047 62799 286 2.553648 7.30343328 Oleiharenicola sp. Vm1 3398393 Bacteria Bacteria 193 1.49e-44   NTclustered gi|2912653302|gb|CP180537.1| 3398393 g60964 i0 83.495 2.06993006993007 206 34 72 0 80 285 4560024 4559819 Oleiharenicola sp. Vm1 chromosome, complete genome blastn 592 193 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Oleiharenicola Oleiharenicola sp. Vm1
26553311 26553311 PRJNA816047d_S_NODE_104752_length_248_cov_0.994872_g102917_i0 PRJNA816047 104752 248 0.994872 2.46728256 Opitutus sp. GAS368 1882749 Bacteria Bacteria 174 4.59e-39   NTclustered gi|1085764882|emb|LT629735.1| 1882749 g102917 i0 82.126 80.4838709677419 207 33 83 4 26 230 1816935 1816731 Opitutus sp. GAS368 genome assembly, chromosome: I blastn 19960 174 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);;