metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA414225" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA414225" 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
418921	418921	PRJNA414225_P_NODE_461_length_609_cov_2.771429_g383_i0	PRJNA414225	461	609	2.771429	16.87800261	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	726	0	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g383	i0	88.293	103.011494252874	615	60	100	12	1	609	1689677	1690285	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	62734	726	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
418990	418990	PRJNA414225_P_NODE_7601_length_223_cov_1.471264_g7514_i0	PRJNA414225	7601	223	1.471264	3.28091872	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	198	2.3999999999999994e-46	NTclustered	gi\|374850605\|dbj\|AP011662.1\|	171953	g7514	i0	84.135	41.7264573991031	208	29	92	4	18	223	7226	7021	Uncultured Acidobacteria bacterium DNA, fosmid clone: JFF007_F07	blastn	9305	198	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1693818	1693818	PRJNA414225_P_NODE_77382_length_163_cov_0.894737_g77295_i0	PRJNA414225	77382	163	0.894737	1.45842131	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	222	9.79e-54	NTclustered	gi\|374850605\|dbj\|AP011662.1\|	171953	g77295	i0	91.358	104.723926380368	162	14	99	0	1	162	7623	7784	Uncultured Acidobacteria bacterium DNA, fosmid clone: JFF007_F07	blastn	17070	222	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
2969624	2969624	PRJNA414225_P_NODE_283_length_806_cov_2.727873_g217_i0	PRJNA414225	283	806	2.727873	21.98665638	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	845	0	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g217	i0	86.318	227.908188585608	804	77	99	23	1	798	1689707	1688931	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	183694	845	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
2969644	2969644	PRJNA414225_P_NODE_42183_length_170_cov_1.685950_g42096_i0	PRJNA414225	42183	170	1.68595	2.866115	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	115	1.79e-21	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g42096	i0	81.119	0.841176470588235	143	27	84	0	12	154	2379184	2379042	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	143	115	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4245949	4245949	PRJNA414225_P_NODE_1804_length_320_cov_5.612546_g1717_i0	PRJNA414225	1804	320	5.612546	17.9601472	Terriglobus roseus	392734	Bacteria	Bacteria	531	3.16e-146	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g1717	i0	96.573	113.375	321	10	100	1	1	320	926705	927025	Terriglobus roseus DSM 18391, complete genome	blastn	36280	531	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
4245960	4245960	PRJNA414225_P_NODE_264_length_823_cov_3.652455_g202_i0	PRJNA414225	264	823	3.652455	30.05970465	Terriglobus roseus	392734	Bacteria	Bacteria	1509	0	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g202	i0	99.757	101.481166464156	823	2	100	0	1	823	2077952	2077130	Terriglobus roseus DSM 18391, complete genome	blastn	83519	1509	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
5522672	5522672	PRJNA414225_P_NODE_2745_length_279_cov_3.078261_g2658_i0	PRJNA414225	2745	279	3.078261	8.58834819	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	339	1.7599999999999998e-88	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g2658	i0	88.652	305.931899641577	282	27	100	4	1	279	3298173	3298452	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	85355	339	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
6796730	6796730	PRJNA414225_P_NODE_66126_length_165_cov_0.879310_g66039_i0	PRJNA414225	66126	165	0.87931	1.4508615	Terriglobus roseus	392734	Bacteria	Bacteria	220	3.57e-53	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g66039	i0	93.289	10.969696969697	149	10	90	0	17	165	2573568	2573716	Terriglobus roseus DSM 18391, complete genome	blastn	1810	220	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
10622873	10622873	PRJNA414225_P_NODE_72129_length_164_cov_0.886957_g72042_i0	PRJNA414225	72129	164	0.886957	1.45460948	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	196	5.98e-46	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g72042	i0	92.647	84.8170731707317	136	10	83	0	29	164	516763	516898	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	13910	196	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
15721535	15721535	PRJNA414225_P_NODE_1533_length_341_cov_6.202055_g1446_i0	PRJNA414225	1533	341	6.202055	21.14900755	Terriglobus roseus	392734	Bacteria	Bacteria	597	3.299999999999999e-166	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g1446	i0	98.24	113.563049853372	341	6	100	0	1	341	928701	929041	Terriglobus roseus DSM 18391, complete genome	blastn	38725	597	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
16996424	16996424	PRJNA414225_P_NODE_68494_length_164_cov_2.313043_g68407_i0	PRJNA414225	68494	164	2.313043	3.79339052	Terriglobus roseus	392734	Bacteria	Bacteria	191	2.78e-44	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g68407	i0	87.73	1.71341463414634	163	20	99	0	1	163	659458	659620	Terriglobus roseus DSM 18391, complete genome	blastn	281	191	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
18270533	18270533	PRJNA414225_P_NODE_375_length_682_cov_4.428120_g301_i0	PRJNA414225	375	682	4.42812	30.1997784	Terriglobus roseus	392734	Bacteria	Bacteria	1160	0	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g301	i0	97.368	171.951612903226	684	14	100	4	1	682	927938	928619	Terriglobus roseus DSM 18391, complete genome	blastn	117271	1160	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
18270656	18270656	PRJNA414225_P_NODE_89715_length_162_cov_0.858407_g89628_i0	PRJNA414225	89715	162	0.858407	1.39061934	Geothrix sp.	1962974	Bacteria	Bacteria	137	3.6199999999999997e-28	NTclustered	gi\|2515262989\|gb\|CP126625.1\|	1962974	g89628	i0	83.562	24.4506172839506	146	24	90	0	1	146	1763226	1763371	MAG: Geothrix sp. isolate L227-G1 chromosome, complete genome	blastn	3961	137	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp.
19544708	19544708	PRJNA414225_P_NODE_22076_length_186_cov_1.109489_g21989_i0	PRJNA414225	22076	186	1.109489	2.06364954	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	128	2.57e-25	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g21989	i0	81.098	0.881720430107527	164	27	87	4	17	178	776558	776719	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	164	128	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20820577	20820577	PRJNA414225_P_NODE_2157_length_300_cov_1.219124_g2070_i0	PRJNA414225	2157	300	1.219124	3.657372	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	135	2.6900000000000003e-27	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g2070	i0	91.837	3.21	98	6	33	2	51	148	3097160	3097255	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	963	135	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
20820595	20820595	PRJNA414225_P_NODE_29997_length_179_cov_1.561538_g29910_i0	PRJNA414225	29997	179	1.561538	2.79515302	Geothrix sp. 21YS21S-4	3068889	Bacteria	Bacteria	124	3.17e-24	NTclustered	gi\|2565867660\|gb\|CP132719.1\|	3068889	g29910	i0	89.691	8.46368715083799	97	10	54	0	21	117	2999445	2999541	Geothrix sp. 21YS21S-4 chromosome, complete genome	blastn	1515	124	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp. 21YS21S-4
20820641	20820641	PRJNA414225_P_NODE_48237_length_167_cov_0.864407_g48150_i0	PRJNA414225	48237	167	0.864407	1.44355969	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	104	3.81e-18	NTclustered	gi\|2874254159\|emb\|OY970389.1\|	2283092	g48150	i0	87.64	1.08982035928144	89	11	53	0	8	96	220560	220472	MAG: Pyrinomonadaceae bacterium isolate MFD09206.bin.c.1 genome assembly, chromosome: 1	blastn	182	104	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
22095291	22095291	PRJNA414225_P_NODE_14178_length_194_cov_1.062069_g14091_i0	PRJNA414225	14178	194	1.062069	2.06041386	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	128	2.6999999999999997e-25	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g14091	i0	82.353	52.8144329896907	153	21	77	6	3	152	480461	480610	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	10246	128	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
22095325	22095325	PRJNA414225_P_NODE_30538_length_178_cov_1.984496_g30451_i0	PRJNA414225	30538	178	1.984496	3.53240288	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	189	1.1e-43	NTclustered	gi\|2874253931\|emb\|OY970256.1\|	2283092	g30451	i0	86.111	81.1067415730337	180	20	99	5	1	177	359296	359473	MAG: Pyrinomonadaceae bacterium isolate MFD09212.bin.c.2 genome assembly, chromosome: 1	blastn	14437	189	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
22095344	22095344	PRJNA414225_P_NODE_42958_length_169_cov_4.675000_g42871_i0	PRJNA414225	42958	169	4.675	7.90075	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	122	1.06e-23	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g42871	i0	82.857	4.81065088757396	140	20	82	4	10	147	119411	119548	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	813	122	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
22760193	22760193	PRJNA414225_P_NODE_7718_length_222_cov_4.052023_g7631_i0	PRJNA414225	7718	222	4.052023	8.99549106	Terriglobus	392733	Bacteria	Bacteria	392	1.0199999999999999e-104	NTclustered	gi\|319923767\|gb\|CP002467.1\|	401053	g7631	i0	98.643	140.54954954955	221	3	99	0	2	222	3868759	3868979	Terriglobus saanensis SP1PR4, complete genome	blastn	31202	392	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus saanensis
24645307	24645307	PRJNA414225_P_NODE_28820_length_180_cov_1.503817_g28733_i0	PRJNA414225	28820	180	1.503817	2.7068706	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	198	1.85e-46	NTclustered	gi\|2874253931\|emb\|OY970256.1\|	2283092	g28733	i0	87.006	2.92777777777778	177	21	98	2	4	179	1958643	1958468	MAG: Pyrinomonadaceae bacterium isolate MFD09212.bin.c.2 genome assembly, chromosome: 1	blastn	527	198	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
24645392	24645392	PRJNA414225_P_NODE_72240_length_164_cov_0.886957_g72153_i0	PRJNA414225	72240	164	0.886957	1.45460948	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	159	7.84e-35	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g72153	i0	84.146	1	164	26	100	0	1	164	631863	631700	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	164	159	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);;