metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA376117" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA376117" and tax_phylum = "Planctomycetota"

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
400062	400062	PRJNA376117_P_NODE_39341_length_246_cov_0.890173_g39039_i0	PRJNA376117	39341	246	0.890173	2.18982558	Thermoguttaceae bacterium	2691551	Bacteria	Bacteria	110	1.3e-19	NTclustered	gi\|2814788363\|emb\|OY780964.2\|	2691551	g39039	i0	83.065	2.58130081300813	124	18	49	3	2	122	1419012	1418889	MAG: Thermoguttaceae bacterium isolate 5d2646e0-01ad-46f9-a460-09296c79865c genome assembly, chromosome: 1	blastn	635	110	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae		Thermoguttaceae bacterium
1073583	1073583	PRJNA376117_P_NODE_11821_length_393_cov_2.990625_g11519_i0	PRJNA376117	11821	393	2.990625	11.75315625	Pirellulaceae	2691357	Bacteria	Bacteria	446	1.4799999999999999e-120	NTclustered	gi\|470485626\|ref\|NR_076710.1\|	125	g11519	i0	87.186	114.068702290076	398	43	100	7	1	393	1131	1525	Pirellula staleyi strain DSM 6068 23S ribosomal RNA gene, complete sequence	blastn	44829	448	0.995535714285714	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula staleyi
1674846	1674846	PRJNA376117_P_NODE_8542_length_459_cov_4.556995_g8240_i0	PRJNA376117	8542	459	4.556995	20.91660705	Lignipirellula cremea	2528010	Bacteria	Bacteria	597	4.559999999999998e-166	NTclustered	gi\|1712668320\|gb\|CP036433.1\|	2528010	g8240	i0	90.175	129.56862745098	458	45	99	0	2	459	1144450	1144907	Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome	blastn	59472	597	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Lignipirellula	Lignipirellula cremea
2950668	2950668	PRJNA376117_P_NODE_39643_length_246_cov_0.890173_g39341_i0	PRJNA376117	39643	246	0.890173	2.18982558	Aureliella helgolandensis	2527968	Bacteria	Bacteria	195	3.49e-45	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g39341	i0	84.314	102.837398373984	204	27	82	5	1	202	6998852	6999052	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	25298	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
8053253	8053253	PRJNA376117_P_NODE_38087_length_247_cov_0.885057_g37785_i0	PRJNA376117	38087	247	0.885057	2.18609079	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	73.1	1.71e-8	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g37785	i0	93.75	0.194331983805668	48	3	19	0	165	212	3730605	3730558	Planctomyces sp. SH-PL14, complete genome	blastn	48	73.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
14428530	14428530	PRJNA376117_P_NODE_22352_length_292_cov_1.789954_g22050_i0	PRJNA376117	22352	292	1.789954	5.22666568	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	339	1.86e-88	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g22050	i0	87.838	356.609589041096	296	27	99	7	2	292	1829829	1830120	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	104130	339	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
16977286	16977286	PRJNA376117_P_NODE_3274_length_781_cov_3.598870_g2997_i0	PRJNA376117	3274	781	3.59887	28.1071747	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	1018	0	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g2997	i0	90.306	123.340588988476	784	66	100	10	1	781	7628963	7628187	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	96329	1018	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
19525676	19525676	PRJNA376117_P_NODE_24376_length_285_cov_1.089623_g24074_i0	PRJNA376117	24376	285	1.089623	3.10542555	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	359	1.39e-94	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g24074	i0	89.384	49.5368421052632	292	21	99	9	2	285	1830165	1830454	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	14118	359	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
19525706	19525706	PRJNA376117_P_NODE_26336_length_278_cov_1.502439_g26034_i0	PRJNA376117	26336	278	1.502439	4.17678042	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	176	1.46e-39	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g26034	i0	78.967	4.01079136690648	271	47	96	10	1	266	246585	246850	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	1115	176	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
22076363	22076363	PRJNA376117_P_NODE_27378_length_274_cov_1.960199_g27076_i0	PRJNA376117	27378	274	1.960199	5.37094526	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	176	1.43e-39	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g27076	i0	80.165	54.1204379562044	242	42	87	6	11	249	2593105	2592867	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	14829	176	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
22076398	22076398	PRJNA376117_P_NODE_2978_length_828_cov_2.487417_g2711_i0	PRJNA376117	2978	828	2.487417	20.59581276	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	1055	0	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g2711	i0	89.94	346.566425120773	835	60	99	22	3	828	1831477	1830658	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	286957	1055	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
24025292	24025292	PRJNA376117_P_NODE_11319_length_401_cov_1.408537_g11017_i0	PRJNA376117	11319	401	1.408537	5.64823337	Phycisphaerae	666505	Bacteria	Bacteria	547	4.0199999999999996e-151	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g11017	i0	91.294	123.082294264339	402	34	100	1	1	401	1831896	1832297	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	49356	547	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);;