contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJEB11748" and tax_phylum = "Ignavibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 984521 | 984521 | PRJEB11748_P_NODE_344781_length_200_cov_48.748201_g342598_i0 | PRJEB11748 | 344781 | 200 | 48.748201 | 97.496402 | Melioribacter | 1134403 | Bacteria | Bacteria | 261 | 2.65e-65 | NTclustered | gi|470490269|ref|NR_076978.1| | 1134405 | g342598 | i0 | 95.181 | 42.81 | 166 | 6 | 83 | 2 | 1 | 165 | 870 | 706 | Melioribacter roseus strain P3M-2 23S ribosomal RNA gene, complete sequence | blastn | 8562 | 261 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacter | Melioribacter roseus | |
| 1290517 | 1290517 | PRJEB11748_P_NODE_217622_length_269_cov_4.519231_g215439_i0 | PRJEB11748 | 217622 | 269 | 4.5192310000000004 | 12.15673139 | Ignavibacterium sp. | 2651167 | Bacteria | Bacteria | 259 | 1.35e-64 | NTclustered | gi|2314740639|dbj|AP026678.1| | 2651167 | g215439 | i0 | 87.225 | 0.843866171003718 | 227 | 29 | 84 | 0 | 19 | 245 | 2371153 | 2371379 | MAG: Ignavibacterium sp. KatS3mg037 DNA, complete genome | blastn | 227 | 259 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacterium | Ignavibacterium sp. | |
| 7360781 | 7360781 | PRJEB11748_P_NODE_154686_length_329_cov_12.160448_g152504_i0 | PRJEB11748 | 154686 | 329 | 12.160448 | 40.00787392 | Melioribacter | 1134403 | Bacteria | Bacteria | 255 | 2.2e-63 | NTclustered | gi|470490269|ref|NR_076978.1| | 1134405 | g152504 | i0 | 86.695 | 106.185410334346 | 233 | 27 | 70 | 3 | 74 | 302 | 1806 | 1574 | Melioribacter roseus strain P3M-2 23S ribosomal RNA gene, complete sequence | blastn | 34935 | 257 | 0.992217898832685 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacter | Melioribacter roseus | |
| 9912704 | 9912704 | PRJEB11748_P_NODE_346548_length_200_cov_2.057554_g344365_i0 | PRJEB11748 | 346548 | 200 | 2.057554 | 4.115108 | Ignavibacterium | 795750 | Bacteria | Bacteria | 292 | 9.4e-75 | NTclustered | gi|470490116|ref|NR_076968.1| | 591197 | g344365 | i0 | 94.271 | 86.35 | 192 | 10 | 96 | 1 | 1 | 192 | 1710 | 1900 | Ignavibacterium album strain Mat9-16 23S ribosomal RNA gene, complete sequence | blastn | 17270 | 292 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacterium | Ignavibacterium album | |
| 15319317 | 15319317 | PRJEB11748_P_NODE_260493_length_240_cov_9.983240_g258310_i0 | PRJEB11748 | 260493 | 240 | 9.98324 | 23.959776 | Ignavibacterium album | 591197 | Bacteria | Bacteria | 180 | 9.49e-41 | NTclustered | gi|383800634|gb|CP003418.1| | 945713 | g258310 | i0 | 81.735 | 1.44583333333333 | 219 | 37 | 91 | 3 | 2 | 219 | 445568 | 445784 | Ignavibacterium album JCM 16511, complete genome | blastn | 347 | 180 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacterium | Ignavibacterium album | |
| 18836125 | 18836125 | PRJEB11748_P_NODE_317255_length_211_cov_11.526667_g315072_i0 | PRJEB11748 | 317255 | 211 | 11.526667 | 24.32126737 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 169 | 1.7599999999999998e-37 | NTclustered | gi|1938788434|gb|CP054181.1| | 2053306 | g315072 | i0 | 95.37 | 105.327014218009 | 108 | 2 | 50 | 3 | 1 | 106 | 1602364 | 1602258 | Ignavibacteria bacterium isolate H1_BAC2 chromosome | blastn | 22224 | 169 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 19141635 | 19141635 | PRJEB11748_P_NODE_212176_length_273_cov_18.745283_g209993_i0 | PRJEB11748 | 212176 | 273 | 18.745283 | 51.17462259 | Melioribacteraceae bacterium | 2614255 | Bacteria | Bacteria | 220 | 6.49e-53 | NTclustered | gi|2621786307|emb|OY782765.1| | 2614255 | g209993 | i0 | 82.879 | 51.5018315018315 | 257 | 32 | 92 | 12 | 24 | 273 | 2846047 | 2845796 | MAG: Melioribacteraceae bacterium isolate b49f5fa7-6043-4eb4-88a3-53a29b1f0925 genome assembly, chromosome: 1 | blastn | 14060 | 220 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae 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);;