metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJEB75017" and tax

7 rows where analysis = "blastn", bioproject = "PRJEB75017" 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
2685432	2685432	PRJEB75017_P_NODE_17983_length_243_cov_0.917647_g17854_i0	PRJEB75017	17983	243	0.917647	2.22988221	Luteitalea pratensis	1855912	Bacteria	Bacteria	267	7.19e-67	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g17854	i0	86.42	1	243	33	100	0	1	243	13555	13797	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	243	267	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
3961415	3961415	PRJEB75017_P_NODE_12284_length_266_cov_2.088083_g12155_i0	PRJEB75017	12284	266	2.088083	5.55430078	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2575803519\|emb\|OY729431.1\|	2793154	g12155	i0	100	0.105263157894737	28	0	11	0	212	239	1215768	1215741	MAG: Vicinamibacteria bacterium isolate 6b1ebb23-bf14-4213-9fd5-2478dc99539b genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria				Vicinamibacteria bacterium
7787691	7787691	PRJEB75017_P_NODE_12467_length_265_cov_1.192708_g12338_i0	PRJEB75017	12467	265	1.192708	3.1606762	uncultured Bryobacterales bacterium	2569091	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2546137838\|emb\|OY282420.1\|	2569091	g12338	i0	92.308	0.147169811320755	39	1	14	2	170	207	598062	598025	MAG: uncultured Bryobacterales bacterium isolate 78526416-339a-45b8-a6d3-8fabb82c2801 genome assembly, chromosome: 1	blastn	39	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			uncultured Bryobacterales bacterium
10338382	10338382	PRJEB75017_P_NODE_14469_length_252_cov_0.871508_g14340_i0	PRJEB75017	14469	252	0.871508	2.19620016	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	250	7.55e-62	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g14340	i0	86.996	0.884920634920635	223	27	88	2	1	222	3845695	3845916	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	223	250	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
14163776	14163776	PRJEB75017_P_NODE_2252_length_581_cov_1.911417_g2124_i0	PRJEB75017	2252	581	1.911417	11.10533277	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	174	1.17e-38	NTclustered	gi\|2893358426\|emb\|OZ220718.1\|	2910147	g2124	i0	79.31	0.932874354561102	261	44	44	10	326	581	1182312	1182567	MAG: Vicinamibacterales bacterium isolate 0ce2d42f-2bf0-44bc-a671-070680eb922c genome assembly, chromosome: 1	blastn	542	174	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
15437799	15437799	PRJEB75017_P_NODE_11373_length_275_cov_2.178218_g11244_i0	PRJEB75017	11373	275	2.178218	5.9900995	Luteitalea pratensis	1855912	Bacteria	Bacteria	224	5.059999999999999e-54	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g11244	i0	81.655	1.01090909090909	278	44	99	7	1	273	2637522	2637247	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	278	224	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
21812106	21812106	PRJEB75017_P_NODE_15698_length_248_cov_1.531429_g15569_i0	PRJEB75017	15698	248	1.531429	3.79794392	Luteitalea pratensis	1855912	Bacteria	Bacteria	339	1.5399999999999998e-88	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g15569	i0	91.463	0.991935483870968	246	21	99	0	1	246	2563683	2563928	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	246	339	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis

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);;