RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1000943" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1000943 · 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
1419792 1419792 PRJNA1000943_P_NODE_11822_length_251_cov_0.876404_g11684_i0 PRJNA1000943 11822 251 0.876404 2.19977404 Rosistilla ulvae 1930277 Bacteria Bacteria 54.7 0.006   NTclustered gi|1712438206|gb|CP036261.1| 1930277 g11684 i0 100 0.115537848605578 29 0 12 0 118 146 6523009 6522981 Rosistilla ulvae strain EC9 chromosome blastn 29 54.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Rosistilla Rosistilla ulvae
4827296 4827296 PRJNA1000943_P_NODE_4864_length_360_cov_1.379791_g4727_i0 PRJNA1000943 4864 360 1.379791 4.9672476 Pseudomonadati 3379134 Bacteria Bacteria 161 5.429999999999998e-35   NTclustered gi|1015454008|gb|CP011273.1| 1636152 g4727 i0 79.31 31.8888888888889 232 46 64 2 130 360 3320639 3320869 Planctomyces sp. SH-PL62, complete genome blastn 11480 161 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp. SH-PL62
7797676 7797676 PRJNA1000943_P_NODE_5867_length_332_cov_1.204633_g5729_i0 PRJNA1000943 5867 332 1.204633 3.99938156 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 387 7.549999999999998e-103   NTclustered gi|2874253749|emb|OY969623.1| 1914239 g5729 i0 88.06 69.1686746987952 335 28 98 10 6 332 7051489 7051819 MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 blastn 22964 387 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
14173811 14173811 PRJNA1000943_P_NODE_6912_length_310_cov_1.696203_g6774_i0 PRJNA1000943 6912 310 1.696203 5.2582293 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 429 1.15e-115   NTclustered gi|2874253757|emb|OY969698.1| 100233 g6774 i0 91.935 88.658064516129 310 19 100 4 1 310 4421886 4421583 MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1 blastn 27484 429 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
15447827 15447827 PRJNA1000943_P_NODE_15253_length_242_cov_1.520710_g15115_i0 PRJNA1000943 15253 242 1.52071 3.6801182 Pirellula sp. SH-Sr6A 1632865 Bacteria Bacteria 374 4.1e-99   NTclustered gi|1015448679|gb|CP011272.1| 1632865 g15115 i0 94.628 149.297520661157 242 12 100 1 1 242 3096873 3097113 Pirellula sp. SH-Sr6A, complete genome blastn 36130 374 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula sp. SH-Sr6A

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