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

5 rows where analysis = "blastn", bioproject = "PRJNA886442" 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
862070	862070	PRJNA886442_P_NODE_9181_length_266_cov_1.616580_g9017_i0	PRJNA886442	9181	266	1.61658	4.3001028	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	377	3.53e-100	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g9017	i0	94.332	110.582706766917	247	12	92	2	11	255	1154990	1155236	Planctomyces sp. SH-PL62, complete genome	blastn	29415	377	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
17818956	17818956	PRJNA886442_P_NODE_10914_length_252_cov_0.871508_g10750_i0	PRJNA886442	10914	252	0.871508	2.19620016	Planctomycetia	203683	Bacteria	Bacteria	305	1.59e-78	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g10750	i0	91.818	193.384920634921	220	16	87	2	34	252	2623267	2623049	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	48733	305	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
17819019	17819019	PRJNA886442_P_NODE_4174_length_362_cov_2.930796_g4010_i0	PRJNA886442	4174	362	2.930796	10.60948152	Planctomycetia	203683	Bacteria	Bacteria	603	7.559999999999999e-168	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g4010	i0	96.694	309.229281767956	363	10	100	2	1	362	122641	122280	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	111941	603	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
18713348	18713348	PRJNA886442_P_NODE_5675_length_323_cov_1.248000_g5511_i0	PRJNA886442	5675	323	1.248	4.03104	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	414	3.36e-111	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g5511	i0	93.238	125.074303405573	281	19	87	0	43	323	7052359	7052639	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	40399	414	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
21263869	21263869	PRJNA886442_P_NODE_1617_length_545_cov_1.889831_g1454_i0	PRJNA886442	1617	545	1.889831	10.29957895	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	784	0	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g1454	i0	92.687	120.133944954128	547	35	100	5	1	545	1155190	1155733	Planctomyces sp. SH-PL62, complete genome	blastn	65473	784	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62

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