metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJEB25789" and tax

6 rows where analysis = "blastn", bioproject = "PRJEB25789" 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
1297454	1297454	PRJEB25789_S_NODE_20062_length_241_cov_0.916667_g19983_i0	PRJEB25789	20062	241	0.916667	2.20916747	Candidatus Karelsulcia muelleri	336810	Bacteria	Bacteria	440	3.959999999999999e-119	NTclustered	gi\|1041050330\|gb\|CP016223.1\|	336810	g19983	i0	99.585	38.1659751037344	241	1	100	0	1	241	190781	190541	Candidatus Sulcia muelleri strain NC, complete genome	blastn	9198	440	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales		Candidatus Karelsulcia	Candidatus Karelsulcia muelleri
3849502	3849502	PRJEB25789_S_NODE_7364_length_342_cov_1.356877_g7285_i0	PRJEB25789	7364	342	1.3568770000000001	4.64051934	Candidatus Karelsulcia muelleri	336810	Bacteria	Bacteria	627	4.22e-175	NTclustered	gi\|2541951822\|gb\|CP129521.1\|	336810	g7285	i0	99.708	99.8216374269006	342	1	100	0	1	342	84490	84149	Candidatus Karelsulcia muelleri isolate Rd chromosome, complete genome	blastn	34139	627	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales		Candidatus Karelsulcia	Candidatus Karelsulcia muelleri
4814465	4814465	PRJEB25789_S_NODE_18744_length_245_cov_0.860465_g18665_i0	PRJEB25789	18744	245	0.860465	2.10813925	Niabella	379899	Bacteria	Bacteria	316	7.099999999999998e-82	NTclustered	gi\|2070850032\|gb\|CP079214.1\|	2849502	g18665	i0	90.535	141.551020408163	243	17	100	5	4	245	1679325	1679088	Niabella sp. I6 chromosome	blastn	34680	316	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niabella	Niabella sp. I6
10226136	10226136	PRJEB25789_S_NODE_9929_length_306_cov_1.321888_g9850_i0	PRJEB25789	9929	306	1.321888	4.04497728	Candidatus Karelsulcia muelleri	336810	Bacteria	Bacteria	566	8.239999999999998e-157	NTclustered	gi\|2293492713\|gb\|CP093906.1\|	336810	g9850	i0	100	99.6470588235294	306	0	100	0	1	306	11159	11464	Candidatus Sulcia muelleri strain HICO chromosome, complete genome	blastn	30492	566	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales		Candidatus Karelsulcia	Candidatus Karelsulcia muelleri
12776884	12776884	PRJEB25789_S_NODE_6671_length_356_cov_1.045936_g6592_i0	PRJEB25789	6671	356	1.045936	3.72353216	Sediminibacterium sp. TEGAF015	575378	Bacteria	Bacteria	503	7.74e-138	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g6592	i0	92.437	344.907303370787	357	20	99	7	3	356	55043	55395	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	122787	503	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
17874739	17874739	PRJEB25789_S_NODE_1495_length_676_cov_2.411277_g1420_i0	PRJEB25789	1495	676	2.411277	16.30023252	Coprobacter fastidiosus	1099853	Bacteria	Bacteria	152	6.459999999999998e-32	NTclustered	gi\|2487365010\|dbj\|AP028032.1\|	1099853	g1420	i0	83.529	46.5369822485207	170	21	25	7	127	292	1036792	1036626	Coprobacter fastidiosus JCM 33896 DNA, complete genome	blastn	31459	152	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Barnesiellaceae	Coprobacter	Coprobacter fastidiosus

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