metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax

11 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax_phylum = "Chlorobiota"

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
24353956	24353956	PRJEB64798_P_NODE_217740_length_163_cov_0.912281_g215974_i0	PRJEB64798	217740	163	0.912281	1.48701803	Chlorobiota bacterium	2268192	Bacteria	Bacteria	97.4	6.94e-22	NR	NOX85989.1	2268192	g215974	i0	81.1	4.87730061349693	53	10	97.5	0	159	1	51	103	NOX85989.1 urocanate hydratase [Chlorobiota bacterium]	diamond	795	97.4	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
27374872	27374872	PRJEB64798_P_NODE_193783_length_169_cov_2.133333_g192017_i0	PRJEB64798	193783	169	2.133333	3.60533277	Pseudomonadati	3379134	Bacteria	Bacteria	81.3	3.11e-16	NR	WP_094082993.1	281093	g192017	i0	74	3.76331360946746	50	13	88.8	0	154	5	234	283	WP_094082993.1 TrbI/VirB10 family protein [Prosthecochloris sp. GSB1]	diamond	636	81.6	0.996323529411765	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Prosthecochloris	Prosthecochloris sp. GSB1
27406382	27406382	PRJEB64798_P_NODE_86883_length_212_cov_16.153374_g85117_i0	PRJEB64798	86883	212	16.153374	34.24515288	Bacteria	2	Bacteria	Bacteria	42.4	0.0127	NR	RFM22974.1	1868324	g85117	i0	73.1	2.92924528301887	26	7	36.8	0	79	2	1	26	RFM22974.1 MAG: 50S ribosomal protein L14 [Candidatus Thermochlorobacter aerophilum]	diamond	621	42.7	0.992974238875878	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Candidatus Thermochlorobacteriaceae	Candidatus Thermochlorobacter	Candidatus Thermochlorobacter aerophilus
28928465	28928465	PRJEB64798_P_NODE_121788_length_205_cov_5.237179_g120022_i0	PRJEB64798	121788	205	5.237179	10.73621695	Chlorobiota bacterium	2268192	Bacteria	Bacteria	42.4	0.0318	NR	MCI0449084.1	2268192	g120022	i0	33.8	0.951219512195122	65	43	95.1	0	5	199	634	698	MCI0449084.1 hypothetical protein [Chlorobiota bacterium]	diamond	195	42.4	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
29079633	29079633	PRJEB64798_P_NODE_220148_length_162_cov_2.442478_g218382_i0	PRJEB64798	220148	162	2.442478	3.95681436	Bacteria	2	Bacteria	Bacteria	98.6	1.53e-22	NR	MEI7789526.1	2067991	g218382	i0	88.5	8.64814814814815	52	6	96.3	0	2	157	162	213	MEI7789526.1 transposase [Chlorobiaceae bacterium]	diamond	1401	99.4	0.991951710261569	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae		Chlorobiaceae bacterium
29181400	29181400	PRJEB64798_P_NODE_243929_length_154_cov_2.314286_g242163_i0	PRJEB64798	243929	154	2.314286	3.56400044	Chlorobiota bacterium	2268192	Bacteria	Bacteria	61.6	1.88e-9	NR	NOZ45605.1	2268192	g242163	i0	54.2	0.935064935064935	48	21	91.6	1	148	8	208	255	NOZ45605.1 hypothetical protein [Chlorobiota bacterium]	diamond	144	61.6	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
30350309	30350309	PRJEB64798_P_NODE_241932_length_154_cov_7.257143_g240166_i0	PRJEB64798	241932	154	7.257143	11.17600022	Pelodictyon phaeoclathratiforme	34090	Bacteria	Bacteria	63.5	4.87e-10	NR	WP_012507431.1	34090	g240166	i0	67.3	0.954545454545455	49	15	93.5	1	149	6	2529	2577	WP_012507431.1 tetratricopeptide repeat protein [Pelodictyon phaeoclathratiforme]	diamond	147	63.5	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Pelodictyon	Pelodictyon phaeoclathratiforme
31265989	31265989	PRJEB64798_P_NODE_130215_length_198_cov_4.429530_g128449_i0	PRJEB64798	130215	198	4.42953	8.7704694	Chlorobiales bacterium	2723030	Bacteria	Bacteria	42.4	0.0284	NR	MCG8343262.1	2723030	g128449	i0	37.7	0.803030303030303	53	33	80.3	0	39	197	688	740	MCG8343262.1 beta-phosphoglucomutase family hydrolase [Chlorobiales bacterium]	diamond	159	42.4	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales			Chlorobiales bacterium
31392849	31392849	PRJEB64798_P_NODE_80436_length_214_cov_15.521212_g78670_i0	PRJEB64798	80436	214	15.521212	33.21539368	Chlorobiota bacterium	2268192	Bacteria	Bacteria	58.5	6.49e-8	NR	NOX45362.1	2268192	g78670	i0	80.6	0.434579439252336	31	6	43.5	0	12	104	403	433	NOX45362.1 ATP-binding protein [Chlorobiota bacterium]	diamond	93	58.5	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
32025305	32025305	PRJEB64798_P_NODE_230558_length_158_cov_8.009174_g228792_i0	PRJEB64798	230558	158	8.009174	12.65449492	Chlorobiota bacterium	2268192	Bacteria	Bacteria	54.3	1.38e-7	NR	NPA44811.1	2268192	g228792	i0	52.4	0.79746835443038	42	20	79.7	0	14	139	67	108	NPA44811.1 hypothetical protein [Chlorobiota bacterium]	diamond	126	54.3	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
32688851	32688851	PRJEB64798_P_NODE_117640_length_207_cov_14.563291_g115874_i0	PRJEB64798	117640	207	14.563291	30.14601237	Chlorobaculum parvum	274539	Bacteria	Bacteria	70.9	2.34e-12	NR	HHE32807.1	274539	g115874	i0	82.9	1.2463768115942	41	7	59.4	0	83	205	172	212	HHE32807.1 Fic family protein [Chlorobaculum parvum]	diamond	258	70.9	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobaculum	Chlorobaculum parvum

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