metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA763243" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA763243" 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
743633	743633	PRJNA763243_P_NODE_54601_length_248_cov_6.491429_g54255_i0	PRJNA763243	54601	248	6.491429	16.09874392	Humisphaera borealis	2807512	Bacteria	Bacteria	396	9e-106	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g54255	i0	96.266	556.407258064516	241	9	97	0	4	244	5063758	5063998	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	137989	396	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
1205262	1205262	PRJNA763243_P_NODE_71721_length_212_cov_6.877698_g71375_i0	PRJNA763243	71721	212	6.877698	14.58071976	Phycisphaerae	666505	Bacteria	Bacteria	322	1.29e-83	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g71375	i0	94.686	121.688679245283	207	11	98	0	6	212	1831831	1831625	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	25798	322	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
2480834	2480834	PRJNA763243_P_NODE_8562_length_505_cov_4.178241_g8220_i0	PRJNA763243	8562	505	4.178241	21.10011705	Bacteria	2	Bacteria	Bacteria	558	2.39e-154	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g8220	i0	87.123	366.063366336634	497	58	98	6	11	504	2002386	2002879	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	184862	558	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
3295395	3295395	PRJNA763243_P_NODE_8383_length_509_cov_46.250000_g8042_i0	PRJNA763243	8383	509	46.25	235.4125	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	444	7.03e-120	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g8042	i0	82.772	437.7721021611	505	80	99	7	8	509	4422886	4422386	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	222826	444	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
7122442	7122442	PRJNA763243_P_NODE_59906_length_244_cov_0.900585_g59560_i0	PRJNA763243	59906	244	0.900585	2.1974274	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	315	2.5399999999999992e-81	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g59560	i0	90.204	577.020491803279	245	19	99	4	1	241	7051951	7051708	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	140793	315	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
8396057	8396057	PRJNA763243_P_NODE_20107_length_353_cov_0.975000_g19761_i0	PRJNA763243	20107	353	0.975	3.44175	planctomycete str. 449	79870	Bacteria	Bacteria	477	4.6499999999999996e-130	NTclustered	gi\|12583969\|gb\|AF245373.1\|AF245373	79870	g19761	i0	91.404	164.521246458924	349	29	99	1	1	349	597	250	Planctomycete str. 449 23S ribosomal RNA gene, partial sequence	blastn	58076	477	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 449
8396490	8396490	PRJNA763243_P_NODE_38147_length_281_cov_13.211538_g37801_i0	PRJNA763243	38147	281	13.211538	37.12442178	Gemmataceae bacterium	2052164	Bacteria	Bacteria	324	4.97e-84	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g37801	i0	87.9	67.5658362989324	281	27	99	5	1	277	4437996	4437719	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	18986	324	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
10947999	10947999	PRJNA763243_P_NODE_64849_length_238_cov_9.618182_g64503_i0	PRJNA763243	64849	238	9.618182	22.89127316	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	329	8.82e-86	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g64503	i0	91.915	154.424369747899	235	19	99	0	4	238	4959610	4959844	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	36753	329	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
12222330	12222330	PRJNA763243_P_NODE_15130_length_396_cov_3.015480_g14785_i0	PRJNA763243	15130	396	3.01548	11.9413008	Planctomycetota bacterium	2026780	Bacteria	Bacteria	403	9.08e-108	NTclustered	gi\|2621705096\|emb\|OY763323.1\|	2026780	g14785	i0	86.047	121.444444444444	387	40	97	7	7	392	1008035	1007662	MAG: Planctomycetota bacterium isolate 3a5a21b3-ef55-46fa-90a9-c954c41cad77 genome assembly, chromosome: 1	blastn	48092	403	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
13497665	13497665	PRJNA763243_P_NODE_66911_length_232_cov_2.069182_g66565_i0	PRJNA763243	66911	232	2.069182	4.80050224	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	226	1.1599999999999999e-54	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g66565	i0	84.783	73.8577586206897	230	30	98	4	4	231	2502733	2502507	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	17135	226	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
13497713	13497713	PRJNA763243_P_NODE_68811_length_226_cov_2.679739_g68465_i0	PRJNA763243	68811	226	2.679739	6.05621014	Polystyrenella longa	2528007	Bacteria	Bacteria	233	6.689999999999999e-57	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g68465	i0	90.503	111.778761061947	179	14	78	3	2	178	1416777	1416954	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	25262	233	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa
14772993	14772993	PRJNA763243_P_NODE_73552_length_204_cov_4.732824_g73206_i0	PRJNA763243	73552	204	4.732824	9.65496096	Alienimonas californiensis	2527989	Bacteria	Bacteria	198	2.16e-46	NTclustered	gi\|1712468061\|gb\|CP036265.1\|	2527989	g73206	i0	84.878	101.480392156863	205	22	98	7	2	201	373550	373350	Alienimonas californiensis strain CA12 chromosome	blastn	20702	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Alienimonas	Alienimonas californiensis
17322379	17322379	PRJNA763243_P_NODE_73714_length_203_cov_8.500000_g73368_i0	PRJNA763243	73714	203	8.5	17.255	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	292	9.58e-75	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g73368	i0	93	254.275862068966	200	14	99	0	1	200	2001869	2001670	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	51618	292	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
18594996	18594996	PRJNA763243_P_NODE_42575_length_270_cov_13.370558_g42229_i0	PRJNA763243	42575	270	13.370558	36.1005066	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	398	2.759999999999999e-106	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g42229	i0	95.238	135.840740740741	252	10	93	2	19	268	7630497	7630246	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	36677	398	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
18595576	18595576	PRJNA763243_P_NODE_67355_length_230_cov_8.363057_g67009_i0	PRJNA763243	67355	230	8.363057	19.2350311	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	268	1.87e-67	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g67009	i0	90.955	103.930434782609	199	18	87	0	29	227	1831263	1831065	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	23904	268	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
19870113	19870113	PRJNA763243_P_NODE_38116_length_281_cov_57.615385_g37770_i0	PRJNA763243	38116	281	57.615385	161.89923185	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	370	6.3e-98	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g37770	i0	91.071	113.540925266904	280	16	99	7	5	281	4317334	4317607	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	31905	370	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
23696988	23696988	PRJNA763243_P_NODE_72679_length_207_cov_32.365672_g72333_i0	PRJNA763243	72679	207	32.365672000000004	66.99694104	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	316	5.819999999999998e-82	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g72333	i0	94.608	192.386473429952	204	11	99	0	1	204	1844442	1844645	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	39824	316	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia

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