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

9 rows where analysis = "blastn", bioproject = "PRJNA934472" 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
3461771	3461771	PRJNA934472_P_NODE_21323_length_316_cov_1.444444_g20946_i0	PRJNA934472	21323	316	1.444444	4.56444304	Terriglobia bacterium	2081523	Bacteria	Bacteria	401	2.5499999999999992e-107	NTclustered	gi\|2874253792\|emb\|OY969776.1\|	2081523	g20946	i0	89.655	97.8481012658228	319	27	100	5	1	316	34133	34448	MAG: Terriglobia bacterium isolate MFD00008.bin.1.63 genome assembly, chromosome: 1	blastn	30920	401	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia			Terriglobia bacterium
3461902	3461902	PRJNA934472_P_NODE_27243_length_283_cov_1.319048_g26865_i0	PRJNA934472	27243	283	1.319048	3.73290584	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	196	1.14e-45	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g26865	i0	79.298	7.58657243816254	285	55	100	4	1	283	2322150	2321868	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	2147	196	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia			Thermoanaerobaculia bacterium
8564241	8564241	PRJNA934472_P_NODE_40027_length_227_cov_3.500000_g39649_i0	PRJNA934472	40027	227	3.5	7.945	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	375	1.06e-99	NTclustered	gi\|112980855\|gb\|DQ829659.1\|	171953	g39649	i0	96.46	115.392070484581	226	8	99	0	2	227	927	702	Uncultured Acidobacteria bacterium clone DON16 23S ribosomal RNA gene, partial sequence	blastn	26194	375	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
11114638	11114638	PRJNA934472_P_NODE_27169_length_283_cov_2.052381_g26791_i0	PRJNA934472	27169	283	2.052381	5.80823823	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	110	1.53e-19	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g26791	i0	75.686	28.9187279151943	255	43	86	14	1	243	3918069	3917822	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	8184	110	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
11114857	11114857	PRJNA934472_P_NODE_36769_length_246_cov_2.780347_g36391_i0	PRJNA934472	36769	246	2.780347	6.83965362	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	159	1.27e-34	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g36391	i0	81.443	0.788617886178862	194	36	79	0	52	245	1816724	1816917	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	194	159	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
13664701	13664701	PRJNA934472_P_NODE_32791_length_260_cov_1.192513_g32413_i0	PRJNA934472	32791	260	1.192513	3.1005338	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	436	5.600000000000001e-118	NTclustered	gi\|112980860\|gb\|DQ829664.1\|	171953	g32413	i0	96.923	104.169230769231	260	8	100	0	1	260	738	997	Uncultured Acidobacteria bacterium clone DON1 23S ribosomal RNA gene, partial sequence	blastn	27084	436	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
18762913	18762913	PRJNA934472_P_NODE_38255_length_242_cov_3.278107_g37877_i0	PRJNA934472	38255	242	3.278107	7.93301894	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	331	2.5e-86	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g37877	i0	91.358	677.198347107438	243	20	100	1	1	242	4733456	4733214	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	163882	331	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
20037996	20037996	PRJNA934472_P_NODE_8436_length_486_cov_2.629540_g8059_i0	PRJNA934472	8436	486	2.62954	12.7795644	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	713	0	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g8059	i0	93.224	133.308641975309	487	29	100	4	1	486	11663	12146	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	64788	713	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
23863638	23863638	PRJNA934472_P_NODE_6519_length_546_cov_3.319239_g6206_i0	PRJNA934472	6519	546	3.319239	18.12304494	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	636	1.17e-177	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g6206	i0	88.598	90.3901098901099	535	45	96	11	21	545	3557732	3558260	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	49353	636	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Bryobacteraceae 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);;