metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA597223" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA597223" and tax_phylum = "Acidobacteriota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
3692267	3692267	PRJNA597223_P_NODE_68923_length_172_cov_2.649635_g67077_i0	PRJNA597223	68923	172	2.649635	4.5573722	Terriglobales	204433	Bacteria	Bacteria	291	2.81e-74	NTclustered	gi\|2874253693\|emb\|OY969419.1\|	194844	g67077	i0	97.093	136.005813953488	172	5	100	0	1	172	5898306	5898477	MAG: uncultured Acidobacteriaceae bacterium isolate MFD03346.bin.1.13 genome assembly, chromosome: 1	blastn	23393	291	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
5673101	5673101	PRJNA597223_P_NODE_63205_length_182_cov_3.061224_g61359_i0	PRJNA597223	63205	182	3.061224	5.57142768	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	244	2.38e-60	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g61359	i0	91.257	44.2142857142857	183	11	99	5	2	182	2367208	2367029	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	8047	244	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6947127	6947127	PRJNA597223_P_NODE_22126_length_338_cov_23.386139_g20286_i0	PRJNA597223	22126	338	23.386139	79.04514982	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	542	1.55e-149	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g20286	i0	95.562	223.257396449704	338	15	100	0	1	338	2365653	2365990	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	75461	542	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6947708	6947708	PRJNA597223_P_NODE_75166_length_163_cov_3.085938_g73320_i0	PRJNA597223	75166	163	3.085938	5.03007894	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	263	5.77e-66	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g73320	i0	95.706	6	163	7	100	0	1	163	3299805	3299643	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	978	263	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
8222461	8222461	PRJNA597223_P_NODE_52907_length_191_cov_2.608974_g51061_i0	PRJNA597223	52907	191	2.608974	4.98314034	Paludibaculum fermentans	1473598	Bacteria	Bacteria	252	1.51e-62	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g51061	i0	90.576	169.020942408377	191	16	99	2	1	190	4786328	4786517	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	32283	252	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
8793592	8793592	PRJNA597223_P_NODE_70627_length_170_cov_0.985185_g68781_i0	PRJNA597223	70627	170	0.985185	1.6748145	Bacteria	2	Bacteria	Bacteria	182	1.74e-41	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g68781	i0	89.655	96.2235294117647	145	11	85	4	26	170	714647	714507	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	16358	182	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
10773124	10773124	PRJNA597223_P_NODE_13509_length_461_cov_5.089202_g11739_i0	PRJNA597223	13509	461	5.089202	23.46122122	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	634	3.4899999999999993e-177	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g11739	i0	91.558	2.66594360086768	462	36	100	3	1	461	4472119	4472578	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	1229	634	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12048357	12048357	PRJNA597223_P_NODE_49570_length_198_cov_2.668712_g47724_i0	PRJNA597223	49570	198	2.668712	5.28404976	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	261	2.6200000000000002e-65	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g47724	i0	90.909	91.540404040404	198	13	99	5	1	196	2367169	2366975	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	18125	261	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14597909	14597909	PRJNA597223_P_NODE_36172_length_241_cov_5.466019_g34326_i0	PRJNA597223	36172	241	5.466019	13.17310579	Granulicella sp. WH15	2602070	Bacteria	Bacteria	427	3.079999999999999e-115	NTclustered	gi\|1799576755\|gb\|CP042596.1\|	2602070	g34326	i0	98.75	164.946058091286	240	3	99	0	2	241	400554	400315	Granulicella sp. WH15 chromosome, complete genome	blastn	39752	427	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella sp. WH15
14598467	14598467	PRJNA597223_P_NODE_85892_length_152_cov_1.179487_g84046_i0	PRJNA597223	85892	152	1.179487	1.79282024	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	163	5.5e-36	NTclustered	gi\|112980852\|gb\|DQ829656.1\|	171953	g84046	i0	87.5	45.6973684210526	144	14	93	4	2	143	338	479	Uncultured Acidobacteria bacterium clone DON25 23S ribosomal RNA gene, partial sequence	blastn	6946	163	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15168955	15168955	PRJNA597223_P_NODE_71352_length_168_cov_6.165414_g69506_i0	PRJNA597223	71352	168	6.165414	10.35789552	Pseudomonadati	3379134	Bacteria	Bacteria	255	1e-63	NTclustered	gi\|2874254057\|emb\|OY970381.1\|	194844	g69506	i0	94.048	54.4702380952381	168	10	100	0	1	168	1657116	1657283	MAG: uncultured Acidobacteriaceae bacterium isolate MFD04580.bin.1.19 genome assembly, chromosome: 1	blastn	9151	255	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
15168960	15168960	PRJNA597223_P_NODE_72552_length_167_cov_1.469697_g70706_i0	PRJNA597223	72552	167	1.469697	2.45439399	Luteitalea	2004797	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g70706	i0	100	85.3892215568862	167	0	100	0	1	167	654172	654338	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	14260	309	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
15871667	15871667	PRJNA597223_P_NODE_30213_length_274_cov_2.656904_g28367_i0	PRJNA597223	30213	274	2.656904	7.27991696	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	128	4.07e-25	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g28367	i0	83.688	0.514598540145985	141	18	51	5	135	274	4464949	4465085	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	141	128	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
17146787	17146787	PRJNA597223_P_NODE_42374_length_218_cov_2.092896_g40528_i0	PRJNA597223	42374	218	2.092896	4.56251328	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	283	6.28e-72	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g40528	i0	90.367	73.7064220183486	218	17	99	4	2	218	1689794	1690008	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	16068	283	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18421154	18421154	PRJNA597223_P_NODE_50415_length_196_cov_3.925466_g48569_i0	PRJNA597223	50415	196	3.925466	7.69391336	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	58.4	3.64e-4	NTclustered	gi\|2891481964\|emb\|OZ219745.1\|	2910147	g48569	i0	94.737	0.530612244897959	38	0	19	2	121	158	6024146	6024111	MAG: Vicinamibacterales bacterium isolate d5a9b4ee-eb88-4731-bb2c-80bf662b4d04 genome assembly, chromosome: 2	blastn	104	58.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
18992206	18992206	PRJNA597223_P_NODE_74315_length_164_cov_4.263566_g72469_i0	PRJNA597223	74315	164	4.263566	6.99224824	Edaphobacter	388463	Bacteria	Bacteria	230	5.89e-56	NTclustered	gi\|2874254057\|emb\|OY970381.1\|	194844	g72469	i0	94.595	302.048780487805	148	8	90	0	3	150	1655850	1655997	MAG: uncultured Acidobacteriaceae bacterium isolate MFD04580.bin.1.19 genome assembly, chromosome: 1	blastn	49536	230	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
20971157	20971157	PRJNA597223_P_NODE_21837_length_341_cov_23.173203_g19997_i0	PRJNA597223	21837	341	23.173203	79.02062223	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	558	1.56e-154	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g19997	i0	96.188	157.00293255132	341	13	100	0	1	341	3300703	3301043	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	53538	558	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
22246017	22246017	PRJNA597223_P_NODE_22738_length_332_cov_23.976431_g20896_i0	PRJNA597223	22738	332	23.976431	79.60175092	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	514	3.32e-141	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g20896	i0	94.595	198.027108433735	333	17	100	1	1	332	2365658	2365990	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	65745	514	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
23521839	23521839	PRJNA597223_P_NODE_78699_length_159_cov_1.967742_g76853_i0	PRJNA597223	78699	159	1.967742	3.12870978	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	233	4.38e-57	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g76853	i0	93.082	65.5157232704402	159	11	100	0	1	159	4732964	4733122	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	10417	233	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24092688	24092688	PRJNA597223_P_NODE_4599_length_814_cov_10.480103_g3441_i0	PRJNA597223	4599	814	10.480103	85.30803842	Acidobacteriaceae	204434	Bacteria	Bacteria	865	0	NTclustered	gi\|470484216\|ref\|NR_076636.1\|	33075	g3441	i0	86.007	477.02457002457	829	90	100	26	1	814	1104	1921	Acidobacterium capsulatum strain 161 23S ribosomal RNA gene, complete sequence	blastn	388298	865	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Acidobacterium	Acidobacterium capsulatum
24795139	24795139	PRJNA597223_P_NODE_37140_length_237_cov_3.103960_g35294_i0	PRJNA597223	37140	237	3.10396	7.3563852	Paludibaculum fermentans	1473598	Bacteria	Bacteria	255	1.51e-63	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g35294	i0	88.235	190.746835443038	221	16	91	9	22	237	4785879	4785664	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	45207	255	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
25366939	25366939	PRJNA597223_P_NODE_11180_length_515_cov_4.335417_g9475_i0	PRJNA597223	11180	515	4.335417	22.32739755	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	593	6.679999999999998e-165	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g9475	i0	88.283	260.339805825243	495	58	96	0	20	514	1	495	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	134075	593	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota 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);;