metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA645397" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA645397" 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
619597	619597	PRJNA645397_P_NODE_7401_length_190_cov_1.184397_g7328_i0	PRJNA645397	7401	190	1.184397	2.2503543	Chryseobacterium manosquense	2754694	Bacteria	Bacteria	298	1.9e-76	NTclustered	gi\|1904998852\|gb\|CP060203.1\|	2754694	g7328	i0	98.802	1.75263157894737	167	2	88	0	24	190	1995258	1995424	Chryseobacterium manosquense strain Marseille-Q2069 chromosome	blastn	333	298	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium manosquense
3170397	3170397	PRJNA645397_P_NODE_7263_length_192_cov_0.902098_g7190_i0	PRJNA645397	7263	192	0.902098	1.73202816	Chryseobacterium gambrini	373672	Bacteria	Bacteria	270	4.19e-68	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g7190	i0	96.341	3.41666666666667	164	6	85	0	29	192	4206813	4206976	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	656	270	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
12098995	12098995	PRJNA645397_P_NODE_10850_length_163_cov_0.912281_g10777_i0	PRJNA645397	10850	163	0.912281	1.48701803	Chryseobacterium manosquense	2754694	Bacteria	Bacteria	291	2.64e-74	NTclustered	gi\|1904998852\|gb\|CP060203.1\|	2754694	g10777	i0	98.773	3.22699386503067	163	2	100	0	1	163	2875305	2875467	Chryseobacterium manosquense strain Marseille-Q2069 chromosome	blastn	526	291	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium manosquense
13373660	13373660	PRJNA645397_P_NODE_5991_length_213_cov_0.884146_g5918_i0	PRJNA645397	5991	213	0.884146	1.88323098	Chryseobacterium gambrini	373672	Bacteria	Bacteria	326	1e-84	NTclustered	gi\|2429907221\|gb\|CP116008.1\|	373672	g5918	i0	98.378	37.1596244131455	185	3	87	0	29	213	632151	632335	Chryseobacterium gambrini strain DMF-6 chromosome, complete genome	blastn	7915	326	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
15922468	15922468	PRJNA645397_S_NODE_1313_length_169_cov_1.966667_g1311_i0	PRJNA645397	1313	169	1.966667	3.32366723	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	307	2.73e-79	NTclustered	gi\|1527187866\|gb\|CP034161.1\|	2487072	g1311	i0	99.412	12.1597633136095	170	0	100	1	1	169	2460110	2459941	Epilithonimonas vandammei strain F5649 chromosome, complete genome	blastn	2055	307	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
19010668	19010668	PRJNA645397_P_NODE_10175_length_165_cov_0.896552_g10102_i0	PRJNA645397	10175	165	0.896552	1.4793108	Weeksellaceae	2762318	Bacteria	Bacteria	246	5.9e-61	NTclustered	gi\|1519569220\|gb\|CP033933.1\|	421525	g10102	i0	98.561	1.85454545454545	139	2	84	0	27	165	2597355	2597493	Kaistella haifensis strain G0079 chromosome, complete genome	blastn	306	246	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella haifensis
19010679	19010679	PRJNA645397_S_NODE_1075_length_183_cov_1.126866_g1073_i0	PRJNA645397	1075	183	1.126866	2.06216478	Weeksellaceae	2762318	Bacteria	Bacteria	220	4.04e-53	NTclustered	gi\|1519569220\|gb\|CP033933.1\|	421525	g1073	i0	97.656	6.39890710382514	128	3	70	0	1	128	918149	918276	Kaistella haifensis strain G0079 chromosome, complete genome	blastn	1171	220	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella haifensis
19746410	19746410	PRJNA645397_P_NODE_10536_length_164_cov_0.904348_g10463_i0	PRJNA645397	10536	164	0.904348	1.48313072	Chryseobacterium gambrini	373672	Bacteria	Bacteria	292	7.41e-75	NTclustered	gi\|2631708025\|dbj\|AP029022.1\|	373672	g10463	i0	98.78	2.28048780487805	164	2	100	0	1	164	847396	847233	Chryseobacterium gambrini DW100 DNA, complete genome	blastn	374	292	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
19746411	19746411	PRJNA645397_P_NODE_10556_length_164_cov_0.904348_g10483_i0	PRJNA645397	10556	164	0.904348	1.48313072	Chryseobacterium gambrini	373672	Bacteria	Bacteria	209	7.68e-50	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g10483	i0	91.503	5.04268292682927	153	12	93	1	12	164	120832	120983	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	827	209	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
21561145	21561145	PRJNA645397_P_NODE_3117_length_306_cov_0.805447_g3044_i0	PRJNA645397	3117	306	0.805447	2.46466782	Weeksellaceae	2762318	Bacteria	Bacteria	544	3.86e-150	NTclustered	gi\|1519569220\|gb\|CP033933.1\|	421525	g3044	i0	98.697	2.00653594771242	307	3	100	1	1	306	961113	961419	Kaistella haifensis strain G0079 chromosome, complete genome	blastn	614	544	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella haifensis
22296726	22296726	PRJNA645397_P_NODE_2558_length_337_cov_2.194444_g2485_i0	PRJNA645397	2558	337	2.194444	7.39527628	Chryseobacterium gambrini	373672	Bacteria	Bacteria	562	1.19e-155	NTclustered	gi\|2631708025\|dbj\|AP029022.1\|	373672	g2485	i0	99.045	389.905044510386	314	2	93	1	1	313	1783604	1783917	Chryseobacterium gambrini DW100 DNA, complete genome	blastn	131398	562	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
23572340	23572340	PRJNA645397_P_NODE_9219_length_169_cov_0.866667_g9146_i0	PRJNA645397	9219	169	0.866667	1.46466723	Kaistella haifensis	421525	Bacteria	Bacteria	261	2.15e-65	NTclustered	gi\|1519569220\|gb\|CP033933.1\|	421525	g9146	i0	98.639	1.03550295857988	147	2	87	0	23	169	2578933	2578787	Kaistella haifensis strain G0079 chromosome, complete genome	blastn	175	261	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella haifensis
24111062	24111062	PRJNA645397_P_NODE_10239_length_165_cov_0.896552_g10166_i0	PRJNA645397	10239	165	0.896552	1.4793108	Alistipes	239759	Bacteria	Bacteria	126	8.02e-25	NTclustered	gi\|2188886390\|dbj\|AP025581.1\|	214856	g10166	i0	90.526	15.8969696969697	95	9	58	0	8	102	3221789	3221883	Alistipes finegoldii CE91-St15 DNA, complete genome	blastn	2623	126	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae	Alistipes	Alistipes finegoldii

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