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

14 rows where analysis = "blastn", bioproject = "PRJNA682078" 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
2447725	2447725	PRJNA682078_P_NODE_181262_length_274_cov_1.243781_g179485_i0	PRJNA682078	181262	274	1.243781	3.40795994	Bacteria	2	Bacteria	Bacteria	339	1.73e-88	NTclustered	gi\|76574291\|gb\|DQ139439.1\|	171953	g179485	i0	88.849	116.222627737226	278	27	100	4	1	274	930	1207	Uncultured Acidobacteria bacterium clone CAL9 23S ribosomal RNA gene, partial sequence	blastn	31845	339	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5764933	5764933	PRJNA682078_P_NODE_252065_length_247_cov_0.885057_g250288_i0	PRJNA682078	252065	247	0.885057	2.18609079	Granulicella sp. WH15	2602070	Bacteria	Bacteria	206	1.6199999999999998e-48	NTclustered	gi\|1799576755\|gb\|CP042596.1\|	2602070	g250288	i0	90.385	70.8137651821862	156	15	63	0	43	198	117647	117802	Granulicella sp. WH15 chromosome, complete genome	blastn	17491	206	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella sp. WH15
8315005	8315005	PRJNA682078_P_NODE_271927_length_244_cov_0.900585_g270150_i0	PRJNA682078	271927	244	0.900585	2.1974274	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	339	1.51e-88	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g270150	i0	92.735	1.07377049180328	234	17	96	0	10	243	3020217	3020450	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	262	339	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
12139008	12139008	PRJNA682078_P_NODE_182530_length_273_cov_1.540000_g180753_i0	PRJNA682078	182530	273	1.54	4.2042	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	412	9.98e-111	NTclustered	gi\|339646243\|gb\|JN038632.1\|	171953	g180753	i0	99.127	83.014652014652	229	2	99	0	45	273	17	245	Uncultured Acidobacteria bacterium clone MA-R64 16S ribosomal RNA gene, partial sequence	blastn	22663	412	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12139453	12139453	PRJNA682078_P_NODE_201030_length_262_cov_1.629630_g199253_i0	PRJNA682078	201030	262	1.62963	4.2696306	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	418	2.0499999999999995e-112	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g199253	i0	95.42	356.538167938931	262	12	100	0	1	262	2907477	2907738	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	93413	418	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13412322	13412322	PRJNA682078_P_NODE_137471_length_306_cov_2.811159_g135694_i0	PRJNA682078	137471	306	2.811159	8.60214654	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	418	2.44e-112	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g135694	i0	91.234	781.205882352941	308	25	100	2	1	306	4233634	4233941	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	239049	418	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13413975	13413975	PRJNA682078_P_NODE_201271_length_262_cov_1.597884_g199494_i0	PRJNA682078	201271	262	1.597884	4.18645608	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	97.1	1.09e-15	NTclustered	gi\|2874253836\|emb\|OY969886.1\|	171953	g199494	i0	84	29.9389312977099	100	16	38	0	1	100	3437018	3436919	MAG: uncultured Acidobacteriota bacterium isolate MFD10007.bin.c.1 genome assembly, chromosome: 1	blastn	7844	97.1	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15962691	15962691	PRJNA682078_P_NODE_195233_length_266_cov_1.056995_g193456_i0	PRJNA682078	195233	266	1.056995	2.8116067	Mesoterricola silvestris	2927979	Bacteria	Bacteria	137	6.53e-28	NTclustered	gi\|2490891634\|dbj\|AP027080.1\|	2927979	g193456	i0	82.099	1.22556390977444	162	27	61	2	4	164	1388084	1387924	Mesoterricola silvestris W79 DNA, complete genome	blastn	326	137	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Mesoterricola	Mesoterricola silvestris
18513784	18513784	PRJNA682078_P_NODE_267595_length_244_cov_1.350877_g265818_i0	PRJNA682078	267595	244	1.350877	3.29613988	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	300	7.12e-77	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g265818	i0	88.934	14.594262295082	244	26	100	1	1	244	3919243	3919001	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	3561	300	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20299696	20299696	PRJNA682078_P_NODE_271936_length_244_cov_0.900585_g270159_i0	PRJNA682078	271936	244	0.900585	2.1974274	Bacteria	2	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g270159	i0	100	0.80327868852459	28	0	11	0	194	221	1360790	1360763	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	196	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
23613448	23613448	PRJNA682078_P_NODE_222139_length_251_cov_0.865169_g220362_i0	PRJNA682078	222139	251	0.865169	2.17157419	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	69.4	2.26e-7	NTclustered	gi\|2874253959\|emb\|OY970284.1\|	2651171	g220362	i0	95.455	187.362549800797	44	1	21	1	137	179	6576875	6576918	MAG: Thermoanaerobaculia bacterium isolate MFD05513.bin.1.42 genome assembly, chromosome: 1	blastn	47028	69.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
23614039	23614039	PRJNA682078_P_NODE_245939_length_248_cov_0.880000_g244162_i0	PRJNA682078	245939	248	0.88	2.1824	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	62.1	3.73e-5	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g244162	i0	100	0.133064516129032	33	0	13	0	216	248	5395114	5395082	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	33	62.1	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
23615016	23615016	PRJNA682078_P_NODE_284219_length_242_cov_0.911243_g282442_i0	PRJNA682078	284219	242	0.911243	2.20520806	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	276	1.19e-69	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g282442	i0	87.19	1	242	31	100	0	1	242	5298670	5298429	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	242	276	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24889527	24889527	PRJNA682078_P_NODE_68180_length_418_cov_1.202899_g66405_i0	PRJNA682078	68180	418	1.202899	5.02811782	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	412	1.5999999999999996e-110	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g66405	i0	84.487	136.315789473684	419	63	100	2	1	418	3298179	3298596	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	56980	412	1	Bacteria	Pseudomonadati	Acidobacteriota					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);;