metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA688736" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA688736" 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
668345	668345	PRJNA688736_P_NODE_9121_length_493_cov_1.114286_g8837_i0	PRJNA688736	9121	493	1.114286	5.49342998	Candidatus Fluviicola riflensis	1798018	Bacteria	Bacteria	695	0	NTclustered	gi\|1229046090\|gb\|CP022585.1\|	1798018	g8837	i0	92.089	340.584178498986	493	39	100	0	1	493	786332	786824	Candidatus Fluviicola riflensis chromosome, complete genome	blastn	167908	695	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Candidatus Fluviicola riflensis
7555141	7555141	PRJNA688736_P_NODE_20166_length_347_cov_3.043796_g19881_i0	PRJNA688736	20166	347	3.043796	10.56197212	Flavobacterium	237	Bacteria	Bacteria	636	7.13e-178	NTclustered	gi\|2892685955\|gb\|CP174374.1\|	3379707	g19881	i0	99.712	534.527377521614	347	1	100	0	1	347	1248674	1248328	Flavobacterium sp. TBRC 19031 chromosome, complete genome	blastn	185481	641	0.992199687987519	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium mekongense
11381333	11381333	PRJNA688736_P_NODE_48529_length_244_cov_0.912281_g48244_i0	PRJNA688736	48529	244	0.912281	2.22596564	Solitalea	929509	Bacteria	Bacteria	285	1.99e-72	NTclustered	gi\|470489978\|ref\|NR_076960.1\|	995	g48244	i0	90.411	323.25	219	18	90	3	26	244	1422	1207	Solitalea canadensis strain UASM 9D 23S ribosomal RNA gene, complete sequence	blastn	78873	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Solitalea	Solitalea canadensis
18519456	18519456	PRJNA688736_P_NODE_15715_length_387_cov_1.420382_g15430_i0	PRJNA688736	15715	387	1.420382	5.49687834	Cyclobacteriaceae bacterium	2099675	Bacteria	Bacteria	449	1.12e-121	NTclustered	gi\|1869340971\|gb\|CP058703.1\|	2099675	g15430	i0	87.755	290.679586563308	392	39	99	7	3	387	1696441	1696830	MAG: Cyclobacteriaceae bacterium isolate SSA6 chromosome	blastn	112493	449	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae		Cyclobacteriaceae bacterium
19794538	19794538	PRJNA688736_P_NODE_24876_length_318_cov_1.000000_g24591_i0	PRJNA688736	24876	318	1	3.18	Aurantibacillus circumpalustris	3036359	Bacteria	Bacteria	483	8.919999999999998e-132	NTclustered	gi\|2482055248\|gb\|CP121197.1\|	3036359	g24591	i0	94.025	370.883647798742	318	19	100	0	1	318	2012890	2012573	Aurantibacillus circumpalustris strain Swamp196 chromosome, complete genome	blastn	117941	483	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Aurantibacillaceae	Aurantibacillus	Aurantibacillus circumpalustris
19794968	19794968	PRJNA688736_P_NODE_43116_length_250_cov_0.881356_g42831_i0	PRJNA688736	43116	250	0.881356	2.20339	Flavobacterium sp. TBRC 19032	3379707	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2892685960\|gb\|CP174373.1\|	3379708	g42831	i0	100	2	250	0	100	0	1	250	3022523	3022274	Flavobacterium sp. TBRC 19032 chromosome, complete genome	blastn	500	462	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. TBRC 19032
20303587	20303587	PRJNA688736_P_NODE_19616_length_351_cov_2.097122_g19331_i0	PRJNA688736	19616	351	2.097122	7.36089822	Flavobacterium	237	Bacteria	Bacteria	643	4.3e-180	NTclustered	gi\|2892685955\|gb\|CP174374.1\|	3379707	g19331	i0	99.715	549.507122507123	351	1	100	0	1	351	1249947	1249597	Flavobacterium sp. TBRC 19031 chromosome, complete genome	blastn	192877	649	0.99075500770416	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium mekongense
23621066	23621066	PRJNA688736_P_NODE_49079_length_244_cov_0.912281_g48794_i0	PRJNA688736	49079	244	0.912281	2.22596564	Sphingobacterium spiritivorum	258	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2636475595\|gb\|CP139978.1\|	258	g48794	i0	100	3.99180327868852	244	0	100	0	1	244	1895275	1895032	Sphingobacterium spiritivorum strain HAMBI_1896 chromosome, complete genome	blastn	974	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium spiritivorum

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