metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA683669" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA683669" 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
1940960	1940960	PRJNA683669_P_NODE_24782_length_258_cov_1.881081_g24550_i0	PRJNA683669	24782	258	1.881081	4.85318898	Lacibacter sp. MH-610	3020883	Bacteria	Bacteria	472	1.52e-128	NTclustered	gi\|2865359271\|gb\|CP116002.1\|	3020883	g24550	i0	99.612	244.182170542636	258	1	100	0	1	258	3293494	3293751	Lacibacter sp. MH-610 chromosome	blastn	62999	472	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Lacibacter	Lacibacter sp. MH-610
1941007	1941007	PRJNA683669_P_NODE_31082_length_245_cov_0.895349_g30850_i0	PRJNA683669	31082	245	0.895349	2.19360505	Dyadobacter pollutisoli	2910158	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2381182547\|gb\|CP112998.1\|	2910158	g30850	i0	100	0.114285714285714	28	0	11	0	169	196	4994009	4993982	Dyadobacter pollutisoli strain U1 chromosome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter pollutisoli
4492885	4492885	PRJNA683669_P_NODE_21944_length_277_cov_1.034314_g21712_i0	PRJNA683669	21944	277	1.034314	2.86504978	Pontibacter sp. G13	3074898	Bacteria	Bacteria	209	1.43e-49	NTclustered	gi\|2581342617\|gb\|CP134696.1\|	3074898	g21712	i0	81.783	226.346570397112	258	40	92	5	1	256	1134472	1134220	Pontibacter sp. G13 chromosome, complete genome	blastn	62698	209	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Pontibacter	Pontibacter sp. G13
10869036	10869036	PRJNA683669_P_NODE_389_length_1787_cov_2.287048_g333_i0	PRJNA683669	389	1787	2.287048	40.86954776	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	2717	0	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g333	i0	94.271	246.019026301063	1798	68	100	28	1	1787	2979400	2977627	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	439636	2717	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
13418932	13418932	PRJNA683669_P_NODE_22531_length_273_cov_1.220000_g22299_i0	PRJNA683669	22531	273	1.22	3.3306	Hymenobacter sp. NBH84	2596915	Bacteria	Bacteria	233	8.339999999999999e-57	NTclustered	gi\|1890948146\|gb\|CP043644.1\|	2596915	g22299	i0	82.246	5.003663003663	276	43	100	6	1	273	2314227	2313955	Hymenobacter sp. NBH84 chromosome, complete genome	blastn	1366	233	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. NBH84
13928888	13928888	PRJNA683669_P_NODE_2691_length_802_cov_1.160494_g2496_i0	PRJNA683669	2691	802	1.160494	9.30716188	Candidatus Amoebophilus	281119	Bacteria	Bacteria	1254	0	NTclustered	gi\|470483382\|ref\|NR_076589.1\|	281120	g2496	i0	94.888	409.381546134663	802	41	100	0	1	802	1525	724	Candidatus Amoebophilus asiaticus strain 5a2 23S ribosomal RNA gene, complete sequence	blastn	328324	1254	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Amoebophilaceae	Candidatus Amoebophilus	Candidatus Amoebophilus asiaticus
14693934	14693934	PRJNA683669_P_NODE_25192_length_256_cov_1.256831_g24960_i0	PRJNA683669	25192	256	1.256831	3.21748736	endosymbiont of Acanthamoeba sp. (Hungarian isolate)	115008	Bacteria	Bacteria	446	9.139999999999999e-121	NTclustered	gi\|7229460\|gb\|AF215634.1\|AF215634	115008	g24960	i0	98.419	96.73828125	253	4	99	0	4	256	273	21	Endosymbiont of Acanthamoeba sp. (Hungarian isolate) 16S ribosomal RNA gene, partial sequence	blastn	24765	446	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Amoebophilaceae	Candidatus Amoebophilus	endosymbiont of Acanthamoeba sp. (Hungarian isolate)
15967622	15967622	PRJNA683669_P_NODE_13393_length_354_cov_1.092527_g13162_i0	PRJNA683669	13393	354	1.092527	3.86754558	Cloacibacterium caeni	2004710	Bacteria	Bacteria	623	5.659999999999999e-174	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g13162	i0	99.417	284.83615819209	343	2	97	0	1	343	1872517	1872175	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	100832	623	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
18516977	18516977	PRJNA683669_P_NODE_15395_length_330_cov_2.038911_g15164_i0	PRJNA683669	15395	330	2.038911	6.7284063	Pedobacter sp. HDW13	2714940	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|1821195603\|gb\|CP049868.1\|	2714940	g15164	i0	100	0.0848484848484849	28	0	8	0	57	84	284389	284416	Pedobacter sp. HDW13 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. HDW13
19791964	19791964	PRJNA683669_P_NODE_31056_length_245_cov_0.895349_g30824_i0	PRJNA683669	31056	245	0.895349	2.19360505	Flavobacterium sp. M31R6	2739062	Bacteria	Bacteria	270	5.609999999999999e-68	NTclustered	gi\|1850342179\|gb\|CP054141.1\|	2739062	g30824	i0	86.831	10.6938775510204	243	30	99	2	2	243	3302321	3302080	Flavobacterium sp. M31R6 chromosome, complete genome	blastn	2620	270	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. M31R6
21067411	21067411	PRJNA683669_P_NODE_22137_length_276_cov_0.857143_g21905_i0	PRJNA683669	22137	276	0.857143	2.36571468	Hymenobacter oligotrophus	2319843	Bacteria	Bacteria	187	6.669999999999998e-43	NTclustered	gi\|1477488204\|gb\|CP032317.1\|	2319843	g21905	i0	79.468	2.72463768115942	263	54	95	0	10	272	3017449	3017187	Hymenobacter oligotrophus strain sh-6 chromosome, complete genome	blastn	752	187	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter oligotrophus
21067556	21067556	PRJNA683669_P_NODE_7677_length_462_cov_1.123393_g7446_i0	PRJNA683669	7677	462	1.123393	5.19007566	Cyclobacteriaceae bacterium	2099675	Bacteria	Bacteria	658	0	NTclustered	gi\|2556918996\|gb\|CP129487.1\|	2099675	g7446	i0	92.424	132.409090909091	462	33	99	2	2	462	2990299	2990759	MAG: Cyclobacteriaceae bacterium isolate cMAG.9 chromosome, complete genome	blastn	61173	658	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae		Cyclobacteriaceae bacterium

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