metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1174234" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1174234" 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
2867018	2867018	PRJNA1174234_P_NODE_3863_length_676_cov_3.195688_g3676_i0	PRJNA1174234	3863	676	3.195688	21.60285088	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	952	0	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g3676	i0	92.082	226.863905325444	682	45	100	9	1	676	2003117	2002439	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	153360	952	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
6694023	6694023	PRJNA1174234_P_NODE_19886_length_309_cov_4.432203_g19690_i0	PRJNA1174234	19886	309	4.432203	13.69550727	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	433	8.82e-117	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g19690	i0	91.987	158.423948220065	312	20	99	3	3	309	2004390	2004079	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	48953	433	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
6694039	6694039	PRJNA1174234_P_NODE_22526_length_291_cov_0.880734_g22330_i0	PRJNA1174234	22526	291	0.880734	2.56293594	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	433	8.24e-117	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g22330	i0	93.471	91.3436426116838	291	19	100	0	1	291	7629522	7629812	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	26581	433	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
7418769	7418769	PRJNA1174234_P_NODE_11706_length_403_cov_1.154545_g11510_i0	PRJNA1174234	11706	403	1.154545	4.65281635	Verrucomicrobiaceae	203557	Bacteria	Bacteria	372	2.61e-98	NTclustered	gi\|183579826\|emb\|AM905423.1\|	48465	g11510	i0	89.796	232.90570719603	294	25	73	4	1	294	1772	1484	Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251	blastn	93861	374	0.994652406417112	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii
7969310	7969310	PRJNA1174234_P_NODE_12147_length_395_cov_1.673913_g11951_i0	PRJNA1174234	12147	395	1.673913	6.61195635	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	63.9	1.75e-5	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g11951	i0	100	0.0860759493670886	34	0	9	0	357	390	4544486	4544519	Pirellula sp. SH-Sr6A, complete genome	blastn	34	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
8693889	8693889	PRJNA1174234_P_NODE_13707_length_372_cov_0.983278_g13511_i0	PRJNA1174234	13707	372	0.983278	3.65779416	Lacipirellula	2691417	Bacteria	Bacteria	555	2.2099999999999994e-153	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g13511	i0	93.566	140.959677419355	373	22	100	2	1	372	5170023	5170394	Lacipirellula limnantheis strain I41 chromosome	blastn	52437	560	0.991071428571429	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
11794652	11794652	PRJNA1174234_P_NODE_13810_length_370_cov_2.003367_g13614_i0	PRJNA1174234	13810	370	2.003367	7.4124579	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	364	3.98e-96	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g13614	i0	84.553	265.651351351351	369	55	99	2	1	369	1023	1389	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	98291	364	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
11794729	11794729	PRJNA1174234_P_NODE_28110_length_256_cov_1.262295_g27914_i0	PRJNA1174234	28110	256	1.262295	3.2314752	Humisphaera borealis	2807512	Bacteria	Bacteria	331	2.67e-86	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g27914	i0	90.272	71.4921875	257	20	100	4	1	256	5063967	5064219	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	18302	331	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
15618818	15618818	PRJNA1174234_P_NODE_18233_length_323_cov_0.924000_g18037_i0	PRJNA1174234	18233	323	0.924	2.98452	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	438	1.99e-118	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g18037	i0	91.331	116.786377708978	323	25	99	3	2	323	7628871	7628551	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	37722	438	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
15618877	15618877	PRJNA1174234_P_NODE_26613_length_265_cov_1.375000_g26417_i0	PRJNA1174234	26613	265	1.375	3.64375	Humisphaera borealis	2807512	Bacteria	Bacteria	398	2.7e-106	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g26417	i0	93.916	19.6037735849057	263	16	99	0	3	265	5063169	5062907	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	5195	398	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
20717486	20717486	PRJNA1174234_P_NODE_25277_length_273_cov_1.415000_g25081_i0	PRJNA1174234	25277	273	1.415	3.86295	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	494	3.46e-135	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g25081	i0	99.267	277.021978021978	273	2	100	0	1	273	3893531	3893803	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	75627	494	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20717563	20717563	PRJNA1174234_P_NODE_4937_length_606_cov_1.283302_g4744_i0	PRJNA1174234	4937	606	1.283302	7.77681012	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	926	0	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g4744	i0	94.262	121.57095709571	610	27	100	5	1	606	5171972	5171367	Lacipirellula limnantheis strain I41 chromosome	blastn	73672	926	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
24542043	24542043	PRJNA1174234_P_NODE_15960_length_346_cov_1.032967_g15764_i0	PRJNA1174234	15960	346	1.032967	3.57406582	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	394	4.72e-105	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g15764	i0	87.32	47.6936416184971	347	40	99	4	1	345	1830975	1830631	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	16502	394	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales 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);;