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

5 rows where analysis = "blastn", bioproject = "PRJNA195897" 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
4193077	4193077	PRJNA195897_P_NODE_4404_length_228_cov_1.162011_g4371_i0	PRJNA195897	4404	228	1.162011	2.64938508	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	152	1.9499999999999998e-32	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g4371	i0	81.967	102.780701754386	183	29	79	4	48	228	3991166	3991346	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	23434	152	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
10570075	10570075	PRJNA195897_P_NODE_5869_length_202_cov_0.941176_g5836_i0	PRJNA195897	5869	202	0.941176	1.90117552	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	331	2.02e-86	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g5836	i0	97.906	27.2574257425743	191	4	95	0	12	202	2558392	2558582	Lacunisphaera limnophila strain IG16b, complete genome	blastn	5506	331	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
15082849	15082849	PRJNA195897_P_NODE_9232_length_169_cov_0.866667_g9199_i0	PRJNA195897	9232	169	0.866667	1.46466723	Engelhardtia	139931	Bacteria	Bacteria	115	1.7700000000000003e-21	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g9199	i0	84.167	23.0295857988166	120	18	70	1	50	168	5246198	5246317	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	3892	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
15668739	15668739	PRJNA195897_P_NODE_11573_length_164_cov_0.904348_g11540_i0	PRJNA195897	11573	164	0.904348	1.48313072	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	270	3.4699999999999992e-68	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g11540	i0	96.341	92.2560975609756	164	6	100	0	1	164	3556305	3556142	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	15130	270	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
15668800	15668800	PRJNA195897_P_NODE_5253_length_211_cov_1.283951_g5220_i0	PRJNA195897	5253	211	1.283951	2.70913661	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	154	4.94e-33	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g5220	i0	91.228	3.03791469194313	114	9	54	1	1	113	2582894	2583007	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	641	154	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae 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);;