RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA316313" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA316313 · 13 ✖

analysis 1

  • blastn · 13 ✖
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
1660944 1660944 PRJNA316313_P_NODE_150642_length_187_cov_4.660000_g149256_i0 PRJNA316313 150642 187 4.66 8.7142 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 102 1.57e-17   NTclustered gi|2874253978|emb|OY970303.1| 412054 g149256 i0 90.789 0.406417112299465 76 7 41 0 1 76 5417330 5417405 MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 blastn 76 102 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
4214409 4214409 PRJNA316313_P_NODE_308824_length_187_cov_2.373333_g307438_i0 PRJNA316313 308824 187 2.373333 4.43813271 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 71.3 4.42e-8   NTclustered gi|2874253978|emb|OY970303.1| 412054 g307438 i0 89.286 0.502673796791444 56 6 30 0 113 168 2484327 2484272 MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 blastn 94 71.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
6765416 6765416 PRJNA316313_P_NODE_410586_length_151_cov_5.850877_g409200_i0 PRJNA316313 410586 151 5.850877 8.83482427 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 100 4.34e-17   NTclustered gi|575456455|gb|CP007128.1| 861299 g409200 i0 98.246 2.70860927152318 57 1 38 0 1 57 4201339 4201283 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 409 100 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
6765648 6765648 PRJNA316313_P_NODE_457946_length_151_cov_3.359649_g456560_i0 PRJNA316313 457946 151 3.359649 5.07306999 Longimicrobiales bacterium 2910168 Bacteria Bacteria 58.4 2.65e-4   NTclustered gi|2893356045|emb|OZ220468.1| 2910168 g456560 i0 97.059 0.225165562913907 34 1 23 0 1 34 1749855 1749822 MAG: Longimicrobiales bacterium isolate ddfa3c06-a013-4680-9539-8883dc2ec397 genome assembly, chromosome: 1 blastn 34 58.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
8041415 8041415 PRJNA316313_P_NODE_475167_length_151_cov_2.798246_g473781_i0 PRJNA316313 475167 151 2.798246 4.22535146 Pseudogemmatithrix spongiicola 3062599 Bacteria Bacteria 110 7.21e-20   NTclustered gi|2557479348|gb|CP130613.1| 3062599 g473781 i0 92.308 1.03311258278146 78 4 51 2 75 151 1812239 1812315 Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome blastn 156 110 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Pseudogemmatithrix Pseudogemmatithrix spongiicola
8041599 8041599 PRJNA316313_P_NODE_507107_length_150_cov_2.991150_g505721_i0 PRJNA316313 507107 150 2.99115 4.486725 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 58.4 2.63e-4   NTclustered gi|2874253755|emb|OY969695.1| 412054 g505721 i0 100 0.206666666666667 31 0 21 0 10 40 1159126 1159156 MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1 blastn 31 58.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
13140820 13140820 PRJNA316313_P_NODE_316171_length_187_cov_2.300000_g314785_i0 PRJNA316313 316171 187 2.3 4.301 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 84.2 5.68e-12   NTclustered gi|2893358392|emb|OZ220683.1| 2026742 g314785 i0 97.917 6.72192513368984 48 1 26 0 6 53 470253 470300 MAG: Gemmatimonadota bacterium isolate c4f6f2ca-7934-440c-833b-e1b430e415c5 genome assembly, chromosome: 1 blastn 1257 84.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
13141668 13141668 PRJNA316313_P_NODE_461431_length_151_cov_3.280702_g460045_i0 PRJNA316313 461431 151 3.280702 4.95386002 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 100 4.34e-17   NTclustered gi|575456455|gb|CP007128.1| 861299 g460045 i0 93.939 23.7218543046358 66 4 44 0 86 151 4452313 4452248 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 3582 100 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
16964066 16964066 PRJNA316313_P_NODE_234674_length_187_cov_3.000000_g233288_i0 PRJNA316313 234674 187 3 5.61 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 111 2.6e-20   NTclustered gi|2874253755|emb|OY969695.1| 412054 g233288 i0 93.333 5.82887700534759 75 5 40 0 2 76 280852 280926 MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1 blastn 1090 111 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
16964387 16964387 PRJNA316313_P_NODE_291134_length_187_cov_2.486667_g289748_i0 PRJNA316313 291134 187 2.486667 4.65006729 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 80.5 7.34e-11   NTclustered gi|2874253938|emb|OY970263.1| 412054 g289748 i0 92.727 0.294117647058824 55 4 29 0 133 187 1332886 1332940 MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1 blastn 55 80.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
18238799 18238799 PRJNA316313_P_NODE_317435_length_187_cov_2.280000_g316049_i0 PRJNA316313 317435 187 2.28 4.2636 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 52.8 0.016   NTclustered gi|2874254107|emb|OY970192.1| 412054 g316049 i0 100 0.149732620320856 28 0 15 0 1 28 3604727 3604754 MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
22063524 22063524 PRJNA316313_P_NODE_300618_length_187_cov_2.426667_g299232_i0 PRJNA316313 300618 187 2.426667 4.53786729 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 91.6 3.39e-14   NTclustered gi|2874254163|emb|OY970395.1| 412054 g299232 i0 93.443 2.26737967914439 61 4 33 0 127 187 1790135 1790075 MAG: uncultured Gemmatimonadales bacterium isolate MFD05684.bin.c.1 genome assembly, chromosome: 1 blastn 424 91.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
23340118 23340118 PRJNA316313_P_NODE_492999_length_150_cov_4.088496_g491613_i0 PRJNA316313 492999 150 4.088496 6.132744 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 113 5.53e-21   NTclustered gi|575456455|gb|CP007128.1| 861299 g491613 i0 93.421 0.98 76 5 51 0 75 150 3546235 3546310 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 147 113 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis

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