metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA330616" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA330616" 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_species
1069366	1069366	PRJNA330616_P_NODE_23321_length_175_cov_1.365079_g22912_i0	PRJNA330616	23321	175	1.365079	2.38888825	Pseudomonadati	3379134	Bacteria	Bacteria	122	1.1099999999999999e-23	NTclustered	gi\|2621701418\|emb\|OY760136.1\|	2910147	g22912	i0	79.885	27.6971428571429	174	29	98	6	1	171	1699524	1699354	MAG: Vicinamibacterales bacterium isolate f9e760c9-8bbe-4e76-9a0a-40d6f1fb97b8 genome assembly, chromosome: 1	blastn	4847	122	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacterales bacterium
1664537	1664537	PRJNA330616_P_NODE_5542_length_357_cov_1.902597_g5133_i0	PRJNA330616	5542	357	1.902597	6.79227129	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	462	1.32e-125	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g5133	i0	90.028	107.137254901961	361	31	100	4	1	357	3300016	3299657	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	38248	462	1	Bacteria	Pseudomonadati	Acidobacteriota			Acidobacteriota bacterium
2940347	2940347	PRJNA330616_P_NODE_23723_length_173_cov_2.411290_g23314_i0	PRJNA330616	23723	173	2.41129	4.1715317	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	222	1.05e-53	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g23314	i0	90.173	90.757225433526	173	14	100	3	1	173	3298705	3298874	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	15701	222	1	Bacteria	Pseudomonadati	Acidobacteriota			Acidobacteriota bacterium
11868438	11868438	PRJNA330616_P_NODE_30690_length_162_cov_1.398230_g30281_i0	PRJNA330616	30690	162	1.39823	2.2651326	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	215	1.62e-51	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g30281	i0	92.667	67.3641975308642	150	10	92	1	1	149	317262	317411	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	10913	215	1	Bacteria	Pseudomonadati	Acidobacteriota			Acidobacteriota bacterium
16967232	16967232	PRJNA330616_P_NODE_7094_length_313_cov_1.488636_g6685_i0	PRJNA330616	7094	313	1.488636	4.65943068	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	193	1.65e-44	NTclustered	gi\|2621701418\|emb\|OY760136.1\|	2910147	g6685	i0	80.224	72.6932907348243	268	43	84	10	50	313	1699525	1699264	MAG: Vicinamibacterales bacterium isolate f9e760c9-8bbe-4e76-9a0a-40d6f1fb97b8 genome assembly, chromosome: 1	blastn	22753	193	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacterales bacterium
19515668	19515668	PRJNA330616_P_NODE_31276_length_162_cov_0.902655_g30867_i0	PRJNA330616	31276	162	0.902655	1.4623011	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	147	6.009999999999999e-31	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g30867	i0	85.714	5.09259259259259	140	18	86	2	24	162	2282265	2282127	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	825	147	1	Bacteria	Pseudomonadati	Acidobacteriota			uncultured Acidobacteriota bacterium
19515735	19515735	PRJNA330616_P_NODE_6576_length_326_cov_1.018051_g6167_i0	PRJNA330616	6576	326	1.018051	3.31884626	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	357	5.8e-94	NTclustered	gi\|217038907\|gb\|EU810998.1\|	171953	g6167	i0	93.361	220.69018404908	241	16	74	0	86	326	1	241	Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence	blastn	71945	357	1	Bacteria	Pseudomonadati	Acidobacteriota			uncultured Acidobacteriota bacterium
24615599	24615599	PRJNA330616_P_NODE_11220_length_247_cov_1.262626_g10811_i0	PRJNA330616	11220	247	1.262626	3.11868622	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	265	2.63e-66	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g10811	i0	86	163.514170040486	250	32	100	2	1	247	4233619	4233868	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	40388	265	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);;