metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1022392" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1022392" 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
162609	162609	PRJNA1022392_P_NODE_84121_length_151_cov_3.365385_g83452_i0	PRJNA1022392	84121	151	3.365385	5.08173135	Mesoterricola silvestris	2927979	Bacteria	Bacteria	99	1.56e-16	NTclustered	gi\|2490891634\|dbj\|AP027080.1\|	2927979	g83452	i0	92.647	3.34437086092715	68	5	45	0	84	151	3031167	3031234	Mesoterricola silvestris W79 DNA, complete genome	blastn	505	99	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Mesoterricola	Mesoterricola silvestris
1437204	1437204	PRJNA1022392_P_NODE_64442_length_171_cov_3.846774_g63773_i0	PRJNA1022392	64442	171	3.846774	6.57798354	Terriglobus roseus	392734	Bacteria	Bacteria	228	2.219999999999999e-55	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g63773	i0	90.643	38.953216374269	171	16	100	0	1	171	2713354	2713524	Terriglobus roseus DSM 18391, complete genome	blastn	6661	228	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
7814612	7814612	PRJNA1022392_P_NODE_32467_length_206_cov_2.943396_g31798_i0	PRJNA1022392	32467	206	2.943396	6.06339576	uncultured Granulicella sp.	1241325	Bacteria	Bacteria	65.8	2.31e-6	NTclustered	gi\|2836016425\|emb\|OZ196155.1\|	1241325	g31798	i0	83.824	0.330097087378641	68	11	33	0	29	96	41812	41879	MAG: uncultured Granulicella sp. isolate 9057d4d9-b77b-4c6f-b84b-ea5519435b63 genome assembly, chromosome: 8	blastn	68	65.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	uncultured Granulicella sp.
10365243	10365243	PRJNA1022392_P_NODE_33669_length_206_cov_2.691824_g33000_i0	PRJNA1022392	33669	206	2.691824	5.54515744	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	148	2.2299999999999996e-31	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g33000	i0	93.878	14.9174757281553	98	6	48	0	1	98	3751679	3751776	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	3073	148	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14191111	14191111	PRJNA1022392_P_NODE_68812_length_166_cov_2.159664_g68143_i0	PRJNA1022392	68812	166	2.159664	3.58504224	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2874253836\|emb\|OY969886.1\|	171953	g68143	i0	96.875	0.192771084337349	32	1	19	0	64	95	2338543	2338574	MAG: uncultured Acidobacteriota bacterium isolate MFD10007.bin.c.1 genome assembly, chromosome: 1	blastn	32	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18013978	18013978	PRJNA1022392_P_NODE_40855_length_195_cov_5.932432_g40186_i0	PRJNA1022392	40855	195	5.932432	11.5682424	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	75	3.6e-9	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g40186	i0	97.727	0.225641025641026	44	0	22	1	153	195	788781	788824	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	44	75	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
18014194	18014194	PRJNA1022392_P_NODE_56815_length_181_cov_2.940299_g56146_i0	PRJNA1022392	56815	181	2.940299	5.32194119	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	121	4.159999999999999e-23	NTclustered	gi\|2621701418\|emb\|OY760136.1\|	2910147	g56146	i0	85.841	1.00552486187845	113	16	62	0	67	179	2688284	2688172	MAG: Vicinamibacterales bacterium isolate f9e760c9-8bbe-4e76-9a0a-40d6f1fb97b8 genome assembly, chromosome: 1	blastn	182	121	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
19288190	19288190	PRJNA1022392_P_NODE_70756_length_164_cov_2.606838_g70087_i0	PRJNA1022392	70756	164	2.606838	4.27521432	Tunturiibacter empetritectus	3069691	Bacteria	Bacteria	110	8.01e-20	NTclustered	gi\|2750692779\|gb\|CP132932.1\|	3069691	g70087	i0	79.605	4.26219512195122	152	31	93	0	13	164	3769936	3769785	Tunturiibacter empetritectus strain M8UP23 chromosome	blastn	699	110	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Tunturiibacter	Tunturiibacter empetritectus
20563232	20563232	PRJNA1022392_P_NODE_35197_length_206_cov_2.320755_g34528_i0	PRJNA1022392	35197	206	2.320755	4.7807553	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	71.3	4.97e-8	NTclustered	gi\|2874254167\|emb\|OY970399.1\|	171953	g34528	i0	88.525	7.74757281553398	61	4	29	2	111	169	3978926	3978985	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1	blastn	1596	71.3	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);;