RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA695140" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA695140 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
1952113 1952113 PRJNA695140_S_NODE_7902_length_188_cov_1.807947_g7721_i0 PRJNA695140 7902 188 1.807947 3.39894036 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 235 1.49e-57   NTclustered gi|2874253749|emb|OY969623.1| 1914239 g7721 i0 89.418 2.01595744680851 189 17 99 3 2 188 7050744 7050557 MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 blastn 379 235 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
8329229 8329229 PRJNA695140_S_NODE_2967_length_304_cov_3.149813_g2786_i0 PRJNA695140 2967 304 3.149813 9.57543152 Fuerstiella marisgermanici 1891926 Bacteria Bacteria 278 4.2900000000000005e-70   NTclustered gi|1140105870|gb|CP017641.1| 1891926 g2786 i0 89.189 89.0394736842105 222 24 73 0 1 222 5363175 5363396 Fuerstiella marisgermanici strain NH11 chromosome, complete genome blastn 27068 278 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Fuerstiella Fuerstiella marisgermanici
9604623 9604623 PRJNA695140_S_NODE_8668_length_180_cov_1.867133_g8487_i0 PRJNA695140 8668 180 1.867133 3.3608394 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 204 3.98e-48   NTclustered gi|2874253903|emb|OY970228.1| 100233 g8487 i0 87.571 109.605555555556 177 21 98 1 1 177 2663825 2664000 MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1 blastn 19729 204 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
11385057 11385057 PRJNA695140_S_NODE_1889_length_384_cov_1.930836_g1708_i0 PRJNA695140 1889 384 1.930836 7.41441024 Gimesia 1649453 Bacteria Bacteria 363 1.49e-95   NTclustered gi|1712472787|gb|CP036266.1| 2605989 g1708 i0 87.5 104.807291666667 320 32 83 8 66 382 2180318 2180004 Gimesia chilikensis strain HG66A1 chromosome blastn 40246 363 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Gimesia Gimesia chilikensis
12155218 12155218 PRJNA695140_S_NODE_1070_length_517_cov_1.752083_g893_i0 PRJNA695140 1070 517 1.752083 9.05826911 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 664 0   NTclustered gi|2874253749|emb|OY969623.1| 1914239 g893 i0 89.792 280.976789168279 529 38 99 12 1 516 7051128 7050603 MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 blastn 145265 664 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
19802925 19802925 PRJNA695140_S_NODE_1316_length_466_cov_3.559441_g1137_i0 PRJNA695140 1316 466 3.559441 16.58699506 Fuerstiella marisgermanici 1891926 Bacteria Bacteria 560 6.08e-155   NTclustered gi|1140105870|gb|CP017641.1| 1891926 g1137 i0 89.135 129.637339055794 451 47 97 2 2 451 5362813 5362364 Fuerstiella marisgermanici strain NH11 chromosome, complete genome blastn 60411 560 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Fuerstiella Fuerstiella marisgermanici
25408027 25408027 PRJNA695140_S_NODE_13200_length_150_cov_2.141593_g13019_i0 PRJNA695140 13200 150 2.141593 3.2123895 Planctomycetia 203683 Bacteria Bacteria 135 1.18e-27   NTclustered gi|2874253749|emb|OY969623.1| 1914239 g13019 i0 94.318 71.9666666666667 88 5 59 0 1 88 7051883 7051796 MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 blastn 10795 135 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae 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);;