contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA663960" and tax_clade = "FCB group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4456839 | 4456839 | PRJNA663960_S_NODE_724_length_780_cov_3.557981_g480_i1 | PRJNA663960 | 724 | 780 | 3.557981 | 27.7522518 | Porphyromonas sp. oral taxon 275 | 712435 | Bacteria | Bacteria | 1099 | 0 | NTclustered | gi|2028834772|gb|CP072333.1| | 712435 | g480 | i1 | 92.327 | 525.576923076923 | 782 | 46 | 99 | 12 | 1 | 777 | 442742 | 443514 | Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome | blastn | 409950 | 1099 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Porphyromonadaceae | Porphyromonas | Porphyromonas sp. oral taxon 275 | |
| 4990466 | 4990466 | PRJNA663960_S_NODE_8144_length_354_cov_3.863192_g7908_i0 | PRJNA663960 | 8144 | 354 | 3.863192 | 13.67569968 | Bacteroidaceae | 815 | Bacteria | Bacteria | 460 | 4.689999999999999e-125 | NTclustered | gi|2098064349|gb|CP081898.1| | 818 | g7908 | i0 | 90.113 | 5.00847457627119 | 354 | 35 | 100 | 0 | 1 | 354 | 6013916 | 6014269 | Bacteroides thetaiotaomicron strain BFG-55 chromosome, complete genome | blastn | 1773 | 460 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidaceae | Bacteroides | Bacteroides thetaiotaomicron | |
| 11365512 | 11365512 | PRJNA663960_S_NODE_14609_length_297_cov_4.032000_g14373_i0 | PRJNA663960 | 14609 | 297 | 4.032 | 11.97504 | Capnocytophaga | 1016 | Bacteria | Bacteria | 549 | 8.029999999999997e-152 | NTclustered | gi|1844455069|gb|MT505507.1| | 1019 | g14373 | i0 | 100 | 99.993265993266 | 297 | 0 | 100 | 0 | 1 | 297 | 189 | 485 | Capnocytophaga sputigena strain KCOM 3358 (=ChDC P009-2) 16S ribosomal RNA gene, partial sequence | blastn | 29698 | 549 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Capnocytophaga | Capnocytophaga sputigena | |
| 12108177 | 12108177 | PRJNA663960_S_NODE_51190_length_169_cov_1.729508_g50954_i0 | PRJNA663960 | 51190 | 169 | 1.729508 | 2.92286852 | Pedobacter heparinus | 984 | Bacteria | Bacteria | 54.7 | 0.004 | NTclustered | gi|255342900|gb|CP001681.1| | 485917 | g50954 | i0 | 100 | 0.171597633136095 | 29 | 0 | 17 | 0 | 99 | 127 | 93393 | 93421 | Pedobacter heparinus DSM 2366, complete genome | blastn | 29 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Pedobacter | Pedobacter heparinus | |
| 13382891 | 13382891 | PRJNA663960_S_NODE_49411_length_172_cov_2.448000_g49175_i0 | PRJNA663960 | 49411 | 172 | 2.448 | 4.21056 | Christiangramia echinicola | 279359 | Bacteria | Bacteria | 52.8 | 0.014 | NTclustered | gi|1085804381|emb|LT629745.1| | 279359 | g49175 | i0 | 100 | 0.162790697674419 | 28 | 0 | 16 | 0 | 92 | 119 | 1055053 | 1055026 | Gramella echinicola strain Mar_2010_102 genome assembly, chromosome: I | blastn | 28 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Christiangramia | Christiangramia echinicola | |
| 17206831 | 17206831 | PRJNA663960_S_NODE_41194_length_190_cov_1.069930_g40958_i0 | PRJNA663960 | 41194 | 190 | 1.06993 | 2.032867 | Sphingobacterium multivorum | 28454 | Bacteria | Bacteria | 351 | 1.4399999999999997e-92 | NTclustered | gi|1986727426|gb|CP069793.1| | 28454 | g40958 | i0 | 100 | 439.236842105263 | 190 | 0 | 100 | 0 | 1 | 190 | 172019 | 171830 | Sphingobacterium multivorum strain FDAARGOS_1203 chromosome | blastn | 83455 | 351 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Sphingobacteriia | Sphingobacteriales | Sphingobacteriaceae | Sphingobacterium | Sphingobacterium multivorum | |
| 18481125 | 18481125 | PRJNA663960_S_NODE_35995_length_203_cov_0.980769_g35759_i0 | PRJNA663960 | 35995 | 203 | 0.980769 | 1.99096107 | Porphyromonas sp. oral taxon 275 | 712435 | Bacteria | Bacteria | 279 | 7.45e-71 | NTclustered | gi|2028834772|gb|CP072333.1| | 712435 | g35759 | i0 | 91.626 | 33.4039408866995 | 203 | 16 | 100 | 1 | 1 | 203 | 443700 | 443901 | Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome | blastn | 6781 | 279 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Porphyromonadaceae | Porphyromonas | Porphyromonas sp. oral taxon 275 | |
| 18481254 | 18481254 | PRJNA663960_S_NODE_5215_length_405_cov_3.765363_g4979_i0 | PRJNA663960 | 5215 | 405 | 3.765363 | 15.24972015 | Porphyromonas sp. oral taxon 275 | 712435 | Bacteria | Bacteria | 449 | 1.18e-121 | NTclustered | gi|2028834772|gb|CP072333.1| | 712435 | g4979 | i0 | 86.732 | 1.00493827160494 | 407 | 50 | 100 | 3 | 1 | 405 | 1765715 | 1765311 | Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome | blastn | 407 | 449 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Porphyromonadaceae | Porphyromonas | Porphyromonas sp. oral taxon 275 | |
| 18481301 | 18481301 | PRJNA663960_S_NODE_595_length_826_cov_3.573813_g480_i0 | PRJNA663960 | 595 | 826 | 3.573813 | 29.51969538 | Porphyromonas sp. oral taxon 275 | 712435 | Bacteria | Bacteria | 1362 | 0 | NTclustered | gi|2028834772|gb|CP072333.1| | 712435 | g480 | i0 | 96.489 | 434.48789346247 | 826 | 26 | 100 | 3 | 1 | 826 | 443564 | 442742 | Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome | blastn | 358887 | 1362 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Porphyromonadaceae | Porphyromonas | Porphyromonas sp. oral taxon 275 | |
| 22306097 | 22306097 | PRJNA663960_S_NODE_4018_length_442_cov_7.324051_g3783_i0 | PRJNA663960 | 4018 | 442 | 7.324051 | 32.372305420000004 | Flavobacterium dauae | 1563479 | Bacteria | Bacteria | 56.5 | 0.003 | NTclustered | gi|2557430891|gb|CP130821.1| | 1563479 | g3783 | i0 | 100 | 0.0678733031674208 | 30 | 0 | 7 | 0 | 287 | 316 | 1161409 | 1161438 | Flavobacterium dauae strain TCH3-2 chromosome, complete genome | blastn | 30 | 56.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium dauae | |
| 22306260 | 22306260 | PRJNA663960_S_NODE_8678_length_348_cov_2.983389_g8442_i0 | PRJNA663960 | 8678 | 348 | 2.983389 | 10.38219372 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 54.7 | 0.009 | NTclustered | gi|2621786220|emb|OY782678.1| | 2030927 | g8442 | i0 | 100 | 0.0833333333333333 | 29 | 0 | 8 | 0 | 135 | 163 | 472981 | 472953 | MAG: Bacteroidales bacterium isolate 1f9300ae-d6db-4a26-8fb7-1be2ee45184d genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 23581605 | 23581605 | PRJNA663960_S_NODE_9559_length_338_cov_3.422680_g9323_i0 | PRJNA663960 | 9559 | 338 | 3.42268 | 11.5686584 | Porphyromonas pogonae | 867595 | Bacteria | Bacteria | 305 | 2.22e-78 | NTclustered | gi|2665661841|gb|CP143258.1| | 867595 | g9323 | i0 | 83.14 | 409.62426035503 | 344 | 49 | 100 | 7 | 1 | 338 | 263845 | 264185 | Porphyromonas pogonae strain PP01-1 chromosome, complete genome | blastn | 138453 | 305 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Porphyromonadaceae | Porphyromonas | Porphyromonas pogonae | |
| 24854868 | 24854868 | PRJNA663960_S_NODE_18640_length_272_cov_5.857778_g18404_i0 | PRJNA663960 | 18640 | 272 | 5.857778 | 15.93315616 | Hymenobacter sp. 5317J-9 | 2932250 | Bacteria | Bacteria | 453 | 5.8600000000000006e-123 | NTclustered | gi|2221939013|gb|CP095050.1| | 2932250 | g18404 | i0 | 96.691 | 314.511029411765 | 272 | 9 | 100 | 0 | 1 | 272 | 1964625 | 1964896 | Hymenobacter sp. 5317J-9 chromosome, complete genome | blastn | 85547 | 453 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Hymenobacteraceae | Hymenobacter | Hymenobacter sp. 5317J-9 |
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);;