contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA672101" and tax_phylum = "Bacteroidota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 642080 | 642080 | PRJNA672101_S_NODE_6441_length_385_cov_6.541667_g6410_i0 | PRJNA672101 | 6441 | 385 | 6.541667 | 25.18541795 | Hymenobacter sp. YIM 151500-1 | 2987689 | Bacteria | Bacteria | 695 | 0 | NTclustered | gi|2324833882|gb|CP110139.1| | 2987689 | g6410 | i0 | 99.221 | 276.433766233766 | 385 | 3 | 100 | 0 | 1 | 385 | 307089 | 306705 | Hymenobacter sp. YIM 151500-1 chromosome, complete genome | blastn | 106427 | 695 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Hymenobacteraceae | Hymenobacter | Hymenobacter sp. YIM 151500-1 | |
| 3193011 | 3193011 | PRJNA672101_S_NODE_6223_length_388_cov_13.412698_g6192_i0 | PRJNA672101 | 6223 | 388 | 13.412698 | 52.04126824 | Flavobacterium dauae | 1563479 | Bacteria | Bacteria | 56.5 | 0.003 | NTclustered | gi|2557430891|gb|CP130821.1| | 1563479 | g6192 | i0 | 100 | 0.077319587628866 | 30 | 0 | 8 | 0 | 102 | 131 | 1161438 | 1161409 | Flavobacterium dauae strain TCH3-2 chromosome, complete genome | blastn | 30 | 56.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium dauae | |
| 3717227 | 3717227 | PRJNA672101_S_NODE_17863_length_295_cov_6.144144_g17832_i0 | PRJNA672101 | 17863 | 295 | 6.144144 | 18.1252248 | Flavobacterium | 237 | Bacteria | Bacteria | 545 | 1.03e-150 | NTclustered | gi|2447257787|gb|CP092822.1| | 1454066 | g17832 | i0 | 100 | 477 | 295 | 0 | 100 | 0 | 1 | 295 | 1450675 | 1450381 | Flavobacterium sp. WW92 chromosome, complete genome | blastn | 140715 | 545 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. WW92 | |
| 4469921 | 4469921 | PRJNA672101_S_NODE_3004_length_457_cov_6.411458_g2973_i0 | PRJNA672101 | 3004 | 457 | 6.411458 | 29.30036306 | Hymenobacter sp. 5516J-16 | 2932253 | Bacteria | Bacteria | 745 | 0 | NTclustered | gi|2221889893|gb|CP095058.1| | 2932253 | g2973 | i0 | 96.061 | 298.667396061269 | 457 | 18 | 100 | 0 | 1 | 457 | 1006872 | 1006416 | Hymenobacter sp. 5516J-16 chromosome, complete genome | blastn | 136491 | 745 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Hymenobacteraceae | Hymenobacter | Hymenobacter sp. 5516J-16 | |
| 7020431 | 7020431 | PRJNA672101_S_NODE_1746_length_520_cov_7.118568_g1716_i0 | PRJNA672101 | 1746 | 520 | 7.118568 | 37.0165536 | Hymenobacter sp. YIM 151500-1 | 2987689 | Bacteria | Bacteria | 955 | 0 | NTclustered | gi|2324833882|gb|CP110139.1| | 2987689 | g1716 | i0 | 99.808 | 318.275 | 520 | 1 | 100 | 0 | 1 | 520 | 306662 | 306143 | Hymenobacter sp. YIM 151500-1 chromosome, complete genome | blastn | 165503 | 955 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Hymenobacteraceae | Hymenobacter | Hymenobacter sp. YIM 151500-1 | |
| 12644805 | 12644805 | PRJNA672101_S_NODE_12430_length_329_cov_2.363281_g12399_i0 | PRJNA672101 | 12430 | 329 | 2.363281 | 7.77519449 | Flavobacteriaceae | 49546 | Bacteria | Bacteria | 553 | 6.959999999999998e-153 | NTclustered | gi|2232519123|gb|CP096205.1| | 1871076 | g12399 | i0 | 96.97 | 729.373860182371 | 330 | 9 | 100 | 1 | 1 | 329 | 668074 | 667745 | Flavobacterium azooxidireducens strain IGB 4-14 chromosome, complete genome | blastn | 239964 | 558 | 0.991039426523297 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium azooxidireducens | |
| 13395830 | 13395830 | PRJNA672101_S_NODE_13691_length_320_cov_4.542510_g13660_i0 | PRJNA672101 | 13691 | 320 | 4.54251 | 14.536032 | Hymenobacter baengnokdamensis | 2615203 | Bacteria | Bacteria | 536 | 6.799999999999998e-148 | NTclustered | gi|1752950296|gb|CP044285.1| | 2615203 | g13660 | i0 | 96.875 | 430.11875 | 320 | 10 | 100 | 0 | 1 | 320 | 1423319 | 1423000 | Hymenobacter baengnokdamensis strain BRD72 chromosome, complete genome | blastn | 137638 | 536 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Hymenobacteraceae | Hymenobacter | Hymenobacter baengnokdamensis | |
| 13919483 | 13919483 | PRJNA672101_S_NODE_30111_length_247_cov_5.781609_g30080_i0 | PRJNA672101 | 30111 | 247 | 5.7816090000000004 | 14.28057423 | Chryseobacterium | 59732 | Bacteria | Bacteria | 418 | 1.9099999999999998e-112 | NTclustered | gi|2653363380|gb|CP142423.1| | 59733 | g30080 | i0 | 97.166 | 6.05668016194332 | 247 | 7 | 100 | 0 | 1 | 247 | 1201908 | 1202154 | Chryseobacterium scophthalmum strain JUb44 chromosome | blastn | 1496 | 418 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Chryseobacterium | Chryseobacterium scophthalmum | |
| 13919485 | 13919485 | PRJNA672101_S_NODE_34491_length_229_cov_3.096154_g34460_i0 | PRJNA672101 | 34491 | 229 | 3.096154 | 7.09019266 | Capnocytophaga | 1016 | Bacteria | Bacteria | 424 | 3.76e-114 | NTclustered | gi|1139278476|emb|LT692838.1| | 1018 | g34460 | i0 | 100 | 99.9868995633188 | 229 | 0 | 100 | 0 | 1 | 229 | 383 | 611 | Capnocytophaga ochracea partial 16S rRNA gene, isolate W198N_18255 | blastn | 22897 | 424 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Capnocytophaga | Capnocytophaga ochracea | |
| 14671180 | 14671180 | PRJNA672101_S_NODE_8852_length_358_cov_7.470175_g8821_i0 | PRJNA672101 | 8852 | 358 | 7.470175 | 26.7432265 | Chryseobacterium sp. KACC 21268 | 3025664 | Bacteria | Bacteria | 564 | 3.519999999999999e-156 | NTclustered | gi|2446111318|gb|CP117875.1| | 3025664 | g8821 | i0 | 98.442 | 457.209497206704 | 321 | 3 | 90 | 1 | 38 | 358 | 981051 | 980733 | Chryseobacterium sp. KACC 21268 chromosome, complete genome | blastn | 163681 | 564 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Chryseobacterium | Chryseobacterium sp. KACC 21268 | |
| 21567613 | 21567613 | PRJNA672101_S_NODE_9437_length_353_cov_3.025000_g9406_i0 | PRJNA672101 | 9437 | 353 | 3.025 | 10.67825 | Dyadobacter | 120831 | Bacteria | Bacteria | 606 | 5.68e-169 | NTclustered | gi|2221365986|gb|CP094997.1| | 2906456 | g9406 | i0 | 97.734 | 421.900849858357 | 353 | 6 | 100 | 2 | 1 | 353 | 5504394 | 5504044 | Dyadobacter chenwenxiniae strain LJ419 chromosome, complete genome | blastn | 148931 | 612 | 0.990196078431373 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Spirosomataceae | Dyadobacter | Dyadobacter chenwenxiniae | |
| 23594894 | 23594894 | PRJNA672101_S_NODE_31659_length_244_cov_3.152047_g31628_i0 | PRJNA672101 | 31659 | 244 | 3.152047 | 7.69099468 | Hymenobacter yonginensis | 748197 | Bacteria | Bacteria | 348 | 2.51e-91 | NTclustered | gi|2423912131|gb|CP115396.1| | 748197 | g31628 | i0 | 95.434 | 315.995901639344 | 219 | 9 | 89 | 1 | 11 | 228 | 2576210 | 2576428 | Hymenobacter yonginensis strain KCTC 22745 chromosome, complete genome | blastn | 77103 | 348 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Hymenobacteraceae | Hymenobacter | Hymenobacter yonginensis |
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);;