metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJDB3785" and tax

11 rows where analysis = "blastn", bioproject = "PRJDB3785" and tax_clade = "FCB group"

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
2256441	2256441	PRJDB3785_S_NODE_8042_length_265_cov_1.222222_g7889_i0	PRJDB3785	8042	265	1.222222	3.2388883	Flavobacterium	237	Bacteria	Bacteria	473	4.3599999999999987e-129	NTclustered	gi\|1003115209\|gb\|CP010992.1\|	996	g7889	i0	98.868	682.618867924528	265	3	100	0	1	265	473362	473626	Flavobacterium columnare strain B185, complete genome	blastn	180894	473	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium columnare
11486809	11486809	PRJDB3785_S_NODE_27250_length_161_cov_0.910714_g27097_i0	PRJDB3785	27250	161	0.910714	1.46624954	Capnocytophaga granulosa	45242	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|2831311145\|gb\|CP171122.1\|	45242	g27097	i0	100	0.173913043478261	28	0	17	0	126	153	397932	397959	Capnocytophaga granulosa strain WGS1377 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga granulosa
12460362	12460362	PRJDB3785_S_NODE_11230_length_227_cov_1.146067_g11077_i0	PRJDB3785	11230	227	1.146067	2.60157209	Flavobacterium	237	Bacteria	Bacteria	350	6.400000000000001e-92	NTclustered	gi\|1003115209\|gb\|CP010992.1\|	996	g11077	i0	94.667	99.5770925110132	225	12	99	0	1	225	2875324	2875100	Flavobacterium columnare strain B185, complete genome	blastn	22604	350	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium columnare
13734669	13734669	PRJDB3785_S_NODE_9051_length_251_cov_1.252475_g8898_i0	PRJDB3785	9051	251	1.252475	3.14371225	Flavobacterium	237	Bacteria	Bacteria	448	2.48e-121	NTclustered	gi\|1003115209\|gb\|CP010992.1\|	996	g8898	i0	98.805	703.96015936255	251	3	100	0	1	251	473144	473394	Flavobacterium columnare strain B185, complete genome	blastn	176694	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium columnare
14036837	14036837	PRJDB3785_S_NODE_18712_length_183_cov_1.082090_g18559_i0	PRJDB3785	18712	183	1.08209	1.9802247	Flavobacterium haoranii	683124	Bacteria	Bacteria	119	1.52e-22	NTclustered	gi\|1769900038\|gb\|CP045292.1\|	683124	g18559	i0	80.255	1.77049180327869	157	31	86	0	26	182	337338	337494	Flavobacterium haoranii strain KCTC 23008 chromosome, complete genome	blastn	324	119	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium haoranii
15009044	15009044	PRJDB3785_S_NODE_20512_length_176_cov_1.141732_g20359_i0	PRJDB3785	20512	176	1.141732	2.00944832	Bacteroidota	976	Bacteria	Bacteria	315	1.7199999999999996e-81	NTclustered	gi\|2450142035\|gb\|OQ546399.1\|	239	g20359	i0	98.87	100.568181818182	177	1	100	1	1	176	347	523	Flavobacterium sp. strain CA_59 16S ribosomal RNA gene, partial sequence	blastn	17700	315	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
16283872	16283872	PRJDB3785_S_NODE_18413_length_184_cov_1.133333_g18260_i0	PRJDB3785	18413	184	1.133333	2.08533272	Flavobacterium	237	Bacteria	Bacteria	274	3.0799999999999997e-69	NTclustered	gi\|2324023522\|gb\|CP109993.1\|	2885633	g18260	i0	93.478	539.907608695652	184	12	100	0	1	184	1334343	1334160	Flavobacterium sp. N1719 chromosome, complete genome	blastn	99343	274	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N1719
16585696	16585696	PRJDB3785_S_NODE_24914_length_164_cov_1.330435_g24761_i0	PRJDB3785	24914	164	1.330435	2.1819134	Dysgonomonadaceae bacterium zrk40	2811465	Bacteria	Bacteria	71.3	3.78e-8	NTclustered	gi\|1992198317\|gb\|CP070276.1\|	2811465	g24761	i0	92.157	1.53048780487805	51	2	30	2	71	120	1110711	1110760	Dysgonomonadaceae bacterium zrk40 chromosome, complete genome	blastn	251	71.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae		Dysgonomonadaceae bacterium zrk40
18832923	18832923	PRJDB3785_S_NODE_12315_length_218_cov_1.846154_g12162_i0	PRJDB3785	12315	218	1.846154	4.02461572	Flavobacterium	237	Bacteria	Bacteria	348	2.19e-91	NTclustered	gi\|2183943025\|gb\|CP091285.1\|	998845	g12162	i0	98	391.224770642202	200	4	92	0	19	218	860500	860301	Flavobacterium jumunjinense strain HME7102 chromosome, complete genome	blastn	85287	348	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium jumunjinense
22658188	22658188	PRJDB3785_S_NODE_5138_length_334_cov_1.800000_g4985_i0	PRJDB3785	5138	334	1.8	6.012	Flavobacterium	237	Bacteria	Bacteria	545	1.18e-150	NTclustered	gi\|1003115209\|gb\|CP010992.1\|	996	g4985	i0	96.375	685.913173652695	331	12	100	0	1	331	472629	472959	Flavobacterium columnare strain B185, complete genome	blastn	229095	545	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium columnare
25207266	25207266	PRJDB3785_S_NODE_24960_length_164_cov_1.330435_g24807_i0	PRJDB3785	24960	164	1.330435	2.1819134	Bacteroidota	976	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|1205046745\|gb\|MF289256.1\|	239	g24807	i0	100	243.579268292683	164	0	100	0	1	164	1229	1066	Flavobacterium sp. strain MMS16-B8 16S ribosomal RNA gene, partial sequence	blastn	39947	303	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.

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