metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA565778" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA565778" 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
1833779	1833779	PRJNA565778_S_NODE_33322_length_189_cov_5.421053_g33026_i0	PRJNA565778	33322	189	5.421053	10.24579017	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	67.6	5.79e-7	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g33026	i0	97.436	0.206349206349206	39	1	21	0	118	156	3833289	3833327	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	39	67.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
1833979	1833979	PRJNA565778_S_NODE_9882_length_345_cov_44.100649_g9586_i0	PRJNA565778	9882	345	44.100649	152.14723905	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	573	5.629999999999999e-159	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g9586	i0	100	0.898550724637681	310	0	90	0	36	345	1597045	1596736	Parachlamydia acanthamoebae UV-7, complete genome	blastn	310	573	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
4385605	4385605	PRJNA565778_S_NODE_15564_length_280_cov_4.777778_g15268_i0	PRJNA565778	15564	280	4.777778	13.3777784	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	195	4.05e-45	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g15268	i0	95.122	40.2142857142857	123	6	44	0	33	155	4040193	4040315	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	11260	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
6239403	6239403	PRJNA565778_S_NODE_4045_length_506_cov_7.268657_g3831_i0	PRJNA565778	4045	506	7.268657	36.77940442	Luteolibacter	518753	Bacteria	Bacteria	455	3.2300000000000004e-123	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g3831	i0	84.829	155.065217391304	468	54	91	14	26	486	276278	276735	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	78463	457	0.99562363238512	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
9486574	9486574	PRJNA565778_S_NODE_21128_length_240_cov_636.866995_g20832_i0	PRJNA565778	21128	240	636.866995	1528.480788	Pirellulales bacterium	2715253	Bacteria	Bacteria	193	1.22e-44	NTclustered	gi\|2874253964\|emb\|OY970289.1\|	2715253	g20832	i0	83.981	6.55416666666667	206	28	85	4	2	204	313048	312845	MAG: Pirellulales bacterium isolate MFD05442.bin.c.2 genome assembly, chromosome: 1	blastn	1573	193	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
14586938	14586938	PRJNA565778_S_NODE_16192_length_274_cov_388.755274_g15896_i0	PRJNA565778	16192	274	388.755274	1065.18945076	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	285	2.28e-72	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g15896	i0	90.654	324.667883211679	214	20	78	0	22	235	4958815	4958602	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	88959	285	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
19684965	19684965	PRJNA565778_S_NODE_6796_length_408_cov_2.908356_g6522_i0	PRJNA565778	6796	408	2.908356	11.86609248	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	702	0	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g6522	i0	100	0.931372549019608	380	0	93	0	1	380	1910955	1910576	Parachlamydia acanthamoebae UV-7, complete genome	blastn	380	702	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
23510527	23510527	PRJNA565778_S_NODE_16299_length_274_cov_2.303797_g16003_i0	PRJNA565778	16299	274	2.303797	6.31240378	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	496	9.67e-136	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g16003	i0	99.27	1	274	2	100	0	1	274	2776375	2776102	Parachlamydia acanthamoebae UV-7, complete genome	blastn	274	496	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
23510917	23510917	PRJNA565778_S_NODE_9039_length_359_cov_178.478261_g8743_i0	PRJNA565778	9039	359	178.478261	640.73695699	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	582	9.75e-162	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g8743	i0	99.074	0.902506963788301	324	3	90	0	36	359	2775805	2776128	Parachlamydia acanthamoebae UV-7, complete genome	blastn	324	582	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae

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