metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJDB9741" and tax

15 rows where analysis = "diamond", bioproject = "PRJDB9741" and tax_phylum = "Planctomycetota"

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
22658748	22658748	PRJDB9741_P_NODE_10738_length_201_cov_1.914474_g10421_i0	PRJDB9741	10738	201	1.914474	3.84809274	Planctomycetota bacterium	2026780	Bacteria	Bacteria	109	4.59e-26	NR	MEY4831052.1	2026780	g10421	i0	88.9	8.17910447761194	54	6	80.6	0	200	39	385	438	MEY4831052.1 adenosylhomocysteinase [Planctomycetota bacterium]	diamond	1644	109	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
26773409	26773409	PRJDB9741_P_NODE_26181_length_168_cov_2.252101_g25864_i0	PRJDB9741	26181	168	2.252101	3.78352968	Planctomycetia	203683	Bacteria	Bacteria	97.8	5.5200000000000005e-22	NR	WP_074308323.1	1882752	g25864	i0	78.6	3	56	12	100	0	1	168	553	608	WP_074308323.1 hypothetical protein [Singulisphaera sp. GP187]	diamond	504	97.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. GP187
28390565	28390565	PRJDB9741_P_NODE_38426_length_162_cov_0.902655_g38109_i0	PRJDB9741	38426	162	0.902655	1.4623011	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	41.6	0.0328	NR	MEO2037068.1	2026779	g38109	i0	38.9	1	54	32	100	1	1	162	255	307	MEO2037068.1 Gfo/Idh/MocA family oxidoreductase [Planctomycetaceae bacterium]	diamond	162	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28542722	28542722	PRJDB9741_P_NODE_43307_length_151_cov_3.000000_g42990_i0	PRJDB9741	43307	151	3	4.53	Bacteria	2	Bacteria	Bacteria	73.6	1.38e-13	NR	MEO2089858.1	2052164	g42990	i0	83.7	12.6556291390728	49	8	97.4	0	149	3	321	369	MEO2089858.1 methyl-accepting chemotaxis protein [Gemmataceae bacterium]	diamond	1911	74.3	0.990578734858681	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
28895636	28895636	PRJDB9741_P_NODE_40628_length_161_cov_0.910714_g40311_i0	PRJDB9741	40628	161	0.910714	1.46624954	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	103	4.579999999999999e-24	NR	MFT3788388.1	2876886	g40311	i0	90.6	0.987577639751553	53	5	98.8	0	161	3	119	171	MFT3788388.1 polyribonucleotide nucleotidyltransferase [Tepidisphaeraceae bacterium]	diamond	159	103	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
28927319	28927319	PRJDB9741_P_NODE_16328_length_184_cov_1.637037_g16011_i0	PRJDB9741	16328	184	1.637037	3.01214808	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	62.8	3.59e-10	NR	MCG3178245.1	2026778	g16011	i0	58.2	0.896739130434783	55	23	89.7	0	166	2	32	86	MCG3178245.1 hypothetical protein [Phycisphaerae bacterium]	diamond	165	62.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
29180127	29180127	PRJDB9741_P_NODE_19149_length_179_cov_2.007692_g18832_i0	PRJDB9741	19149	179	2.007692	3.59376868	Limnoglobus roseus	2598579	Bacteria	Bacteria	41.6	0.0418	NR	WP_168218902.1	2598579	g18832	i0	50	0.70391061452514	42	18	70.4	1	134	9	1111	1149	WP_168218902.1 FG-GAP-like repeat-containing protein [Limnoglobus roseus]	diamond	126	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
29211680	29211680	PRJDB9741_P_NODE_19169_length_179_cov_1.938462_g18852_i0	PRJDB9741	19169	179	1.938462	3.46984698	Gemmataceae bacterium	2052164	Bacteria	Bacteria	100	9.76e-23	NR	MFO0938084.1	2052164	g18852	i0	93.2	0.988826815642458	59	4	98.9	0	3	179	523	581	MFO0938084.1 hypothetical protein [Gemmataceae bacterium]	diamond	177	100	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
29274497	29274497	PRJDB9741_P_NODE_37429_length_162_cov_1.345133_g37112_i0	PRJDB9741	37429	162	1.345133	2.17911546	Rubripirellula sp.	1973111	Bacteria	Bacteria	58.2	4.4e-8	NR	MDE0862338.1	1973111	g37112	i0	60.9	0.851851851851852	46	17	83.3	1	137	3	407	452	MDE0862338.1 sulfatase [Rubripirellula sp.]	diamond	138	58.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rubripirellula	Rubripirellula sp.
29527313	29527313	PRJDB9741_P_NODE_31630_length_165_cov_0.879310_g31313_i0	PRJDB9741	31630	165	0.87931	1.4508615	Pirellulales bacterium	2715253	Bacteria	Bacteria	98.2	1.98e-22	NR	MFO0897753.1	2715253	g31313	i0	85.2	0.981818181818182	54	8	98.2	0	164	3	359	412	MFO0897753.1 Ig-like domain-containing protein [Pirellulales bacterium]	diamond	162	98.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
29779821	29779821	PRJDB9741_P_NODE_14431_length_188_cov_1.100719_g14114_i0	PRJDB9741	14431	188	1.100719	2.06935172	Planctomycetota bacterium	2026780	Bacteria	Bacteria	110	1.23e-26	NR	MEQ1894885.1	2026780	g14114	i0	82.3	1.97872340425532	62	11	98.9	0	186	1	383	444	MEQ1894885.1 hypothetical protein [Planctomycetota bacterium]	diamond	372	110	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30001093	30001093	PRJDB9741_P_NODE_28031_length_167_cov_0.864407_g27714_i0	PRJDB9741	28031	167	0.864407	1.44355969	Limnoglobus roseus	2598579	Bacteria	Bacteria	55.1	5.83e-7	NR	WP_149112082.1	2598579	g27714	i0	89.7	1.05988023952096	29	3	52.1	0	2	88	381	409	WP_149112082.1 TIGR00300 family protein [Limnoglobus roseus]	diamond	177	55.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
30317425	30317425	PRJDB9741_P_NODE_31592_length_165_cov_0.879310_g31275_i0	PRJDB9741	31592	165	0.87931	1.4508615	Pirellulales bacterium	2715253	Bacteria	Bacteria	57.4	8.55e-8	NR	HEY1064852.1	2715253	g31275	i0	53.7	0.981818181818182	54	25	98.2	0	164	3	221	274	HEY1064852.1 DUF4974 domain-containing protein [Pirellulales bacterium]	diamond	162	57.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
32150629	32150629	PRJDB9741_P_NODE_30618_length_166_cov_0.871795_g30301_i0	PRJDB9741	30618	166	0.871795	1.4471797	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	42.4	0.0178	NR	MBN2210937.1	2813034	g30301	i0	47.4	2.58433734939759	38	20	68.7	0	116	3	625	662	MBN2210937.1 hypothetical protein [Sedimentisphaerales bacterium]	diamond	429	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
32467229	32467229	PRJDB9741_P_NODE_26179_length_168_cov_2.252101_g25862_i0	PRJDB9741	26179	168	2.252101	3.78352968	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	50.8	1.86e-5	NR	MDR0336275.1	2026779	g25862	i0	46.3	5.875	54	26	91.1	1	2	154	236	289	MDR0336275.1 family 78 glycoside hydrolase catalytic domain [Planctomycetaceae bacterium]	diamond	987	50.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae 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);;