metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA1180292" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA1180292" 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
1041216	1041216	PRJNA1180292_P_NODE_11421_length_245_cov_0.906977_g11289_i0	PRJNA1180292	11421	245	0.906977	2.22209365	Pseudomonadati	3379134	Bacteria	Bacteria	104	6.02e-18	NTclustered	gi\|1927961636\|gb\|CP054187.1\|	2052181	g11289	i0	81.89	26.269387755102	127	19	51	3	119	243	2184328	2184204	MAG: Planctomycetia bacterium isolate H1_PLA2 chromosome, complete genome	blastn	6436	104	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
1592513	1592513	PRJNA1180292_P_NODE_13082_length_242_cov_0.923077_g12950_i0	PRJNA1180292	13082	242	0.923077	2.23384634	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	128	3.52e-25	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g12950	i0	91.398	1.02892561983471	93	8	38	0	150	242	2297745	2297653	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	249	128	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
4144744	4144744	PRJNA1180292_P_NODE_11804_length_245_cov_0.906977_g11672_i0	PRJNA1180292	11804	245	0.906977	2.22209365	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	174	4.52e-39	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g11672	i0	79.921	3.44897959183673	254	38	99	7	1	243	668947	668696	Luteolibacter sp. SL250 chromosome	blastn	845	174	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
7971102	7971102	PRJNA1180292_P_NODE_13027_length_242_cov_0.923077_g12895_i0	PRJNA1180292	13027	242	0.923077	2.23384634	Opitutus terrae	107709	Bacteria	Bacteria	180	9.58e-41	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g12895	i0	85.799	1.37603305785124	169	24	70	0	12	180	252214	252046	Opitutus terrae PB90-1, complete genome	blastn	333	180	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
10521502	10521502	PRJNA1180292_P_NODE_2809_length_407_cov_0.808383_g2677_i0	PRJNA1180292	2809	407	0.808383	3.29011881	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	348	4.45e-91	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g2677	i0	82.169	85.4029484029484	415	64	100	9	1	407	1316363	1316775	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	34759	348	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10521578	10521578	PRJNA1180292_P_NODE_9689_length_249_cov_0.886364_g9557_i0	PRJNA1180292	9689	249	0.886364	2.20704636	Horticoccus luteus	2862869	Bacteria	Bacteria	178	3.56e-40	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g9557	i0	79.6	1.69076305220884	250	49	100	2	1	249	732319	732071	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	421	178	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
11244520	11244520	PRJNA1180292_P_NODE_10209_length_248_cov_0.891429_g10077_i0	PRJNA1180292	10209	248	0.891429	2.21074392	Verrucomicrobiota	74201	Bacteria	Bacteria	329	9.249999999999998e-86	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g10077	i0	90.8	159.516129032258	250	18	100	4	1	248	68	314	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	39560	331	0.993957703927492	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
15620693	15620693	PRJNA1180292_P_NODE_8233_length_252_cov_1.206704_g8101_i0	PRJNA1180292	8233	252	1.206704	3.04089408	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	422	1.51e-113	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g8101	i0	96.825	89.9801587301587	252	8	100	0	1	252	3096770	3097021	Pirellula sp. SH-Sr6A, complete genome	blastn	22675	422	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
16894915	16894915	PRJNA1180292_P_NODE_10694_length_247_cov_0.896552_g10562_i0	PRJNA1180292	10694	247	0.896552	2.21448344	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	167	7.64e-37	NTclustered	gi\|2874254109\|emb\|OY970194.1\|	2813034	g10562	i0	82.051	0.789473684210526	195	35	79	0	45	239	3774249	3774443	MAG: Sedimentisphaerales bacterium isolate MFD00905.bin.c.1 genome assembly, chromosome: 1	blastn	195	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
18169470	18169470	PRJNA1180292_P_NODE_12375_length_243_cov_0.917647_g12243_i0	PRJNA1180292	12375	243	0.917647	2.22988221	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	239	1.57e-58	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g12243	i0	84.362	53.2633744855967	243	38	100	0	1	243	308179	307937	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	12943	239	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
21994590	21994590	PRJNA1180292_P_NODE_8618_length_252_cov_0.871508_g8486_i0	PRJNA1180292	8618	252	0.871508	2.19620016	Pirellulales bacterium	2715253	Bacteria	Bacteria	115	2.8700000000000003e-21	NTclustered	gi\|2874253964\|emb\|OY970289.1\|	2715253	g8486	i0	94.595	30.6388888888889	74	4	29	0	38	111	3518901	3518974	MAG: Pirellulales bacterium isolate MFD05442.bin.c.2 genome assembly, chromosome: 1	blastn	7721	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales 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);;