RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA407886" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • PVC group · 4 ✖

bioproject 1

  • PRJNA407886 · 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
1692984 1692984 PRJNA407886_P_NODE_78402_length_244_cov_0.900585_g76708_i0 PRJNA407886 78402 244 0.900585 2.1974274 Bremerella sp. TYQ1 3119568 Bacteria Bacteria 52.8 0.022   NTclustered gi|2101355205|gb|CP083740.1| 3119568 g76708 i0 100 0.114754098360656 28 0 11 0 70 97 4409419 4409392 Bremerella sp. TYQ1 chromosome, complete genome blastn 28 52.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Bremerella Bremerella sp. TYQ1
19543085 19543085 PRJNA407886_P_NODE_37096_length_363_cov_1.544828_g35402_i0 PRJNA407886 37096 363 1.544828 5.60772564 uncultured Phycisphaerales bacterium 904075 Bacteria Bacteria 392 1.7899999999999994e-104   NTclustered gi|2874253847|emb|OY969903.1| 904075 g35402 i0 86.798 64.3085399449036 356 41 98 6 1 355 1831195 1831545 MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1 blastn 23344 392 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     uncultured Phycisphaerales bacterium
19543919 19543919 PRJNA407886_P_NODE_78716_length_243_cov_1.617647_g77022_i0 PRJNA407886 78716 243 1.617647 3.93088221 uncultured Phycisphaerales bacterium 904075 Bacteria Bacteria 388 1.47e-103   NTclustered gi|2874253847|emb|OY969903.1| 904075 g77022 i0 95.851 60.9753086419753 241 9 99 1 1 241 1831841 1832080 MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1 blastn 14817 388 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     uncultured Phycisphaerales bacterium
22093493 22093493 PRJNA407886_P_NODE_24978_length_479_cov_3.012315_g23287_i0 PRJNA407886 24978 479 3.012315 14.42898885 Aureliella helgolandensis 2527968 Bacteria Bacteria 62.1 7.75e-5   NTclustered gi|1712701923|gb|CP036298.1| 2527968 g23287 i0 89.796 14.713987473904 49 3 10 2 394 441 1752856 1752903 Aureliella helgolandensis strain Q31a chromosome, complete genome blastn 7048 62.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Aureliella Aureliella helgolandensis

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