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

9 rows where analysis = "blastn", bioproject = "PRJNA695273" 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
3227638	3227638	PRJNA695273_P_NODE_121503_length_255_cov_1.329670_g120745_i0	PRJNA695273	121503	255	1.32967	3.3906585	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	409	1.19e-109	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g120745	i0	95.686	1.22352941176471	255	10	100	1	1	255	4510425	4510678	Planctomyces sp. SH-PL14, complete genome	blastn	312	409	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
7055303	7055303	PRJNA695273_P_NODE_124226_length_252_cov_0.748603_g123468_i0	PRJNA695273	124226	252	0.748603	1.88647956	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	322	1.58e-83	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g123468	i0	91.561	118.793650793651	237	15	93	5	16	250	1830976	1830743	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	29936	322	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
9605020	9605020	PRJNA695273_P_NODE_117328_length_260_cov_1.272727_g116570_i0	PRJNA695273	117328	260	1.272727	3.3090902	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	276	1.29e-69	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g116570	i0	86.22	1.40384615384615	254	35	98	0	1	254	4779500	4779247	Planctomyces sp. SH-PL62, complete genome	blastn	365	276	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
10880297	10880297	PRJNA695273_P_NODE_104909_length_274_cov_1.532338_g104151_i0	PRJNA695273	104909	274	1.532338	4.19860612	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	73.1	1.93e-8	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g104151	i0	95.556	8.0985401459854	45	2	16	0	71	115	1007378	1007422	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	2219	73.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
12155775	12155775	PRJNA695273_P_NODE_119370_length_257_cov_2.396739_g118612_i0	PRJNA695273	119370	257	2.396739	6.15961923	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	418	1.9999999999999994e-112	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g118612	i0	97.166	317.252918287938	247	7	96	0	1	247	2501352	2501106	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	81534	418	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
12156999	12156999	PRJNA695273_P_NODE_25370_length_548_cov_3.578947_g24617_i0	PRJNA695273	25370	548	3.578947	19.61262956	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	619	1.1799999999999997e-172	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g24617	i0	87.614	59.7883211678832	549	48	100	13	1	548	1831118	1831647	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	32764	619	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
17759485	17759485	PRJNA695273_P_NODE_102174_length_277_cov_1.509804_g101416_i0	PRJNA695273	102174	277	1.509804	4.18215708	Gemmata	113	Bacteria	Bacteria	331	2.9200000000000002e-86	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g101416	i0	88.686	2.94584837545126	274	28	99	2	1	274	7965170	7965440	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	816	331	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
19033393	19033393	PRJNA695273_P_NODE_101475_length_278_cov_1.463415_g100717_i0	PRJNA695273	101475	278	1.463415	4.0682937	Frigoriglobus	2774146	Bacteria	Bacteria	102	2.51e-17	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g100717	i0	100	9.16906474820144	55	0	20	0	212	266	5501008	5501062	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	2549	102	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
25408330	25408330	PRJNA695273_P_NODE_117140_length_260_cov_1.604278_g116382_i0	PRJNA695273	117140	260	1.604278	4.1711228	Pseudomonadati	3379134	Bacteria	Bacteria	65.8	3.04e-6	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g116382	i0	91.489	0.338461538461538	47	4	18	0	182	228	294607	294653	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	88	65.8	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);;