metadata: contig_metadata: 10 rows where bioproject = "PRJNA807347", tax_clade = "FCB group" and tax

10 rows where bioproject = "PRJNA807347", 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
806266	806266	PRJNA807347_P_NODE_12141_length_252_cov_0.865922_g12038_i0	PRJNA807347	12141	252	0.865922	2.18212344	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	163	1.0099999999999999e-46	NR	WP_367886304.1	3062599	g12038	i0	95.2	0.988095238095238	83	4	98.8	0	250	2	173	255	WP_367886304.1 aminotransferase class V-fold PLP-dependent enzyme [Pseudogemmatithrix spongiicola]	diamond	249	163	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
3357263	3357263	PRJNA807347_P_NODE_8023_length_290_cov_1.133641_g7920_i0	PRJNA807347	8023	290	1.133641	3.2875589	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	318	2.3999999999999995e-82	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g7920	i0	87.823	59.5551724137931	271	33	93	0	20	290	1093030	1093300	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	17271	318	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
4634693	4634693	PRJNA807347_P_NODE_11964_length_252_cov_0.871508_g11861_i0	PRJNA807347	11964	252	0.871508	2.19620016	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	377	3.32e-100	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g11861	i0	93.651	4.17063492063492	252	16	100	0	1	252	2216631	2216380	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	1051	377	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
11010108	11010108	PRJNA807347_P_NODE_11509_length_254_cov_1.292818_g11406_i0	PRJNA807347	11509	254	1.292818	3.28375772	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	241	4.59e-59	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g11406	i0	85	1.88976377952756	240	32	94	3	1	238	1576484	1576721	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	480	241	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
14834569	14834569	PRJNA807347_P_NODE_8912_length_279_cov_1.514563_g8809_i0	PRJNA807347	8912	279	1.514563	4.22563077	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	394	3.709999999999999e-105	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g8809	i0	92.115	168.136200716846	279	22	100	0	1	279	1553665	1553943	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	46910	394	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
16108726	16108726	PRJNA807347_P_NODE_15293_length_245_cov_0.906977_g15190_i0	PRJNA807347	15293	245	0.906977	2.22209365	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	122	2.4399999999999998e-32	NR	HRN52352.1	2026741	g15190	i0	73.4	0.96734693877551	79	21	96.7	0	8	244	17	95	HRN52352.1 matrixin family metalloprotease [Gemmatimonadaceae bacterium]	diamond	237	122	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
25032695	25032695	PRJNA807347_P_NODE_10440_length_263_cov_3.689474_g10337_i0	PRJNA807347	10440	263	3.689474	9.70331662	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	381	2.7e-101	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g10337	i0	92.857	129.570342205323	266	13	100	6	1	263	3042912	3043174	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	34077	381	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
27085855	27085855	PRJNA807347_P_NODE_17622_length_232_cov_2.433962_g17519_i0	PRJNA807347	17622	232	2.433962	5.64679184	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	72.4	1.86e-14	NR	WP_367885580.1	3062599	g17519	i0	85	0.517241379310345	40	6	51.7	0	96	215	1	40	WP_367885580.1 molybdopterin dinucleotide binding domain-containing protein [Pseudogemmatithrix spongiicola]	diamond	120	72.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
28222575	28222575	PRJNA807347_P_NODE_13106_length_250_cov_0.870056_g13003_i0	PRJNA807347	13106	250	0.870056	2.17514	Gemmatimonas sp.	1962908	Bacteria	Bacteria	106	9.74e-25	NR	MBA3854235.1	1962908	g13003	i0	82.4	0.816	68	12	81.6	0	247	44	39	106	MBA3854235.1 D-alanyl-D-alanine carboxypeptidase/D-alanyl-D-alanine-endopeptidase [Gemmatimonas sp.]	diamond	204	106	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp.
30875648	30875648	PRJNA807347_P_NODE_14074_length_248_cov_0.880000_g13971_i0	PRJNA807347	14074	248	0.88	2.1824	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	145	3.4099999999999998e-40	NR	WP_367886895.1	3062599	g13971	i0	90.1	2.96370967741935	81	8	98	0	244	2	170	250	WP_367886895.1 hypothetical protein [Pseudogemmatithrix spongiicola]	diamond	735	145	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola

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