metadata: contig_metadata: 5 rows where bioproject = "PRJNA939370", tax_phylum = "Acidobacteriota" and tax

5 rows where bioproject = "PRJNA939370", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

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
2531845	2531845	PRJNA939370_S_NODE_202_length_594_cov_3.286239_g156_i0	PRJNA939370	202	594	3.286239	19.52025966	Granulicella	940557	Bacteria	Bacteria	907	0	NTclustered	gi\|470487846\|ref\|NR_076839.1\|	940615	g156	i0	94.276	175.579124579125	594	32	99	2	3	594	1329	1922	Granulicella tundricola strain MP5ACTX9 23S ribosomal RNA gene, complete sequence	blastn	104294	907	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella tundricola
4743034	4743034	PRJNA939370_S_NODE_3264_length_161_cov_1.098214_g3212_i0	PRJNA939370	3264	161	1.098214	1.76812454	uncultured Granulicella sp.	1241325	Bacteria	Bacteria	250	4.42e-62	NTclustered	gi\|2626255659\|emb\|OY843766.1\|	1241325	g3212	i0	96.078	85.832298136646	153	6	95	0	9	161	3195313	3195161	MAG: uncultured Granulicella sp. isolate e6d70442-04f8-4699-a368-e2225de37168 genome assembly, chromosome: 1	blastn	13819	250	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	uncultured Granulicella sp.
21316759	21316759	PRJNA939370_S_NODE_877_length_309_cov_2.292308_g825_i0	PRJNA939370	877	309	2.292308	7.08323172	uncultured Granulicella sp.	1241325	Bacteria	Bacteria	455	1.88e-123	NTclustered	gi\|2836016418\|emb\|OZ196148.1\|	1241325	g825	i0	93.204	136.514563106796	309	21	100	0	1	309	506739	507047	MAG: uncultured Granulicella sp. isolate 9057d4d9-b77b-4c6f-b84b-ea5519435b63 genome assembly, chromosome: 1	blastn	42183	455	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	uncultured Granulicella sp.
21658416	21658416	PRJNA939370_S_NODE_2057_length_191_cov_0.830986_g2005_i0	PRJNA939370	2057	191	0.830986	1.58718326	Holophagaceae	574976	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|84452199\|emb\|AM180897.1\|	171953	g2005	i0	100	2.05235602094241	28	0	15	0	153	180	1057	1030	Uncultured Acidobacteria bacterium partial 23S rRNA gene, clone LS_LKC11_kan4	blastn	392	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
22591720	22591720	PRJNA939370_S_NODE_2598_length_171_cov_1.245902_g2546_i0	PRJNA939370	2598	171	1.245902	2.13049242	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	267	4.699999999999999e-67	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g2546	i0	94.737	139.789473684211	171	9	100	0	1	171	4733370	4733540	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	23904	267	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);;