metadata: contig_metadata: 4 rows where bioproject = "PRJEB25583" and tax

4 rows where bioproject = "PRJEB25583" 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
5125396	5125396	PRJEB25583_P_NODE_4705_length_189_cov_1.309211_g4528_i0	PRJEB25583	4705	189	1.309211	2.47440879	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	294	2.44e-75	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g4528	i0	94.709	164.486772486772	189	10	100	0	1	189	2502446	2502634	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	31088	294	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
10225773	10225773	PRJEB25583_P_NODE_7629_length_155_cov_1.669492_g7452_i0	PRJEB25583	7629	155	1.669492	2.5877126	Poriferisphaera corsica	2528020	Bacteria	Bacteria	165	1.57e-36	NTclustered	gi\|1712598971\|gb\|CP036425.1\|	2528020	g7452	i0	90.476	38.7612903225806	126	10	81	2	2	126	3163771	3163895	Poriferisphaera corsica strain KS4 chromosome, complete genome	blastn	6008	165	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Poriferisphaera	Poriferisphaera corsica
11189793	11189793	PRJEB25583_P_NODE_7389_length_157_cov_1.291667_g7212_i0	PRJEB25583	7389	157	1.291667	2.02791719	Isosphaera	127	Bacteria	Bacteria	163	5.74e-36	NTclustered	gi\|470487262\|ref\|NR_076810.1\|	128	g7212	i0	85.987	13.6687898089172	157	17	100	4	1	157	1242	1091	Isosphaera pallida strain IS1B 23S ribosomal RNA gene, complete sequence	blastn	2146	163	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera pallida
28321591	28321591	PRJEB25583_P_NODE_6266_length_167_cov_1.184615_g6089_i0	PRJEB25583	6266	167	1.184615	1.97830705	PVC group	1783257	Bacteria	Bacteria	95.9	1.66e-22	NR	NHZ84895.1	2052181	g6089	i0	72.2	2.89221556886228	54	15	97	0	166	5	103	156	NHZ84895.1 RNase H superfamily protein [Planctomycetia bacterium]	diamond	483	95.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia 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);;