metadata: contig_metadata: 14 rows where bioproject = "PRJEB83101", tax_clade = "FCB group" and tax

14 rows where bioproject = "PRJEB83101", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"

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
6520891	6520891	PRJEB83101_P_NODE_69926_length_250_cov_1.734463_g69621_i0	PRJEB83101	69926	250	1.734463	4.3361575	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	268	2.07e-67	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g69621	i0	86	33.592	250	35	100	0	1	250	2695849	2696098	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	8398	268	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
16719681	16719681	PRJEB83101_P_NODE_80854_length_245_cov_0.906977_g80549_i0	PRJEB83101	80854	245	0.906977	2.22209365	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	222	1.59e-53	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g80549	i0	86.634	2.65714285714286	202	25	82	2	44	244	2609947	2610147	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	651	222	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
17994392	17994392	PRJEB83101_P_NODE_75495_length_247_cov_2.034483_g75190_i0	PRJEB83101	75495	247	2.034483	5.02517301	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	130	1.31e-33	NR	HET9065857.1	2448054	g75190	i0	79.5	10.5789473684211	78	16	94.7	0	246	13	344	421	HET9065857.1 NADH-quinone oxidoreductase subunit M [Gemmatimonadales bacterium]	diamond	2613	130	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
20543535	20543535	PRJEB83101_P_NODE_64797_length_253_cov_1.461111_g64492_i0	PRJEB83101	64797	253	1.461111	3.69661083	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	170	1.2299999999999999e-47	NR	HEX5580654.1	2026741	g64492	i0	97.6	0.99604743083004	84	2	99.6	0	252	1	484	567	HEX5580654.1 elongation factor G [Gemmatimonadaceae bacterium]	diamond	252	170	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
21819070	21819070	PRJEB83101_P_NODE_57238_length_264_cov_1.633508_g56933_i0	PRJEB83101	57238	264	1.633508	4.31246112	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	193	1.36e-44	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g56933	i0	87.425	1.51893939393939	167	21	63	0	1	167	2686135	2686301	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	401	193	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
23950344	23950344	PRJEB83101_P_NODE_46879_length_281_cov_2.908654_g46574_i0	PRJEB83101	46879	281	2.908654	8.17331774	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	108	2.29e-25	NR	WP_025413934.1	861299	g46574	i0	61.8	0.950177935943061	89	34	95	0	2	268	268	356	WP_025413934.1 universal stress protein [Gemmatirosa kalamazoonensis]	diamond	267	108	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
26590852	26590852	PRJEB83101_P_NODE_60061_length_260_cov_1.368984_g59756_i0	PRJEB83101	60061	260	1.368984	3.5593584	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	61.6	8.35e-9	NR	HEV7993425.1	2026741	g59756	i0	54.5	1.54615384615385	66	28	73.8	1	24	215	15	80	HEV7993425.1 sulfurtransferase [Gemmatimonadaceae bacterium]	diamond	402	61.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
27065841	27065841	PRJEB83101_P_NODE_65622_length_253_cov_0.866667_g65317_i0	PRJEB83101	65622	253	0.866667	2.19266751	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	145	7.68e-39	NR	HSJ13691.1	2910168	g65317	i0	90.2	0.972332015810277	82	8	97.2	0	251	6	68	149	HSJ13691.1 L-aspartate oxidase [Longimicrobiales bacterium]	diamond	246	145	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
27223772	27223772	PRJEB83101_P_NODE_50143_length_276_cov_1.241379_g49838_i0	PRJEB83101	50143	276	1.241379	3.42620604	Longimicrobium sp.	2029185	Bacteria	Bacteria	114	5.959999999999999e-31	NR	HYW12003.1	2029185	g49838	i0	86.4	0.641304347826087	59	8	64.1	0	218	42	11	69	HYW12003.1 pinensin family lanthipeptide [Longimicrobium sp.]	diamond	177	114	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
27539982	27539982	PRJEB83101_P_NODE_89044_length_233_cov_2.368750_g88739_i0	PRJEB83101	89044	233	2.36875	5.5191875	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	74.7	1.69e-13	NR	HEU4682383.1	2448054	g88739	i0	54.4	1.75107296137339	68	30	86.3	1	232	32	50	117	HEU4682383.1 tetratricopeptide repeat protein [Gemmatimonadales bacterium]	diamond	408	74.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
27981969	27981969	PRJEB83101_P_NODE_66605_length_252_cov_1.424581_g66300_i0	PRJEB83101	66605	252	1.424581	3.58994412	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	90.9	3.33e-21	NR	HWA58645.1	2448054	g66300	i0	55.7	4.73809523809524	79	35	94	0	3	239	15	93	HWA58645.1 VOC family protein [Gemmatimonadales bacterium]	diamond	1194	90.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29560436	29560436	PRJEB83101_P_NODE_47510_length_280_cov_2.072464_g47205_i0	PRJEB83101	47510	280	2.072464	5.8028992	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	82.4	9.29e-18	NR	HEX6630955.1	2026741	g47205	i0	65.1	0.675	63	20	67.5	1	78	266	11	71	HEX6630955.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	189	82.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31108425	31108425	PRJEB83101_P_NODE_84235_length_243_cov_0.917647_g83930_i0	PRJEB83101	84235	243	0.917647	2.22988221	Longimicrobium sp.	2029185	Bacteria	Bacteria	164	1.19e-46	NR	WP_331127699.1	2029185	g83930	i0	98.8	4.9382716049382704	80	1	98.8	0	2	241	183	262	WP_331127699.1 1-acyl-sn-glycerol-3-phosphate acyltransferase [Longimicrobium sp.]	diamond	1200	164	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
32025841	32025841	PRJEB83101_P_NODE_40678_length_293_cov_2.272727_g40373_i0	PRJEB83101	40678	293	2.272727	6.65909011	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	71.6	4.69e-12	NR	HEX5004499.1	2448054	g40373	i0	70.8	1.51535836177474	48	14	49.1	0	4	147	120	167	HEX5004499.1 Ig-like domain-containing protein [Gemmatimonadales bacterium]	diamond	444	71.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales 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);;