metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA450343" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA450343" and tax_phylum = "Bacteroidota"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	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
439058	439058	PRJNA450343_P_NODE_11521_length_166_cov_0.871795_g11453_i0	PRJNA450343	11521	166	0.871795	1.4471797	Spirosoma montaniterrae	1178516	Bacteria	Bacteria	145	2.23e-30	NTclustered	gi\|1142450876\|gb\|CP014263.1\|	1178516	g11453	i0	86.029	2.31325301204819	136	18	81	1	1	135	3065608	3065743	Spirosoma montaniterrae strain DY10 chromosome, complete genome	blastn	384	145	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma montaniterrae
439121	439121	PRJNA450343_P_NODE_6521_length_209_cov_1.931250_g6453_i0	PRJNA450343	6521	209	1.93125	4.0363125	Flavisolibacter tropicus	1492898	Bacteria	Bacteria	259	1.01e-64	NTclustered	gi\|1028466201\|gb\|CP011390.1\|	1492898	g6453	i0	89.1	97.0047846889952	211	20	100	3	1	209	1743855	1743646	Flavisolibacter tropicus strain LCS9 chromosome, complete genome	blastn	20274	259	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter tropicus
1092516	1092516	PRJNA450343_P_NODE_6361_length_212_cov_1.085890_g6293_i0	PRJNA450343	6361	212	1.08589	2.3020868	Cloacibacterium	501783	Bacteria	Bacteria	392	9.67e-105	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g6293	i0	100	465.169811320755	212	0	100	0	1	212	1872547	1872336	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	98616	392	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
5542849	5542849	PRJNA450343_P_NODE_4025_length_265_cov_1.671296_g3957_i0	PRJNA450343	4025	265	1.671296	4.4289344	Flavisolibacter tropicus	1492898	Bacteria	Bacteria	424	4.46e-114	NTclustered	gi\|1028466201\|gb\|CP011390.1\|	1492898	g3957	i0	95.472	220.339622641509	265	12	100	0	1	265	1744504	1744768	Flavisolibacter tropicus strain LCS9 chromosome, complete genome	blastn	58390	424	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter tropicus
6816809	6816809	PRJNA450343_P_NODE_3066_length_307_cov_1.437984_g2998_i0	PRJNA450343	3066	307	1.437984	4.41461088	Chitinophaga filiformis	104663	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2230207502\|gb\|CP095855.1\|	104663	g2998	i0	96.774	0.100977198697068	31	1	10	0	275	305	2854947	2854917	Chitinophaga filiformis strain YT5 chromosome, complete genome	blastn	31	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga filiformis
6816859	6816859	PRJNA450343_P_NODE_9326_length_179_cov_0.884615_g9258_i0	PRJNA450343	9326	179	0.884615	1.58346085	Flavobacterium sediminis	2201181	Bacteria	Bacteria	309	8.15e-80	NTclustered	gi\|1391188358\|gb\|CP029463.1\|	2201181	g9258	i0	98.295	666.061452513967	176	3	100	0	4	179	454471	454296	Flavobacterium sediminis strain MEBiC07310 chromosome, complete genome	blastn	119225	309	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sediminis
8745498	8745498	PRJNA450343_P_NODE_9627_length_176_cov_1.133858_g9559_i0	PRJNA450343	9627	176	1.133858	1.99559008	Flavobacterium	237	Bacteria	Bacteria	326	7.92e-85	NTclustered	gi\|470491519\|ref\|NR_077042.1\|	55197	g9559	i0	100	490.102272727273	176	0	100	0	1	176	2639	2814	Flavobacterium branchiophilum strain FL-15 23S ribosomal RNA gene, complete sequence	blastn	86258	326	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium branchiophilum
9366967	9366967	PRJNA450343_P_NODE_2348_length_355_cov_2.431373_g2280_i0	PRJNA450343	2348	355	2.431373	8.63137415	Flavisolibacter ginsenosidimutans	661481	Bacteria	Bacteria	545	1.26e-150	NTclustered	gi\|1721662073\|gb\|CP042433.1\|	661481	g2280	i0	94.366	286.408450704225	355	20	100	0	1	355	4833091	4833445	Flavisolibacter ginsenosidimutans strain Gsoil 636 chromosome, complete genome	blastn	101675	545	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter ginsenosidimutans
10642918	10642918	PRJNA450343_P_NODE_2229_length_366_cov_1.485804_g2161_i0	PRJNA450343	2229	366	1.485804	5.43804264	Flavisolibacter ginsenosidimutans	661481	Bacteria	Bacteria	499	1.03e-136	NTclustered	gi\|1721662073\|gb\|CP042433.1\|	661481	g2161	i0	91.328	242.497267759563	369	26	100	6	1	366	4832983	4832618	Flavisolibacter ginsenosidimutans strain Gsoil 636 chromosome, complete genome	blastn	88754	499	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter ginsenosidimutans
15741677	15741677	PRJNA450343_P_NODE_14153_length_159_cov_2.427273_g14085_i0	PRJNA450343	14153	159	2.427273	3.85936407	Hymenobacter sp. BRD128	2675878	Bacteria	Bacteria	244	2.02e-60	NTclustered	gi\|1847993467\|gb\|CP053908.1\|	2675878	g14085	i0	94.375	54.6477987421384	160	8	100	1	1	159	338226	338067	Hymenobacter sp. BRD128 chromosome, complete genome	blastn	8689	244	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD128
15741715	15741715	PRJNA450343_P_NODE_6773_length_206_cov_0.974522_g6705_i0	PRJNA450343	6773	206	0.974522	2.00751532	Olleya sp. YS	3028318	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|2487265598\|gb\|CP121685.1\|	3028318	g6705	i0	96.774	0.150485436893204	31	1	15	0	56	86	2841088	2841058	Olleya sp. YS chromosome, complete genome	blastn	31	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Olleya	Olleya sp. YS
17016384	17016384	PRJNA450343_P_NODE_5454_length_227_cov_2.685393_g5386_i0	PRJNA450343	5454	227	2.685393	6.09584211	Chryseobacterium sp. KACC 21268	3025664	Bacteria	Bacteria	420	4.81e-113	NTclustered	gi\|2446111318\|gb\|CP117875.1\|	3025664	g5386	i0	100	358.577092511013	227	0	100	0	1	227	980680	980906	Chryseobacterium sp. KACC 21268 chromosome, complete genome	blastn	81397	420	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. KACC 21268
22115575	22115575	PRJNA450343_P_NODE_1818_length_409_cov_0.908333_g1750_i0	PRJNA450343	1818	409	0.908333	3.71508197	Bacteroidales bacterium	2030927	Bacteria	Bacteria	52.8	0.039	NTclustered	gi\|2621704993\|emb\|OY762280.1\|	2030927	g1750	i0	100	0.0684596577017115	28	0	7	0	234	261	102693	102720	MAG: Bacteroidales bacterium isolate 20329f36-1aa7-4b1c-baf8-c582a14de254 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
23391282	23391282	PRJNA450343_P_NODE_4239_length_258_cov_1.301435_g4171_i0	PRJNA450343	4239	258	1.301435	3.3577023	Panacibacter ginsenosidivorans	1813871	Bacteria	Bacteria	339	1.6099999999999998e-88	NTclustered	gi\|1721657344\|gb\|CP042435.1\|	1813871	g4171	i0	90.661	179.290697674419	257	20	99	4	1	255	1673689	1673943	Panacibacter ginsenosidivorans strain Gsoil1550 chromosome, complete genome	blastn	46257	339	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Panacibacter	Panacibacter ginsenosidivorans
24665291	24665291	PRJNA450343_P_NODE_4700_length_244_cov_3.358974_g4632_i0	PRJNA450343	4700	244	3.358974	8.19589656	Flavisolibacter ginsenosidimutans	661481	Bacteria	Bacteria	444	3.11e-120	NTclustered	gi\|1721662073\|gb\|CP042433.1\|	661481	g4632	i0	99.588	240.819672131148	243	1	99	0	1	243	4833473	4833715	Flavisolibacter ginsenosidimutans strain Gsoil 636 chromosome, complete genome	blastn	58760	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter ginsenosidimutans
25318724	25318724	PRJNA450343_P_NODE_8040_length_191_cov_1.077465_g7972_i0	PRJNA450343	8040	191	1.077465	2.05795815	Flavobacterium	237	Bacteria	Bacteria	350	5.2000000000000014e-92	NTclustered	gi\|1057916935\|gb\|CP012388.1\|	96345	g7972	i0	100	614.565445026178	189	0	99	0	1	189	2974682	2974494	Flavobacterium psychrophilum strain Z1, complete genome	blastn	117382	353	0.991501416430595	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium psychrophilum

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);;