metadata: contig_metadata: 5 rows where bioproject = "PRJNA575566" and tax

5 rows where bioproject = "PRJNA575566" 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
22237111	22237111	PRJNA575566_P_NODE_21878_length_223_cov_0.876543_g21681_i0	PRJNA575566	21878	223	0.876543	1.95469089	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	340	3.77e-89	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g21681	i0	94.17	9.47085201793722	223	13	100	0	1	223	2190895	2190673	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	2112	340	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
23512437	23512437	PRJNA575566_P_NODE_23839_length_210_cov_1.718121_g23642_i0	PRJNA575566	23839	210	1.718121	3.6080541	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	261	2.81e-65	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g23642	i0	89.756	11.9714285714286	205	20	98	1	1	205	2191187	2191390	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	2514	261	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
28609016	28609016	PRJNA575566_P_NODE_7887_length_374_cov_1.191693_g7690_i0	PRJNA575566	7887	374	1.191693	4.45693182	Bacteria	2	Bacteria	Bacteria	105	1.69e-23	NR	MEI8213485.1	2026780	g7690	i0	49.6	2.00534759358289	121	57	96.3	2	374	15	132	249	MEI8213485.1 peroxidase family protein [Planctomycetota bacterium]	diamond	750	106	0.990566037735849	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29745415	29745415	PRJNA575566_P_NODE_28430_length_203_cov_0.901408_g28233_i0	PRJNA575566	28430	203	0.901408	1.82985824	Bacteria	2	Bacteria	Bacteria	43.5	0.0121	NR	WP_096894051.1	1284222	g28233	i0	52.8	6.65024630541872	36	17	53.2	0	96	203	1356	1391	WP_096894051.1 tetratricopeptide repeat protein [Candidatus Scalindua japonica]	diamond	1350	43.9	0.990888382687927	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Scalinduaceae	Candidatus Scalindua	Candidatus Scalindua japonica
30174255	30174255	PRJNA575566_P_NODE_1892_length_746_cov_2.769343_g1713_i0	PRJNA575566	1892	746	2.769343	20.65929878	Paludisphaera sp.	2017432	Bacteria	Bacteria	53.5	1.95e-4	NR	WP_337176277.1	2017432	g1713	i0	29.9	1.60053619302949	197	117	74	9	684	133	26	214	WP_337176277.1 hypothetical protein [Paludisphaera sp.]	diamond	1194	53.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera sp.

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