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

5 rows where analysis = "blastn", bioproject = "PRJNA685607" 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
1942442	1942442	PRJNA685607_P_NODE_81802_length_245_cov_1.790698_g81443_i0	PRJNA685607	81802	245	1.790698	4.3872101	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	278	3.35e-70	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g81443	i0	87.149	862.938775510204	249	26	100	6	1	245	1829872	1830118	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	211420	278	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
7045154	7045154	PRJNA685607_P_NODE_87706_length_244_cov_0.900585_g87347_i0	PRJNA685607	87706	244	0.900585	2.1974274	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	350	6.969999999999998e-92	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g87347	i0	92.4	458.418032786885	250	12	99	3	2	244	4959831	4959582	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	111854	350	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
12145600	12145600	PRJNA685607_P_NODE_28390_length_336_cov_0.958175_g28031_i0	PRJNA685607	28390	336	0.958175	3.219468	Stratiformator vulcanicus	2527980	Bacteria	Bacteria	361	4.64e-95	NTclustered	gi\|1712491480\|gb\|CP036268.1\|	2527980	g28031	i0	86.095	78.7172619047619	338	43	100	4	1	336	3082226	3081891	Stratiformator vulcanicus strain Pan189 chromosome	blastn	26449	361	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Stratiformator	Stratiformator vulcanicus
14695323	14695323	PRJNA685607_P_NODE_58172_length_263_cov_0.810526_g57813_i0	PRJNA685607	58172	263	0.810526	2.13168338	Ereboglobus luteus	1796921	Bacteria	Bacteria	250	7.93e-62	NTclustered	gi\|1387286769\|gb\|CP023004.1\|	1796921	g57813	i0	83.908	55.254752851711	261	42	99	0	3	263	241368	241628	Ereboglobus luteus strain Ho45, complete genome	blastn	14532	250	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Ereboglobus	Ereboglobus luteus
17244301	17244301	PRJNA685607_P_NODE_52734_length_273_cov_1.155000_g52375_i0	PRJNA685607	52734	273	1.155	3.15315	Fuerstiella marisgermanici	1891926	Bacteria	Bacteria	243	1.39e-59	NTclustered	gi\|1140105870\|gb\|CP017641.1\|	1891926	g52375	i0	83.212	398.175824175824	274	37	99	5	1	272	5362366	5362632	Fuerstiella marisgermanici strain NH11 chromosome, complete genome	blastn	108702	243	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici

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