RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJEB30004" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB30004 · 8 ✖

analysis 1

  • blastn · 8 ✖
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
49217 49217 PRJEB30004_P_NODE_578441_length_171_cov_2.318182_g562814_i0 PRJEB30004 578441 171 2.318182 3.96409122 Opitutus sp. GAS368 1882749 Bacteria Bacteria 115 1.8e-21   NTclustered gi|1085764882|emb|LT629735.1| 1882749 g562814 i0 79.29 5.90058479532164 169 31 98 4 1 167 2332841 2333007 Opitutus sp. GAS368 genome assembly, chromosome: I blastn 1009 115 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Opitutus Opitutus sp. GAS368
2588940 2588940 PRJEB30004_P_NODE_365703_length_243_cov_1.735294_g350076_i0 PRJEB30004 365703 243 1.735294 4.21676442 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 278 3.3200000000000004e-70   NTclustered gi|2874254065|emb|OY970130.1| 412056 g350076 i0 87.243 18.843621399177 243 31 100 0 1 243 3680581 3680339 MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1 blastn 4579 278 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
2599051 2599051 PRJEB30004_P_NODE_575763_length_172_cov_1.541353_g560136_i0 PRJEB30004 575763 172 1.541353 2.65112716 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 257 2.85e-64   NTclustered gi|2874253690|emb|OY969416.1| 412056 g560136 i0 93.642 4.6453488372093 173 10 100 1 1 172 1315943 1315771 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 blastn 799 257 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
10248448 10248448 PRJEB30004_P_NODE_505129_length_190_cov_1.549669_g489502_i0 PRJEB30004 505129 190 1.549669 2.9443711 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 276 8.9e-70   NTclustered gi|2621704341|emb|OY760937.1| 2499141 g489502 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
14056550 14056550 PRJEB30004_P_NODE_133792_length_508_cov_2.379531_g118301_i0 PRJEB30004 133792 508 2.379531 12.08801748 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 667 0   NTclustered gi|2874253690|emb|OY969416.1| 412056 g118301 i0 90.855 119.411417322835 503 39 98 7 1 499 1316443 1315944 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 blastn 60661 667 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
16629722 16629722 PRJEB30004_P_NODE_653734_length_156_cov_1.752137_g638107_i0 PRJEB30004 653734 156 1.752137 2.73333372 Opitutus sp. GAS368 1882749 Bacteria Bacteria 121 3.47e-23   NTclustered gi|1085764882|emb|LT629735.1| 1882749 g638107 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
19170745 19170745 PRJEB30004_P_NODE_496736_length_192_cov_2.575163_g481109_i0 PRJEB30004 496736 192 2.575163 4.94431296 Fontisphaera persica 2974023 Bacteria Bacteria 274 3.24e-69   NTclustered gi|2439237958|gb|CP116615.1| 2974023 g481109 i0 92.632 97.0989583333333 190 14 99 0 1 190 3863540 3863351 Fontisphaera persica strain B-154 chromosome, complete genome blastn 18643 274 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Limisphaerales Fontisphaeraceae Fontisphaera Fontisphaera persica
19176195 19176195 PRJEB30004_P_NODE_609656_length_165_cov_1.261905_g594029_i0 PRJEB30004 609656 165 1.261905 2.08214325 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 209 7.74e-50   NTclustered gi|2874253690|emb|OY969416.1| 412056 g594029 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);;