metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA393181" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA393181" 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
410651	410651	PRJNA393181_S_NODE_36181_length_181_cov_1.645833_g36075_i0	PRJNA393181	36181	181	1.645833	2.97895773	Planctomycetes bacterium syqfu	2896527	Bacteria	Bacteria	58.4	3.3e-4	NTclustered	gi\|2155219436\|gb\|CP087563.1\|	2896527	g36075	i0	92.683	1.33701657458564	41	2	22	1	49	88	4597404	4597364	Planctomycetes bacterium syqfu chromosome, complete genome	blastn	242	58.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium syqfu
1685165	1685165	PRJNA393181_S_NODE_22162_length_248_cov_1.857820_g22056_i0	PRJNA393181	22162	248	1.85782	4.6073936	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	180	9.859999999999999e-41	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g22056	i0	80.081	28.1814516129032	246	45	98	4	2	245	8999157	8999400	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	6989	180	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
1685274	1685274	PRJNA393181_S_NODE_26282_length_222_cov_4.486486_g26176_i0	PRJNA393181	26282	222	4.486486	9.95999892	Alienimonas californiensis	2527989	Bacteria	Bacteria	60.2	1.18e-4	NTclustered	gi\|1712468061\|gb\|CP036265.1\|	2527989	g26176	i0	81.69	0.31981981981982	71	13	32	0	1	71	3625734	3625664	Alienimonas californiensis strain CA12 chromosome	blastn	71	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Alienimonas	Alienimonas californiensis
4237528	4237528	PRJNA393181_S_NODE_28344_length_212_cov_2.651429_g28238_i0	PRJNA393181	28344	212	2.651429	5.62102948	Planctomycetales bacterium	2053591	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2210174292\|gb\|CP060262.1\|	2053591	g28238	i0	100	0.136792452830189	29	0	14	0	2	30	3368183	3368155	MAG: Planctomycetales bacterium isolate HK-STAS-UBP7_A-1 chromosome, complete genome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
4237914	4237914	PRJNA393181_S_NODE_43604_length_159_cov_4.131148_g43498_i0	PRJNA393181	43604	159	4.131148	6.56852532	Aquisphaera giovannonii	406548	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g43498	i0	100	0.176100628930818	28	0	18	0	115	142	5993656	5993683	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
5514328	5514328	PRJNA393181_S_NODE_3325_length_595_cov_2.231183_g3236_i0	PRJNA393181	3325	595	2.231183	13.27553885	Rohdeia mirabilis	2528008	Bacteria	Bacteria	56.5	0.005	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g3236	i0	97.059	0.0571428571428571	34	0	6	1	7	40	1141094	1141126	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	34	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
10614380	10614380	PRJNA393181_S_NODE_31689_length_197_cov_4.675000_g31583_i0	PRJNA393181	31689	197	4.675	9.20975	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	139	1.27e-28	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g31583	i0	83.117	40.6040609137056	154	24	78	2	31	183	4590989	4590837	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	7999	139	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
13164785	13164785	PRJNA393181_S_NODE_7391_length_437_cov_2.672500_g7285_i0	PRJNA393181	7391	437	2.6725	11.678825	Limnoglobus roseus	2598579	Bacteria	Bacteria	224	8.46e-54	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g7285	i0	78.674	49.1372997711671	347	66	78	7	15	357	3081872	3081530	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	21473	224	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
14439796	14439796	PRJNA393181_S_NODE_532_length_1012_cov_3.911795_g483_i0	PRJNA393181	532	1012	3.911795	39.5873654	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	124	2.1399999999999994e-23	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g483	i0	78.431	3.74901185770751	204	34	20	10	793	991	3627331	3627133	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	3794	124	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
15712908	15712908	PRJNA393181_S_NODE_19013_length_271_cov_2.982906_g18907_i0	PRJNA393181	19013	271	2.982906	8.08367526	Bremerella sp. P1	3026424	Bacteria	Bacteria	267	8.149999999999999e-67	NTclustered	gi\|2446655020\|gb\|CP118164.1\|	3026424	g18907	i0	84.444	25.029520295203	270	42	99	0	2	271	6739542	6739811	Bremerella sp. P1 chromosome, complete genome	blastn	6783	267	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella sp. P1
16988430	16988430	PRJNA393181_S_NODE_5654_length_488_cov_2.762749_g5548_i0	PRJNA393181	5654	488	2.762749	13.48221512	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|2621713475\|emb\|OY771506.1\|	2026777	g5548	i0	97.059	0.364754098360656	34	1	8	0	299	332	236230	236263	MAG: Phycisphaeraceae bacterium isolate 5ced0416-64b5-4844-9ce5-ab75583fac57 genome assembly, chromosome: 1	blastn	178	58.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
18262505	18262505	PRJNA393181_S_NODE_45335_length_155_cov_2.974576_g45229_i0	PRJNA393181	45335	155	2.974576	4.6105928	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	126	7.399999999999998e-25	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g45229	i0	89.796	66.6064516129032	98	10	63	0	1	98	1582774	1582871	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	10324	126	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
23362204	23362204	PRJNA393181_S_NODE_13939_length_323_cov_2.101399_g13833_i0	PRJNA393181	13939	323	2.101399	6.78751877	Gemmataceae bacterium	2052164	Bacteria	Bacteria	172	2.23e-38	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g13833	i0	77.931	57.8266253869969	290	54	88	9	20	304	4772039	4772323	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	18678	172	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
23363059	23363059	PRJNA393181_S_NODE_5579_length_491_cov_2.376652_g5473_i0	PRJNA393181	5579	491	2.376652	11.66936132	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	294	7.21e-75	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g5473	i0	81.266	5.18329938900204	379	58	76	13	1	373	8262375	8262746	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	2545	294	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae 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);;