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

9 rows where analysis = "blastn", bioproject = "PRJNA494251" 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
1750161	1750161	PRJNA494251_P_NODE_21882_length_306_cov_2.133047_g21568_i0	PRJNA494251	21882	306	2.133047	6.52712382	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	161	4.5399999999999994e-35	NTclustered	gi\|2621701418\|emb\|OY760136.1\|	2910147	g21568	i0	80.645	134.153594771242	217	35	70	7	89	302	1699525	1699313	MAG: Vicinamibacterales bacterium isolate f9e760c9-8bbe-4e76-9a0a-40d6f1fb97b8 genome assembly, chromosome: 1	blastn	41051	161	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
4302136	4302136	PRJNA494251_P_NODE_23584_length_297_cov_3.531250_g23270_i0	PRJNA494251	23584	297	3.53125	10.4878125	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	366	8.68e-97	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g23270	i0	88.963	643.892255892256	299	30	100	3	1	297	4233656	4233953	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	191236	366	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
11953800	11953800	PRJNA494251_P_NODE_10330_length_417_cov_2.133721_g10024_i0	PRJNA494251	10330	417	2.133721	8.89761657	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	198	4.87e-46	NTclustered	gi\|2891482070\|emb\|OZ219815.1\|	2793154	g10024	i0	88.166	6.46762589928058	169	16	40	4	124	290	462289	462123	MAG: Vicinamibacteria bacterium isolate 9f2a63bf-6400-4679-989b-6d6b125ab8ea genome assembly, chromosome: 1	blastn	2697	198	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria				Vicinamibacteria bacterium
11953807	11953807	PRJNA494251_P_NODE_10790_length_409_cov_3.681548_g10484_i0	PRJNA494251	10790	409	3.681548	15.05753132	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	438	2.5799999999999998e-118	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g10484	i0	87.76	191.508557457213	384	35	92	11	32	409	715852	716229	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	78327	438	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
11954379	11954379	PRJNA494251_S_NODE_210_length_440_cov_5.422343_g195_i0	PRJNA494251	210	440	5.422343	23.8583092	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	486	9.839999999999999e-133	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g195	i0	87.324	112.454545454545	426	52	97	2	16	440	1	425	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	49480	486	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14504007	14504007	PRJNA494251_P_NODE_2532_length_762_cov_1.404935_g2272_i0	PRJNA494251	2532	762	1.404935	10.7056047	Granulicella tundricola	940615	Bacteria	Bacteria	62.1	1.27e-4	NTclustered	gi\|321161386\|gb\|CP002480.1\|	1198114	g2272	i0	97.222	4.20997375328084	36	1	5	0	363	398	1030229	1030194	Granulicella tundricola MP5ACTX9, complete genome	blastn	3208	62.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella tundricola
14504153	14504153	PRJNA494251_P_NODE_37632_length_251_cov_0.786517_g37318_i0	PRJNA494251	37632	251	0.786517	1.97415767	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	425	1.16e-114	NTclustered	gi\|2874253959\|emb\|OY970284.1\|	2651171	g37318	i0	97.211	228.577689243028	251	7	100	0	1	251	6633002	6633252	MAG: Thermoanaerobaculia bacterium isolate MFD05513.bin.1.42 genome assembly, chromosome: 1	blastn	57373	425	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
14504286	14504286	PRJNA494251_P_NODE_51072_length_233_cov_2.093750_g50758_i0	PRJNA494251	51072	233	2.09375	4.8784375	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	418	1.7799999999999995e-112	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g50758	i0	99.138	334.768240343348	232	2	99	0	1	232	641610	641841	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	78001	418	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
19601363	19601363	PRJNA494251_P_NODE_41216_length_247_cov_2.879310_g40902_i0	PRJNA494251	41216	247	2.87931	7.1118957	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	211	3.48e-50	NTclustered	gi\|112980863\|gb\|DQ829667.1\|	171953	g40902	i0	86.364	73.8825910931174	198	22	79	5	2	197	206	12	Uncultured Acidobacteria bacterium clone DON17 23S ribosomal RNA gene, partial sequence	blastn	18249	211	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);;