contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax_phylum = "Gemmatimonadota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1054198 | 1054198 | PRJNA168635_P_NODE_13641_length_219_cov_3.435294_g13225_i0 | PRJNA168635 | 13641 | 219 | 3.435294 | 7.52329386 | Gemmatimonas | 173479 | Bacteria | Bacteria | 388 | 1.3e-103 | NTclustered | gi|1015602748|gb|CP011454.1| | 1379270 | g13225 | i0 | 98.63 | 14.6027397260274 | 219 | 3 | 100 | 0 | 1 | 219 | 2076153 | 2075935 | Gemmatimonas phototrophica strain AP64, complete genome | blastn | 3198 | 388 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas phototrophica | |
| 1054396 | 1054396 | PRJNA168635_P_NODE_4381_length_402_cov_9.390935_g3979_i0 | PRJNA168635 | 4381 | 402 | 9.390935 | 37.7515587 | Gemmatimonas | 173479 | Bacteria | Bacteria | 667 | 0 | NTclustered | gi|470475286|ref|NR_076270.1| | 173480 | g3979 | i0 | 99.189 | 513.597014925373 | 370 | 3 | 92 | 0 | 33 | 402 | 1157 | 788 | Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence | blastn | 206466 | 667 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas aurantiaca | |
| 4191739 | 4191739 | PRJNA168635_P_NODE_33284_length_158_cov_4.128440_g32868_i0 | PRJNA168635 | 33284 | 158 | 4.12844 | 6.5229352 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 60.2 | 7.8e-5 | NTclustered | gi|2874253728|emb|OY969570.1| | 412054 | g32868 | i0 | 85.965 | 1.80379746835443 | 57 | 6 | 35 | 2 | 59 | 114 | 171719 | 171774 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 | blastn | 285 | 60.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 6157014 | 6157014 | PRJNA168635_P_NODE_2625_length_509_cov_5.178261_g2239_i0 | PRJNA168635 | 2625 | 509 | 5.178261 | 26.35734849 | Gemmatimonas | 173479 | Bacteria | Bacteria | 754 | 0 | NTclustered | gi|470475286|ref|NR_076270.1| | 173480 | g2239 | i0 | 93.491 | 329.730844793713 | 507 | 33 | 99 | 0 | 3 | 509 | 1903 | 1397 | Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence | blastn | 167833 | 754 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas aurantiaca | |
| 6157155 | 6157155 | PRJNA168635_P_NODE_9985_length_262_cov_10.788732_g9570_i0 | PRJNA168635 | 9985 | 262 | 10.788732 | 28.26647784 | Gemmatimonas | 173479 | Bacteria | Bacteria | 446 | 9.379999999999998e-121 | NTclustered | gi|470475286|ref|NR_076270.1| | 173480 | g9570 | i0 | 97.328 | 39.8015267175573 | 262 | 7 | 100 | 0 | 1 | 262 | 2012 | 2273 | Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence | blastn | 10428 | 446 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas aurantiaca | |
| 8017851 | 8017851 | PRJNA168635_P_NODE_24667_length_170_cov_1.652893_g24251_i0 | PRJNA168635 | 24667 | 170 | 1.652893 | 2.8099181 | Pseudogemmatithrix spongiicola | 3062599 | Bacteria | Bacteria | 161 | 2.26e-35 | NTclustered | gi|2557479348|gb|CP130613.1| | 3062599 | g24251 | i0 | 84.302 | 33.0470588235294 | 172 | 19 | 99 | 4 | 1 | 168 | 1552647 | 1552814 | Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome | blastn | 5618 | 161 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Pseudogemmatithrix | Pseudogemmatithrix spongiicola | |
| 14393577 | 14393577 | PRJNA168635_P_NODE_21472_length_178_cov_1.232558_g21056_i0 | PRJNA168635 | 21472 | 178 | 1.232558 | 2.19395324 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 233 | 5.01e-57 | NTclustered | gi|2874253728|emb|OY969570.1| | 412054 | g21056 | i0 | 90.556 | 186.837078651685 | 180 | 11 | 99 | 5 | 2 | 178 | 173223 | 173047 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 | blastn | 33257 | 233 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 17631818 | 17631818 | PRJNA168635_P_NODE_1494_length_649_cov_5.311667_g1157_i0 | PRJNA168635 | 1494 | 649 | 5.311667 | 34.47271883 | Gemmatimonas | 173479 | Bacteria | Bacteria | 1042 | 0 | NTclustered | gi|470475286|ref|NR_076270.1| | 173480 | g1157 | i0 | 95.712 | 145.730354391371 | 653 | 18 | 100 | 8 | 1 | 649 | 850 | 204 | Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence | blastn | 94579 | 1042 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas aurantiaca | |
| 18216210 | 18216210 | PRJNA168635_P_NODE_23195_length_173_cov_2.717742_g22779_i0 | PRJNA168635 | 23195 | 173 | 2.717742 | 4.70169366 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 224 | 2.91e-54 | NTclustered | gi|2874254107|emb|OY970192.1| | 412054 | g22779 | i0 | 91.463 | 226.28323699422 | 164 | 12 | 94 | 2 | 2 | 164 | 1592074 | 1592236 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1 | blastn | 39147 | 224 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium |
Advanced export
JSON shape: default, array, newline-delimited
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);;