contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJEB83101" and tax_kingdom = "Fusobacteriati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7793407 | 7793407 | PRJEB83101_P_NODE_14227_length_502_cov_4.715618_g13930_i0 | PRJEB83101 | 14227 | 502 | 4.715618 | 23.67240236 | Cetobacterium somerae | 188913 | Bacteria | Bacteria | 881 | 0 | NTclustered | gi|2666488225|gb|CP143319.1| | 188913 | g13930 | i0 | 98.406 | 521.284860557769 | 502 | 7 | 100 | 1 | 1 | 502 | 1318969 | 1318469 | Cetobacterium somerae strain ceto chromosome, complete genome | blastn | 261685 | 881 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 8651189 | 8651189 | PRJEB83101_P_NODE_5307_length_888_cov_7.471166_g5062_i0 | PRJEB83101 | 5307 | 888 | 7.471166 | 66.34395408 | Cetobacterium | 180162 | Bacteria | Bacteria | 1607 | 0 | NTclustered | gi|2865368125|gb|CP122294.1| | 188913 | g5062 | i0 | 99.324 | 526.05518018018 | 888 | 6 | 100 | 0 | 1 | 888 | 279559 | 278672 | Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence | blastn | 467137 | 1607 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 8651319 | 8651319 | PRJEB83101_P_NODE_67327_length_252_cov_0.871508_g67022_i0 | PRJEB83101 | 67327 | 252 | 0.871508 | 2.19620016 | Cetobacterium | 180162 | Bacteria | Bacteria | 466 | 6.89e-127 | NTclustered | gi|2666488225|gb|CP143319.1| | 188913 | g67022 | i0 | 100 | 5.46031746031746 | 252 | 0 | 100 | 0 | 1 | 252 | 365840 | 366091 | Cetobacterium somerae strain ceto chromosome, complete genome | blastn | 1376 | 466 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 11621148 | 11621148 | PRJEB83101_P_NODE_69630_length_250_cov_3.016949_g69325_i0 | PRJEB83101 | 69630 | 250 | 3.016949 | 7.5423725 | Fusobacterium pseudoperiodonticum | 2663009 | Bacteria | Bacteria | 462 | 8.83e-126 | NTclustered | gi|1276705688|gb|CP024698.1| | 2663009 | g69325 | i0 | 100 | 486.4 | 250 | 0 | 100 | 0 | 1 | 250 | 508774 | 508525 | Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome | blastn | 121600 | 462 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium pseudoperiodonticum | ||
| 14171112 | 14171112 | PRJEB83101_P_NODE_68412_length_251_cov_1.393258_g68107_i0 | PRJEB83101 | 68412 | 251 | 1.393258 | 3.49707758 | Fusobacterium pseudoperiodonticum | 2663009 | Bacteria | Bacteria | 464 | 2.47e-126 | NTclustered | gi|1276716588|gb|CP024703.1| | 2663009 | g68107 | i0 | 100 | 12 | 251 | 0 | 100 | 0 | 1 | 251 | 1837916 | 1837666 | Fusobacterium pseudoperiodonticum strain KCOM 2305 chromosome, complete genome | blastn | 3012 | 464 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium pseudoperiodonticum | ||
| 15025867 | 15025867 | PRJEB83101_P_NODE_55352_length_267_cov_1.608247_g55047_i0 | PRJEB83101 | 55352 | 267 | 1.608247 | 4.29401949 | Fusobacterium | 848 | Bacteria | Bacteria | 427 | 3.47e-115 | NTclustered | gi|2704942200|gb|CP077195.1| | 285729 | g55047 | i0 | 95.506 | 99.7116104868914 | 267 | 12 | 100 | 0 | 1 | 267 | 2108164 | 2108430 | Fusobacterium canifelinum strain SB044 chromosome, complete genome | blastn | 26623 | 427 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium canifelinum | ||
| 15445122 | 15445122 | PRJEB83101_P_NODE_63173_length_255_cov_1.714286_g62868_i0 | PRJEB83101 | 63173 | 255 | 1.714286 | 4.3714293 | Fusobacterium pseudoperiodonticum | 2663009 | Bacteria | Bacteria | 460 | 3.25e-125 | NTclustered | gi|1276714546|gb|CP024702.1| | 2663009 | g62868 | i0 | 99.216 | 99.6941176470588 | 255 | 2 | 100 | 0 | 1 | 255 | 938880 | 938626 | Fusobacterium pseudoperiodonticum strain KCOM 1282 chromosome, complete genome | blastn | 25422 | 460 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium pseudoperiodonticum | ||
| 21400301 | 21400301 | PRJEB83101_P_NODE_76617_length_247_cov_0.896552_g76312_i0 | PRJEB83101 | 76617 | 247 | 0.896552 | 2.21448344 | Fusobacterium | 848 | Bacteria | Bacteria | 457 | 4.05e-124 | NTclustered | gi|2706407748|gb|CP077116.1| | 76857 | g76312 | i0 | 100 | 100 | 247 | 0 | 100 | 0 | 1 | 247 | 1829908 | 1830154 | Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome | blastn | 24700 | 457 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum |
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);;