RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJEB28062" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 9 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB28062 · 9 ✖

analysis 1

  • blastn · 9 ✖
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
5126332 5126332 PRJEB28062_P_NODE_126825_length_247_cov_0.885057_g124461_i0 PRJEB28062 126825 247 0.885057 2.18609079 Gemmatimonas groenlandica 2732249 Bacteria Bacteria 204 5.819999999999998e-48   NTclustered gi|1839994010|gb|CP053085.1| 2732249 g124461 i0 94.656 43.8056680161943 131 7 91 0 117 247 2704688 2704818 Gemmatimonas groenlandica strain TET16 chromosome, complete genome blastn 10820 204 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas groenlandica
6402273 6402273 PRJEB28062_P_NODE_14626_length_1000_cov_2.567422_g12778_i0 PRJEB28062 14626 1000 2.567422 25.67422 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 824 0   NTclustered gi|2874253755|emb|OY969695.1| 412054 g12778 i0 83.514 79.738 922 112 90 37 60 955 318147 319054 MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1 blastn 79738 824 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
6403960 6403960 PRJEB28062_P_NODE_9166_length_1290_cov_14.521775_g7647_i0 PRJEB28062 9166 1290 14.521775 187.3308975 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 575 6.329999999999998e-159   NTclustered gi|575456455|gb|CP007128.1| 861299 g7647 i0 82.946 36.5441860465116 645 102 50 8 22 662 3361879 3362519 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 47142 575 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
11503606 11503606 PRJEB28062_P_NODE_80390_length_376_cov_1.372937_g78028_i0 PRJEB28062 80390 376 1.372937 5.16224312 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 444 5.06e-120   NTclustered gi|2874253978|emb|OY970303.1| 412054 g78028 i0 89.167 2.48404255319149 360 33 95 6 3 360 586537 586182 MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 blastn 934 444 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
14051989 14051989 PRJEB28062_P_NODE_122032_length_256_cov_1.136612_g119668_i0 PRJEB28062 122032 256 1.136612 2.90972672 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 73.1 1.79e-8   NTclustered gi|2621703971|emb|OY762926.1| 2026742 g119668 i0 97.619 0.1640625 42 1 16 0 32 73 2802748 2802789 MAG: Gemmatimonadota bacterium isolate 6e3ee631-f785-49ea-85f7-2f24cfa146af genome assembly, chromosome: 1 blastn 42 73.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
16600999 16600999 PRJEB28062_P_NODE_15974_length_952_cov_7.784983_g14071_i0 PRJEB28062 15974 952 7.784983 74.11303816 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 761 0   NTclustered gi|2874253978|emb|OY970303.1| 412054 g14071 i0 90.136 69.3739495798319 588 54 96 4 30 615 3485517 3486102 MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 blastn 66044 761 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
16601366 16601366 PRJEB28062_P_NODE_32134_length_648_cov_24.857391_g29833_i0 PRJEB28062 32134 648 24.857391 161.07589368 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 693 0   NTclustered gi|2874253728|emb|OY969570.1| 412054 g29833 i0 87.399 47.2515432098765 619 59 94 15 21 626 2236303 2236915 MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 blastn 30619 693 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
19149419 19149419 PRJEB28062_P_NODE_125776_length_248_cov_4.462857_g123412_i0 PRJEB28062 125776 248 4.462857 11.06788536 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 263 9.519999999999998e-66   NTclustered gi|2874253728|emb|OY969570.1| 412054 g123412 i0 90.863 165.298387096774 197 16 79 2 23 218 174171 174366 MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 blastn 40994 263 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
24251389 24251389 PRJEB28062_P_NODE_82800_length_368_cov_2.271186_g80438_i0 PRJEB28062 82800 368 2.271186 8.35796448 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 130 1.57e-25   NTclustered gi|2874254107|emb|OY970192.1| 412054 g80438 i0 76.046 0.714673913043478 263 56 70 7 29 287 375073 375332 MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1 blastn 263 130 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales 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);;