metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA356682" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA356682" 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
397281	397281	PRJNA356682_P_NODE_13701_length_381_cov_5.240260_g13011_i0	PRJNA356682	13701	381	5.24026	19.9653906	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	315	4.2e-81	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g13011	i0	82.667	2.37007874015748	375	46	96	16	13	379	4472501	4472138	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	903	315	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1671954	1671954	PRJNA356682_P_NODE_14262_length_374_cov_6.528239_g13572_i0	PRJNA356682	14262	374	6.528239	24.41561386	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	503	8.169999999999998e-138	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g13572	i0	91.176	3.59090909090909	374	27	100	6	1	374	4472502	4472135	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	1343	503	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
2947893	2947893	PRJNA356682_P_NODE_14463_length_372_cov_1.478261_g13773_i0	PRJNA356682	14463	372	1.478261	5.49913092	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	520	8.069999999999999e-143	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g13773	i0	92.371	3.35215053763441	367	25	99	3	4	370	4472504	4472141	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	1247	520	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
2948098	2948098	PRJNA356682_P_NODE_24923_length_293_cov_2.209091_g24232_i0	PRJNA356682	24923	293	2.209091	6.47263663	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	243	1.5e-59	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g24232	i0	81.695	4.60068259385666	295	50	100	4	1	293	4229820	4230112	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	1348	243	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4224600	4224600	PRJNA356682_P_NODE_20824_length_317_cov_1.663934_g20133_i0	PRJNA356682	20824	317	1.663934	5.27467078	Luteitalea pratensis	1855912	Bacteria	Bacteria	520	6.769999999999999e-143	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g20133	i0	96.215	131.946372239748	317	12	100	0	1	317	654760	654444	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	41827	520	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
10601105	10601105	PRJNA356682_P_NODE_18729_length_332_cov_1.181467_g18038_i0	PRJNA356682	18729	332	1.181467	3.92247044	Terriglobus saanensis	870903	Bacteria	Bacteria	147	1.39e-30	NTclustered	gi\|319923767\|gb\|CP002467.1\|	401053	g18038	i0	87.597	37.5993975903614	129	13	39	3	93	220	4858498	4858624	Terriglobus saanensis SP1PR4, complete genome	blastn	12483	147	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus saanensis
12550773	12550773	PRJNA356682_P_NODE_24130_length_297_cov_5.321429_g23439_i0	PRJNA356682	24130	297	5.321429	15.80464413	Bacteria	2	Bacteria	Bacteria	200	9.309999999999998e-47	NTclustered	gi\|76574296\|gb\|DQ139444.1\|	171953	g23439	i0	81.176	140.026936026936	255	43	85	4	37	288	275	23	Uncultured Acidobacteria bacterium clone CAL5 23S ribosomal RNA gene, partial sequence	blastn	41588	202	0.99009900990099	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13151004	13151004	PRJNA356682_P_NODE_17371_length_343_cov_1.122222_g16680_i0	PRJNA356682	17371	343	1.122222	3.84922146	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	392	1.68e-104	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g16680	i0	88.06	2.35860058309038	335	34	97	6	10	343	4472463	4472134	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	809	392	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14426050	14426050	PRJNA356682_P_NODE_14352_length_373_cov_3.876667_g13662_i0	PRJNA356682	14352	373	3.876667	14.45996791	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	418	3.039999999999999e-112	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g13662	i0	87.366	1.19034852546917	372	37	99	8	1	369	4472133	4472497	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	444	418	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
16974602	16974602	PRJNA356682_P_NODE_12054_length_404_cov_4.619335_g11364_i0	PRJNA356682	12054	404	4.619335	18.6621134	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	440	7.079999999999997e-119	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g11364	i0	88.41	2.27475247524752	371	36	92	7	35	404	4472498	4472134	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	919	440	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18249381	18249381	PRJNA356682_P_NODE_37075_length_250_cov_0.870056_g36384_i0	PRJNA356682	37075	250	0.870056	2.17514	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	195	3.55e-45	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g36384	i0	81.102	1.016	254	38	99	9	2	250	372067	372315	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	254	195	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
24623594	24623594	PRJNA356682_P_NODE_21480_length_313_cov_1.095833_g20789_i0	PRJNA356682	21480	313	1.095833	3.42995729	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	496	1.1299999999999999e-135	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g20789	i0	95.498	104.335463258786	311	12	99	2	4	313	641295	640986	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	32657	496	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22

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