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

9 rows where analysis = "blastn", bioproject = "PRJDB9741" 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_species
10860	10860	PRJDB9741_P_NODE_17381_length_182_cov_2.172932_g17064_i0	PRJDB9741	17381	182	2.172932	3.95473624	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	143	8.93e-30	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g17064	i0	80.874	3.63186813186813	183	33	100	2	1	182	1000119	1000300	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	661	143	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
6389227	6389227	PRJDB9741_P_NODE_3886_length_336_cov_2.414634_g3570_i0	PRJDB9741	3886	336	2.414634	8.11317024	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	505	2.0199999999999995e-138	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g3570	i0	94.242	152.10119047619	330	19	98	0	7	336	2365981	2365652	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	51106	505	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
14038916	14038916	PRJDB9741_P_NODE_19672_length_178_cov_2.131783_g19355_i0	PRJDB9741	19672	178	2.131783	3.79457374	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	176	8.56e-40	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g19355	i0	84.831	35.4550561797753	178	23	99	4	1	176	1632824	1632999	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	6311	176	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
16587737	16587737	PRJDB9741_P_NODE_1934_length_546_cov_5.084507_g1629_i0	PRJDB9741	1934	546	5.084507	27.76140822	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	750	0	NTclustered	gi\|76574297\|gb\|DQ139445.1\|	171953	g1629	i0	91.697	97.4652014652015	542	43	99	2	6	546	3	543	Uncultured Acidobacteria bacterium clone CAL4 23S ribosomal RNA gene, partial sequence	blastn	53216	750	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
19136584	19136584	PRJDB9741_P_NODE_6636_length_243_cov_2.520619_g6319_i0	PRJDB9741	6636	243	2.520619	6.12510417	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	211	3.41e-50	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g6319	i0	82.642	128.390946502058	265	21	99	12	2	243	3298452	3298190	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	31199	211	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
21687605	21687605	PRJDB9741_P_NODE_39498_length_161_cov_1.133929_g39181_i0	PRJDB9741	39498	161	1.133929	1.82562569	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	156	9.91e-34	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g39181	i0	96.774	324.88198757764	93	3	58	0	1	93	3298416	3298324	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	52306	156	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
22962746	22962746	PRJDB9741_P_NODE_17259_length_183_cov_0.985075_g16942_i0	PRJDB9741	17259	183	0.985075	1.80268725	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	294	2.35e-75	NTclustered	gi\|2874253931\|emb\|OY970256.1\|	2283092	g16942	i0	95.628	56.7814207650273	183	8	100	0	1	183	360456	360274	MAG: Pyrinomonadaceae bacterium isolate MFD09212.bin.c.2 genome assembly, chromosome: 1	blastn	10391	294	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
24236671	24236671	PRJDB9741_P_NODE_10420_length_204_cov_1.716129_g10103_i0	PRJDB9741	10420	204	1.716129	3.50090316	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	283	5.8e-72	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g10103	i0	91.509	110.691176470588	212	9	100	5	1	204	715513	715723	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	22581	283	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
24236720	24236720	PRJDB9741_P_NODE_16140_length_184_cov_3.274074_g15823_i0	PRJDB9741	16140	184	3.274074	6.02429616	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	97.1	7.15e-16	NTclustered	gi\|2893358426\|emb\|OZ220718.1\|	2910147	g15823	i0	78.808	1.64673913043478	151	27	81	5	8	156	2119077	2118930	MAG: Vicinamibacterales bacterium isolate 0ce2d42f-2bf0-44bc-a671-070680eb922c genome assembly, chromosome: 1	blastn	303	97.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales		Vicinamibacterales 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);;