metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJEB48872" and tax

10 rows where analysis = "diamond", bioproject = "PRJEB48872" 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_species
21764241	21764241	PRJEB48872_P_NODE_627178_length_163_cov_0.991935_g611366_i0	PRJEB48872	627178	163	0.991935	1.61685405	Bacteria	2	Bacteria	Bacteria	87	3e-18	NR	MBP2648438.1	2026742	g611366	i0	86.8	12.680981595092	53	7	97.5	0	3	161	436	488	MBP2648438.1 hppA [Gemmatimonadota bacterium]	diamond	2067	87.4	0.995423340961098	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
28479664	28479664	PRJEB48872_P_NODE_613926_length_165_cov_2.047619_g598114_i0	PRJEB48872	613926	165	2.047619	3.37857135	Pseudomonadati	3379134	Bacteria	Bacteria	87	3.13e-18	NR	HMF88267.1	2026741	g598114	i0	69.8	7.43636363636364	53	16	96.4	0	6	164	250	302	HMF88267.1 PAS domain-containing protein [Gemmatimonadaceae bacterium]	diamond	1227	87	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae bacterium
29307150	29307150	PRJEB48872_P_NODE_674769_length_154_cov_1.417391_g658957_i0	PRJEB48872	674769	154	1.417391	2.18278214	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	85.5	2.16e-18	NR	MFS8637494.1	2026742	g658957	i0	78.4	12.8766233766234	51	11	99.4	0	153	1	78	128	MFS8637494.1 alpha/beta hydrolase [Gemmatimonadota bacterium]	diamond	1983	85.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
29489802	29489802	PRJEB48872_P_NODE_660970_length_156_cov_2.034188_g645158_i0	PRJEB48872	660970	156	2.034188	3.17333328	Pseudomonadati	3379134	Bacteria	Bacteria	82	1.52e-17	NR	HEV2752177.1	2448054	g645158	i0	75.5	6.07692307692308	53	12	100	1	1	156	66	118	HEV2752177.1 response regulator [Gemmatimonadales bacterium]	diamond	948	82	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales		Gemmatimonadales bacterium
29591006	29591006	PRJEB48872_P_NODE_692230_length_151_cov_1.214286_g676418_i0	PRJEB48872	692230	151	1.214286	1.83357186	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	44.7	0.00215	NR	HVH08349.1	2448054	g676418	i0	63.2	0.754966887417219	38	14	75.5	0	3	116	317	354	HVH08349.1 MASE1 domain-containing protein [Gemmatimonadales bacterium]	diamond	114	44.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales		Gemmatimonadales bacterium
29932261	29932261	PRJEB48872_P_NODE_632011_length_162_cov_1.138211_g616199_i0	PRJEB48872	632011	162	1.138211	1.84390182	Pseudomonadati	3379134	Bacteria	Bacteria	89	1.85e-20	NR	HEX7595213.1	2026741	g616199	i0	83.3	3.98148148148148	54	9	100	0	162	1	82	135	HEX7595213.1 plasmid mobilization relaxosome protein MobC [Gemmatimonadaceae bacterium]	diamond	645	89	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae bacterium
30500749	30500749	PRJEB48872_P_NODE_574973_length_174_cov_1.348148_g559161_i0	PRJEB48872	574973	174	1.348148	2.34577752	Pseudomonadati	3379134	Bacteria	Bacteria	50.8	1.96e-5	NR	HEX9248110.1	2026741	g559161	i0	51.1	3.43103448275862	47	23	81	0	33	173	30	76	HEX9248110.1 alpha/beta hydrolase [Gemmatimonadaceae bacterium]	diamond	597	51.2	0.9921875	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae bacterium
30823398	30823398	PRJEB48872_P_NODE_644214_length_159_cov_2.266667_g628402_i0	PRJEB48872	644214	159	2.266667	3.60400053	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	53.5	1.86e-6	NR	MDP9178993.1	2026742	g628402	i0	45.1	0.962264150943396	51	28	96.2	0	156	4	75	125	MDP9178993.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	153	53.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
32025027	32025027	PRJEB48872_P_NODE_642398_length_160_cov_1.140496_g626586_i0	PRJEB48872	642398	160	1.140496	1.8247936	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	55.8	2.66e-7	NR	MEO7102188.1	2026741	g626586	i0	53.8	0.975	52	21	97.5	1	158	3	56	104	MEO7102188.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	156	55.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae bacterium
32688682	32688682	PRJEB48872_P_NODE_346160_length_257_cov_6.362385_g330348_i0	PRJEB48872	346160	257	6.362385	16.35132945	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	42.7	0.0421	NR	MBI4420926.1	2026742	g330348	i0	37.1	0.723735408560311	62	39	72.4	0	227	42	255	316	MBI4420926.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	186	42.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota 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);;