metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA976345" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA976345" 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
4776099	4776099	PRJNA976345_P_NODE_13324_length_468_cov_2.635104_g11752_i0	PRJNA976345	13324	468	2.635104	12.33228672	Aquisphaera giovannonii	406548	Bacteria	Bacteria	217	1.52e-51	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g11752	i0	83.193	0.508547008547009	238	38	51	2	231	467	9202614	9202378	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	238	217	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
9876103	9876103	PRJNA976345_P_NODE_155448_length_164_cov_1.674419_g153840_i0	PRJNA976345	155448	164	1.674419	2.74604716	Gemmataceae bacterium	2052164	Bacteria	Bacteria	248	1.63e-61	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g153840	i0	93.902	1	164	10	100	0	1	164	1005132	1004969	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	164	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
12426919	12426919	PRJNA976345_P_NODE_121270_length_178_cov_2.426573_g119662_i0	PRJNA976345	121270	178	2.426573	4.31929994	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|1938775668\|gb\|CP054178.1\|	2026777	g119662	i0	100	0.162921348314607	29	0	16	0	150	178	3200882	3200854	MAG: Phycisphaeraceae bacterium isolate H1_PLA4 chromosome, complete genome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
17526042	17526042	PRJNA976345_P_NODE_158594_length_163_cov_1.250000_g156986_i0	PRJNA976345	158594	163	1.25	2.0375	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	65.8	1.75e-6	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g156986	i0	97.368	0.730061349693252	38	1	23	0	23	60	6442187	6442150	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	119	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
18799387	18799387	PRJNA976345_P_NODE_105115_length_186_cov_2.443709_g103507_i0	PRJNA976345	105115	186	2.443709	4.54529874	Bremerella sp. TYQ1	3119568	Bacteria	Bacteria	87.9	4.36e-13	NTclustered	gi\|2101355205\|gb\|CP083740.1\|	3119568	g103507	i0	84.884	0.462365591397849	86	13	46	0	1	86	6520934	6521019	Bremerella sp. TYQ1 chromosome, complete genome	blastn	86	87.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella sp. TYQ1

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