RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA883229 · 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
11063640 11063640 PRJNA883229_P_NODE_9589_length_252_cov_0.871508_g9543_i0 PRJNA883229 9589 252 0.871508 2.19620016 Akkermansia muciniphila 239935 Bacteria Bacteria 161 3.639999999999999e-35   NTclustered gi|1805960388|gb|CP029703.1| 239935 g9543 i0 80.365 42.4960317460317 219 37 86 5 34 249 2483658 2483873 Akkermansia muciniphila strain EB-AMDK-46 chromosome, complete genome blastn 10709 161 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae Akkermansia Akkermansia muciniphila
16543619 16543619 PRJNA883229_P_NODE_10893_length_250_cov_0.881356_g10847_i0 PRJNA883229 10893 250 0.881356 2.20339 Luteolibacter 518753 Bacteria Bacteria 254 5.78e-63   NTclustered gi|1835317346|gb|CP051774.1| 2728835 g10847 i0 85.774 98.412 239 34 96 0 1 239 5570417 5570655 Luteolibacter luteus strain G-1-1-1 chromosome, complete genome blastn 24603 254 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter luteus
21261965 21261965 PRJNA883229_P_NODE_5897_length_290_cov_1.391705_g5851_i0 PRJNA883229 5897 290 1.391705 4.0359445 Verrucomicrobium sp. GAS474 1882831 Bacteria Bacteria 239 1.92e-58   NTclustered gi|1085974270|emb|LT629781.1| 1882831 g5851 i0 82.069 70.4413793103448 290 43 98 6 6 290 3260428 3260143 Verrucomicrobiaceae bacterium GAS474 genome assembly, chromosome: I blastn 20428 239 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Verrucomicrobium Verrucomicrobium sp. GAS474
23812174 23812174 PRJNA883229_P_NODE_13839_length_246_cov_0.901734_g13793_i0 PRJNA883229 13839 246 0.901734 2.21826564 Nibricoccus aquaticus 2576891 Bacteria Bacteria 165 2.74e-36   NTclustered gi|1243404978|gb|CP023344.1| 2576891 g13793 i0 80.645 24.219512195122 217 39 87 3 25 239 3493955 3494170 Nibricoccus aquaticus strain HZ-65 chromosome, complete genome blastn 5958 165 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Nibricoccus Nibricoccus aquaticus
25086025 25086025 PRJNA883229_P_NODE_15060_length_244_cov_0.912281_g15014_i0 PRJNA883229 15060 244 0.912281 2.22596564 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 195 3.46e-45   NTclustered gi|2874253779|emb|OY969763.1| 412056 g15014 i0 83.654 4.9672131147541 208 32 85 2 38 244 4013209 4013415 MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1 blastn 1212 195 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);;