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

9 rows where analysis = "blastn", bioproject = "PRJNA669701" 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
635395	635395	PRJNA669701_P_NODE_131141_length_244_cov_0.900585_g130746_i0	PRJNA669701	131141	244	0.900585	2.1974274	Granulicella mallensis	940614	Bacteria	Bacteria	150	7.589999999999999e-32	NTclustered	gi\|358750971\|gb\|CP003130.1\|	682795	g130746	i0	85.417	6.0327868852459	144	21	59	0	96	239	4033064	4033207	Granulicella mallensis MP5ACTX8 chromosome, complete genome	blastn	1472	150	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella mallensis
3186149	3186149	PRJNA669701_P_NODE_128363_length_245_cov_0.895349_g127968_i0	PRJNA669701	128363	245	0.895349	2.19360505	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g127968	i0	100	0.114285714285714	28	0	11	0	212	239	4195876	4195903	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4993065	4993065	PRJNA669701_P_NODE_91344_length_268_cov_2.487179_g90949_i0	PRJNA669701	91344	268	2.487179	6.66563972	Paludibaculum	1649475	Bacteria	Bacteria	143	1.42e-29	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g90949	i0	96.512	30.2126865671642	86	3	32	0	176	261	6789731	6789816	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	8097	143	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
7014755	7014755	PRJNA669701_P_NODE_73106_length_290_cov_1.935484_g72711_i0	PRJNA669701	73106	290	1.935484	5.6129036	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	167	9.19e-37	NTclustered	gi\|2874253959\|emb\|OY970284.1\|	2651171	g72711	i0	87.075	32.4965517241379	147	19	51	0	140	286	1221209	1221355	MAG: Thermoanaerobaculia bacterium isolate MFD05513.bin.1.42 genome assembly, chromosome: 1	blastn	9424	167	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
7014957	7014957	PRJNA669701_P_NODE_86526_length_274_cov_1.532338_g86131_i0	PRJNA669701	86526	274	1.532338	4.19860612	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	161	4.01e-35	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g86131	i0	78.764	57.2773722627737	259	42	92	10	6	256	2736841	2737094	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	15694	161	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
7015088	7015088	PRJNA669701_P_NODE_95266_length_264_cov_1.612565_g94871_i0	PRJNA669701	95266	264	1.612565	4.2571716	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	204	6.29e-48	NTclustered	gi\|2891481964\|emb\|OZ219745.1\|	2910147	g94871	i0	82	66.2045454545455	250	35	93	9	20	264	2270485	2270729	MAG: Vicinamibacterales bacterium isolate d5a9b4ee-eb88-4731-bb2c-80bf662b4d04 genome assembly, chromosome: 2	blastn	17478	204	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
9564735	9564735	PRJNA669701_P_NODE_78308_length_284_cov_1.388626_g77913_i0	PRJNA669701	78308	284	1.388626	3.94369784	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	483	7.849999999999998e-132	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g77913	i0	97.527	101.05985915493	283	6	99	1	2	284	3299159	3298878	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	28701	483	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
14663801	14663801	PRJNA669701_P_NODE_100412_length_258_cov_2.859459_g100017_i0	PRJNA669701	100412	258	2.859459	7.37740422	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	263	9.97e-66	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g100017	i0	86.667	31.2790697674419	240	28	92	3	15	252	4200570	4200807	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	8070	263	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
17214539	17214539	PRJNA669701_P_NODE_99734_length_259_cov_1.666667_g99339_i0	PRJNA669701	99734	259	1.666667	4.31666753	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	350	7.47e-92	NTclustered	gi\|2874254159\|emb\|OY970389.1\|	2283092	g99339	i0	91.406	100.440154440154	256	20	98	2	5	259	2617903	2617649	MAG: Pyrinomonadaceae bacterium isolate MFD09206.bin.c.1 genome assembly, chromosome: 1	blastn	26014	350	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae 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);;