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

5 rows where bioproject = "PRJNA559720" and tax_clade = "PVC group"

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
13884209	13884209	PRJNA559720_P_NODE_11351_length_284_cov_1.075829_g11212_i0	PRJNA559720	11351	284	1.075829	3.05535436	Schlesneria	656899	Bacteria	Bacteria	525	1.2899999999999994e-144	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g11212	i0	100	181.87323943662	284	0	100	0	1	284	2534	2817	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	51652	525	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
28910273	28910273	PRJNA559720_P_NODE_16168_length_242_cov_0.911243_g16029_i0	PRJNA559720	16168	242	0.911243	2.20520806	Waddlia chondrophila	71667	Bacteria	Bacteria	42.4	0.0488	NR	WP_013182342.1	71667	g16029	i0	65.4	0.322314049586777	26	5	27.3	1	230	165	131	156	WP_013182342.1 MFS transporter [Waddlia chondrophila]	diamond	78	42.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
29384301	29384301	PRJNA559720_P_NODE_8589_length_340_cov_1.101124_g8450_i0	PRJNA559720	8589	340	1.101124	3.7438216	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	43.9	0.0403	NR	MFL6529243.1	2201154	g8450	i0	36.6	0.361764705882353	41	26	36.2	0	87	209	196	236	MFL6529243.1 chromate efflux transporter [Chthoniobacterales bacterium]	diamond	123	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
30047176	30047176	PRJNA559720_P_NODE_15371_length_244_cov_2.187135_g15232_i0	PRJNA559720	15371	244	2.187135	5.3366094	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	63.9	1.3e-9	NR	MBN1342782.1	2026778	g15232	i0	54	1.27868852459016	50	23	61.5	0	243	94	746	795	MBN1342782.1 PAS domain S-box protein [Phycisphaerae bacterium]	diamond	312	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
31627508	31627508	PRJNA559720_P_NODE_13416_length_252_cov_1.206704_g13277_i0	PRJNA559720	13416	252	1.206704	3.04089408	Puniceicoccales bacterium	2478473	Bacteria	Bacteria	45.1	0.006	NR	MDR0418280.1	2478473	g13277	i0	46	0.595238095238095	50	26	58.3	1	36	182	287	336	MDR0418280.1 tRNA 2-thiouridine(34) synthase MnmA [Puniceicoccales bacterium]	diamond	150	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales			Puniceicoccales 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);;