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

13 rows where analysis = "blastn", bioproject = "PRJNA473824" 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
1721598	1721598	PRJNA473824_P_NODE_29782_length_218_cov_2.983425_g29144_i0	PRJNA473824	29782	218	2.983425	6.5038665	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g29144	i0	94.286	0.160550458715596	35	2	16	0	147	181	5234344	5234310	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	35	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
2996851	2996851	PRJNA473824_P_NODE_118903_length_172_cov_0.800000_g118265_i0	PRJNA473824	118903	172	0.8	1.376	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	211	2.25e-50	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g118265	i0	88.764	162.81976744186	178	13	100	5	1	172	7050918	7050742	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	28005	211	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
2997251	2997251	PRJNA473824_P_NODE_164763_length_150_cov_4.716814_g164125_i0	PRJNA473824	164763	150	4.716814	7.075221	Blastopirellula sp. J2-11	2943192	Bacteria	Bacteria	60.2	7.3e-5	NTclustered	gi\|2283101653\|gb\|CP097384.1\|	2943192	g164125	i0	85.965	0.38	57	7	37	1	91	146	3248405	3248461	Blastopirellula sp. J2-11 chromosome	blastn	57	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Blastopirellula	Blastopirellula sp. J2-11
2998002	2998002	PRJNA473824_P_NODE_82203_length_173_cov_3.308824_g81565_i0	PRJNA473824	82203	173	3.308824	5.72426552	Mucisphaera calidilacus	2527982	Bacteria	Bacteria	67.6	5.19e-7	NTclustered	gi\|1712644202\|gb\|CP036280.1\|	2527982	g81565	i0	93.333	1.08670520231214	45	3	26	0	120	164	437256	437212	Mucisphaera calidilacus strain Pan265 chromosome, complete genome	blastn	188	67.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Mucisphaera	Mucisphaera calidilacus
4274107	4274107	PRJNA473824_P_NODE_53544_length_173_cov_6.316176_g52906_i0	PRJNA473824	53544	173	6.316176	10.92698448	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	62.1	2.41e-5	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g52906	i0	88.462	0.531791907514451	52	4	29	2	107	157	5399457	5399407	Gemmata sp. SH-PL17, complete genome	blastn	92	62.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
8099379	8099379	PRJNA473824_P_NODE_130207_length_157_cov_8.616667_g129569_i0	PRJNA473824	130207	157	8.616667	13.52816719	Limnoglobus roseus	2598579	Bacteria	Bacteria	141	2.69e-29	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g129569	i0	83.226	1.80891719745223	155	24	98	2	2	155	5748933	5748780	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	284	141	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
11925873	11925873	PRJNA473824_P_NODE_75550_length_173_cov_3.617647_g74912_i0	PRJNA473824	75550	173	3.617647	6.25852931	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	119	1.4100000000000001e-22	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g74912	i0	94.737	15.5086705202312	76	4	44	0	1	76	153852	153927	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	2683	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
14475253	14475253	PRJNA473824_P_NODE_22212_length_251_cov_1.219626_g21574_i0	PRJNA473824	22212	251	1.219626	3.06126126	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	394	3.28e-105	NTclustered	gi\|218533792\|gb\|FJ490306.1\|	120965	g21574	i0	94.34	88.199203187251	265	1	100	4	1	251	392	128	Uncultured planctomycete clone E_29 16S ribosomal RNA gene, partial sequence	blastn	22138	394	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
14475335	14475335	PRJNA473824_P_NODE_27632_length_226_cov_1.507937_g26994_i0	PRJNA473824	27632	226	1.507937	3.40793762	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	311	3.01e-80	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g26994	i0	91.102	107.553097345133	236	11	100	4	1	226	5936385	5936620	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	24307	311	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
18298867	18298867	PRJNA473824_P_NODE_88115_length_173_cov_3.132353_g87477_i0	PRJNA473824	88115	173	3.132353	5.41897069	Humisphaera borealis	2807512	Bacteria	Bacteria	163	6.43e-36	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g87477	i0	81.287	0.988439306358382	171	26	99	2	3	173	2899327	2899163	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	171	163	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
19571914	19571914	PRJNA473824_P_NODE_114216_length_173_cov_2.330882_g113578_i0	PRJNA473824	114216	173	2.330882	4.03242586	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	110	8.5e-20	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g113578	i0	93.243	229.508670520231	74	5	43	0	2	75	4419828	4419755	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	39705	110	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
19571952	19571952	PRJNA473824_P_NODE_118756_length_172_cov_1.770370_g118118_i0	PRJNA473824	118756	172	1.77037	3.0450364	Humisphaera borealis	2807512	Bacteria	Bacteria	198	1.7499999999999999e-46	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g118118	i0	87.5	396.825581395349	176	16	100	6	1	172	5064389	5064216	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	68254	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
20848046	20848046	PRJNA473824_P_NODE_14697_length_313_cov_1.699275_g14060_i0	PRJNA473824	14697	313	1.699275	5.31873075	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	327	4.339999999999999e-85	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g14060	i0	85.669	39.2492012779553	314	41	99	4	2	313	1830914	1830603	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	12285	327	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);;