RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • PVC group · 4 ✖

bioproject 1

  • PRJNA785164 · 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
3317207 3317207 PRJNA785164_P_NODE_2863_length_1549_cov_4.378049_g2660_i0 PRJNA785164 2863 1549 4.378049 67.81597901 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 2098 0   NTclustered gi|2874254065|emb|OY970130.1| 412056 g2660 i0 93.065 127.345384118786 1442 88 93 11 94 1530 5153735 5152301 MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1 blastn 197258 2098 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
8866576 8866576 PRJNA785164_P_NODE_18887_length_444_cov_2.318059_g18422_i0 PRJNA785164 18887 444 2.318059 10.29218196 Bacteria 2 Bacteria Bacteria 398 4.789999999999998e-106   NTclustered gi|2916408352|gb|CP170455.1| 2052180 g18422 i0 83.486 269.563063063063 436 62 98 8 10 442 1076586 1077014 MAG: Phycisphaerales bacterium isolate tig00000072 chromosome, complete genome blastn 119686 398 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
17344872 17344872 PRJNA785164_P_NODE_56394_length_246_cov_0.890173_g55929_i0 PRJNA785164 56394 246 0.890173 2.18982558 Phycisphaerales bacterium 2052180 Bacteria Bacteria 224 4.45e-54   NTclustered gi|1958061316|gb|CP064987.1| 2052180 g55929 i0 91.411 0.66260162601626 163 14 66 0 79 241 859054 858892 Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome blastn 163 224 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
21169109 21169109 PRJNA785164_P_NODE_55357_length_247_cov_0.885057_g54892_i0 PRJNA785164 55357 247 0.885057 2.18609079 Phycisphaera sp. 2030824 Bacteria Bacteria 78.7 3.68e-10   NTclustered gi|2323351239|gb|CP098402.1| 2030824 g54892 i0 97.778 16.0445344129555 45 1 18 0 1 45 3503458 3503502 MAG: Phycisphaera sp. isolate MAG12 chromosome blastn 3963 78.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae Phycisphaera Phycisphaera sp.

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