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

14 rows where analysis = "blastn", bioproject = "PRJNA1061474" 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
178981	178981	PRJNA1061474_P_NODE_50981_length_246_cov_1.456647_g50735_i0	PRJNA1061474	50981	246	1.456647	3.58335162	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	163	9.84e-36	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g50735	i0	80.09	10.7642276422764	221	42	89	2	14	233	2913006	2913225	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	2648	163	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
1453611	1453611	PRJNA1061474_P_NODE_51242_length_246_cov_0.890173_g50996_i0	PRJNA1061474	51242	246	0.890173	2.18982558	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	183	7.549999999999997e-42	NTclustered	gi\|2874253903\|emb\|OY970228.1\|	100233	g50996	i0	80.672	60.150406504065	238	44	96	2	10	246	4778938	4778702	MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1	blastn	14797	183	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
2729458	2729458	PRJNA1061474_P_NODE_51923_length_246_cov_0.890173_g51677_i0	PRJNA1061474	51923	246	0.890173	2.18982558	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	303	5.56e-78	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g51677	i0	91.403	0.898373983739837	221	19	90	0	1	221	5177837	5178057	Tautonia plasticadhaerens strain ElP chromosome	blastn	221	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
2729459	2729459	PRJNA1061474_P_NODE_51943_length_246_cov_0.890173_g51697_i0	PRJNA1061474	51943	246	0.890173	2.18982558	Pirellulimonas nuda	2528009	Bacteria	Bacteria	250	7.34e-62	NTclustered	gi\|1712662089\|gb\|CP036291.1\|	2528009	g51697	i0	85.081	6.85772357723577	248	33	100	4	1	246	405234	405479	Pirellulimonas nuda strain Pla175 chromosome, complete genome	blastn	1687	250	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Pirellulimonas	Pirellulimonas nuda
2729499	2729499	PRJNA1061474_P_NODE_53623_length_244_cov_0.900585_g53377_i0	PRJNA1061474	53623	244	0.900585	2.1974274	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	71.3	6.08e-8	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g53377	i0	90.566	0.217213114754098	53	5	22	0	190	242	4537125	4537177	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	53	71.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
2729516	2729516	PRJNA1061474_P_NODE_54343_length_244_cov_0.900585_g54097_i0	PRJNA1061474	54343	244	0.900585	2.1974274	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	248	2.6199999999999997e-61	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g54097	i0	85.417	7.82786885245902	240	34	98	1	1	239	5786207	5786446	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	1910	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
4005516	4005516	PRJNA1061474_P_NODE_56184_length_242_cov_0.911243_g55938_i0	PRJNA1061474	56184	242	0.911243	2.20520806	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	215	2.63e-51	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g55938	i0	82.845	1.97520661157025	239	41	99	0	3	241	791575	791813	Gemmata sp. SH-PL17, complete genome	blastn	478	215	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
5281747	5281747	PRJNA1061474_P_NODE_53685_length_244_cov_0.900585_g53439_i0	PRJNA1061474	53685	244	0.900585	2.1974274	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	219	2.05e-52	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g53439	i0	84.375	0.918032786885246	224	34	91	1	18	240	1803932	1804155	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	224	219	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
10382289	10382289	PRJNA1061474_P_NODE_54849_length_243_cov_0.905882_g54603_i0	PRJNA1061474	54849	243	0.905882	2.20129326	Bremerella sp. P1	3026424	Bacteria	Bacteria	139	1.63e-28	NTclustered	gi\|2446655020\|gb\|CP118164.1\|	3026424	g54603	i0	80.628	1.39917695473251	191	27	77	8	1	186	1453193	1453378	Bremerella sp. P1 chromosome, complete genome	blastn	340	139	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella sp. P1
11657128	11657128	PRJNA1061474_P_NODE_38990_length_285_cov_1.363208_g38744_i0	PRJNA1061474	38990	285	1.363208	3.8851428	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	300	8.52e-77	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g38744	i0	85.714	41.0315789473684	287	37	100	4	1	285	4967081	4966797	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	11694	300	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
13765068	13765068	PRJNA1061474_P_NODE_48111_length_249_cov_0.875000_g47865_i0	PRJNA1061474	48111	249	0.875	2.17875	Gemmata	113	Bacteria	Bacteria	207	4.54e-49	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g47865	i0	82.143	72.8192771084337	252	35	99	10	1	247	8308656	8308410	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	18132	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
16755806	16755806	PRJNA1061474_P_NODE_48234_length_249_cov_0.875000_g47988_i0	PRJNA1061474	48234	249	0.875	2.17875	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	289	1.58e-73	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g47988	i0	87.6	26.9397590361446	250	29	100	2	1	249	1217775	1218023	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	6708	289	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
18030501	18030501	PRJNA1061474_P_NODE_45835_length_251_cov_0.865169_g45589_i0	PRJNA1061474	45835	251	0.865169	2.17157419	Urbifossiella limnaea	2528023	Bacteria	Bacteria	163	1.01e-35	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g45589	i0	80.66	0.844621513944223	212	39	84	2	39	249	4409409	4409619	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	212	163	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
19304576	19304576	PRJNA1061474_P_NODE_48376_length_249_cov_0.875000_g48130_i0	PRJNA1061474	48376	249	0.875	2.17875	Pirellulimonas nuda	2528009	Bacteria	Bacteria	189	1.6499999999999999e-43	NTclustered	gi\|1712662089\|gb\|CP036291.1\|	2528009	g48130	i0	80.645	3.88353413654618	248	44	99	4	1	246	440749	440504	Pirellulimonas nuda strain Pla175 chromosome, complete genome	blastn	967	189	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Pirellulimonas	Pirellulimonas nuda

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);;