RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA1044115 · 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
5274206 5274206 PRJNA1044115_P_NODE_24365_length_294_cov_4.923077_g24181_i0 PRJNA1044115 24365 294 4.923077 14.47384638 uncultured Verrucomicrobiae bacterium 412056 Bacteria Bacteria 344 4.02e-90   NTclustered gi|2874254096|emb|OY970179.1| 412056 g24181 i0 89.668 70.0442176870748 271 26 92 2 1 271 1727991 1727723 MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1 blastn 20593 344 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       uncultured Verrucomicrobiae bacterium
11650206 11650206 PRJNA1044115_P_NODE_6670_length_605_cov_5.419173_g6497_i0 PRJNA1044115 6670 605 5.419173 32.78599665 Luteolibacter luteus 2728835 Bacteria Bacteria 996 0   NTclustered gi|1835317346|gb|CP051774.1| 2728835 g6497 i0 96.376 266.844628099174 607 18 100 3 1 605 3804532 3805136 Luteolibacter luteus strain G-1-1-1 chromosome, complete genome blastn 161441 996 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter luteus
12925369 12925369 PRJNA1044115_P_NODE_43751_length_225_cov_4.815789_g43567_i0 PRJNA1044115 43751 225 4.815789 10.83552525 uncultured Parachlamydiaceae bacterium 464461 Bacteria Bacteria 394 2.89e-105   NTclustered gi|2874253811|emb|OY969795.1| 464461 g43567 i0 98.222 165.013333333333 225 4 100 0 1 225 653119 652895 MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1 blastn 37128 394 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae   uncultured Parachlamydiaceae bacterium
16311245 16311245 PRJNA1044115_P_NODE_6533_length_612_cov_4.081633_g6360_i0 PRJNA1044115 6533 612 4.081633 24.97959396 Luteolibacter 518753 Bacteria Bacteria 1059 0   NTclustered gi|1835317346|gb|CP051774.1| 2728835 g6360 i0 97.876 287.834967320261 612 13 100 0 1 612 3805478 3806089 Luteolibacter luteus strain G-1-1-1 chromosome, complete genome blastn 176155 1059 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter luteus
23123767 23123767 PRJNA1044115_P_NODE_32479_length_258_cov_2.232432_g32295_i0 PRJNA1044115 32479 258 2.232432 5.75967456 Victivallales bacterium CCUG 44730 2094242 Bacteria Bacteria 108 4.94e-19   NTclustered gi|1359122976|gb|CP027227.1| 2094242 g32295 i0 88.421 96.3372093023256 95 4 35 6 69 159 2341624 2341715 Victivallales bacterium CCUG 44730 chromosome, complete genome blastn 24855 108 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium CCUG 44730

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