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

13 rows where analysis = "blastn", bioproject = "PRJNA857143" 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
5947335	5947335	PRJNA857143_S_NODE_44245_length_411_cov_4.355030_g43152_i0	PRJNA857143	44245	411	4.35503	17.8991733	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	448	4.309999999999999e-121	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g43152	i0	87.595	86.5961070559611	395	37	95	10	23	411	1866195	1866583	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	35591	448	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
8888251	8888251	PRJNA857143_S_NODE_11807_length_639_cov_1.833922_g10790_i0	PRJNA857143	11807	639	1.833922	11.71876158	Schlesneria	656899	Bacteria	Bacteria	857	0	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g10790	i0	92.157	503.9593114241	612	41	96	5	28	639	1	605	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	322030	861	0.995354239256678	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
9772666	9772666	PRJNA857143_S_NODE_97748_length_316_cov_0.962963_g96655_i0	PRJNA857143	97748	316	0.962963	3.04296308	Schlesneria sp. DSM 10557	3044399	Bacteria	Bacteria	507	5.25e-139	NTclustered	gi\|2806767875\|gb\|CP124747.2\|	3044399	g96655	i0	95.57	79.1550632911392	316	14	100	0	1	316	4527640	4527955	Schlesneria sp. DSM 10557 chromosome, complete genome	blastn	25013	507	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Schlesneria	Schlesneria sp. DSM 10557
11047369	11047369	PRJNA857143_S_NODE_189149_length_244_cov_1.508772_g188056_i0	PRJNA857143	189149	244	1.508772	3.68140368	Saltatorellus ferox	2528018	Bacteria	Bacteria	202	2.07e-47	NTclustered	gi\|1712682957\|gb\|CP036434.1\|	2528018	g188056	i0	85.864	180.446721311475	191	25	78	2	31	220	2930692	2930503	Planctomycetes bacterium Poly30 chromosome, complete genome	blastn	44029	202	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Saltatorellus	Saltatorellus ferox
13597042	13597042	PRJNA857143_S_NODE_147191_length_269_cov_1.193878_g146098_i0	PRJNA857143	147191	269	1.193878	3.21153182	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	302	2.22e-77	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g146098	i0	87.085	5.50557620817844	271	29	99	6	2	269	1867798	1867531	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	1481	302	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
14870848	14870848	PRJNA857143_S_NODE_106632_length_306_cov_1.090129_g105539_i0	PRJNA857143	106632	306	1.090129	3.33579474	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	333	9.1e-87	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g105539	i0	86.731	85.8104575163399	309	30	99	10	3	306	1867415	1867717	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	26258	333	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
16146881	16146881	PRJNA857143_S_NODE_54593_length_385_cov_1.823718_g53500_i0	PRJNA857143	54593	385	1.823718	7.0213143	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	231	4.399999999999999e-56	NTclustered	gi\|1702190059\|gb\|CP030884.1\|	2026779	g53500	i0	78.771	215.280519480519	358	66	91	9	22	372	437318	436964	Planctomycetaceae bacterium isolate ECT2AJA-110-A chromosome	blastn	82883	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
17812826	17812826	PRJNA857143_S_NODE_92454_length_322_cov_1.734940_g91361_i0	PRJNA857143	92454	322	1.73494	5.5865068	Schlesneria	656899	Bacteria	Bacteria	545	1.14e-150	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g91361	i0	97.214	145.754658385093	323	8	100	1	1	322	593	915	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	46933	545	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
18694594	18694594	PRJNA857143_S_NODE_143035_length_272_cov_1.567839_g141942_i0	PRJNA857143	143035	272	1.567839	4.26452208	Planctomycetota bacterium	2026780	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2621786302\|emb\|OY782760.1\|	2026780	g141942	i0	100	0.110294117647059	30	0	11	0	83	112	760504	760533	MAG: Planctomycetota bacterium isolate 4c5731f0-34ce-4739-be05-23ee86c4296e genome assembly, chromosome: 1	blastn	30	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
21245081	21245081	PRJNA857143_S_NODE_12237_length_630_cov_3.184919_g11214_i0	PRJNA857143	12237	630	3.184919	20.0649897	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	619	1.37e-172	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g11214	i0	84.977	136.698412698413	639	64	100	18	1	630	1867769	1867154	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	86120	619	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
22520153	22520153	PRJNA857143_S_NODE_16278_length_570_cov_1.615694_g15217_i0	PRJNA857143	16278	570	1.615694	9.2094558	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	793	0	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g15217	i0	91.769	139.964912280702	571	46	100	1	1	570	1867127	1866557	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	79780	793	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
22520944	22520944	PRJNA857143_S_NODE_59078_length_375_cov_2.649007_g57985_i0	PRJNA857143	59078	375	2.649007	9.93377625	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	497	3.81e-136	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g57985	i0	90.885	305.109333333333	373	30	99	4	1	373	1866897	1866529	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	114416	497	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
23795574	23795574	PRJNA857143_S_NODE_157999_length_260_cov_3.016043_g156906_i0	PRJNA857143	157999	260	3.016043	7.8417118	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	392	1.2299999999999999e-104	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g156906	i0	95.181	148.434615384615	249	11	95	1	13	260	1866810	1866562	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	38593	392	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae 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);;