metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1020854" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1020854" 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
161307	161307	PRJNA1020854_S_NODE_7521_length_547_cov_1040.063707_g4899_i0	PRJNA1020854	7521	547	1040.063707	5689.14847729	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	599	1.53e-166	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g4899	i0	88.431	54.617915904936	510	41	91	16	1	500	7728938	7728437	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	29876	599	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
9088629	9088629	PRJNA1020854_S_NODE_32908_length_178_cov_2.442953_g30144_i0	PRJNA1020854	32908	178	2.442953	4.34845634	Urbifossiella limnaea	2528023	Bacteria	Bacteria	200	5.08e-47	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g30144	i0	87.006	0.99438202247191	177	23	99	0	1	177	5920133	5919957	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	177	200	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
9088768	9088768	PRJNA1020854_S_NODE_41628_length_154_cov_2.240000_g38864_i0	PRJNA1020854	41628	154	2.24	3.4496000000000002	Aureliella helgolandensis	2527968	Bacteria	Bacteria	130	5.68e-26	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g38864	i0	98.63	1.26623376623377	73	1	47	0	7	79	5554640	5554568	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	195	130	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
10364595	10364595	PRJNA1020854_S_NODE_9889_length_418_cov_3.796915_g7159_i0	PRJNA1020854	9889	418	3.796915	15.8711047	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	673	0	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g7159	i0	95.694	207.538277511962	418	18	100	0	1	418	1830937	1830520	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	86751	673	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
12914489	12914489	PRJNA1020854_S_NODE_20151_length_245_cov_912.379630_g17387_i0	PRJNA1020854	20151	245	912.37963	2235.3300935	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	257	4.37e-64	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g17387	i0	89.372	65.7795918367347	207	19	84	3	40	245	1831413	1831209	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	16116	257	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
15030851	15030851	PRJNA1020854_S_NODE_15572_length_294_cov_1159.800000_g12808_i0	PRJNA1020854	15572	294	1159.8	3409.812	Pirellulaceae	2691357	Bacteria	Bacteria	241	5.42e-59	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g12808	i0	85.47	368.15306122449	234	31	79	3	56	288	3097757	3097526	Pirellula sp. SH-Sr6A, complete genome	blastn	108237	241	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
15463318	15463318	PRJNA1020854_S_NODE_10113_length_410_cov_526.167979_g7377_i0	PRJNA1020854	10113	410	526.167979	2157.2887139	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	520	8.979999999999998e-143	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g7377	i0	93.466	467.936585365854	352	20	85	3	62	410	1831263	1830912	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	191854	520	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
20129806	20129806	PRJNA1020854_S_NODE_39216_length_159_cov_4.338462_g36452_i0	PRJNA1020854	39216	159	4.338462	6.89815458	root	1	Root_unresolved	Root_unresolved	231	1.58e-56	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g36452	i0	93.082	12.5157232704403	159	9	100	2	1	159	1830336	1830492	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	1990	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
24386768	24386768	PRJNA1020854_S_NODE_13640_length_324_cov_666.728814_g10876_i0	PRJNA1020854	13640	324	666.72881400000006	2160.20135736	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	292	1.65e-74	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g10876	i0	86.296	107.595679012346	270	36	83	1	7	275	2562350	2562619	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	34861	292	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);;