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

12 rows where analysis = "blastn", bioproject = "PRJNA1036688" 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
169635	169635	PRJNA1036688_P_NODE_2061_length_487_cov_5.811111_g1774_i0	PRJNA1036688	2061	487	5.811111	28.30011057	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	702	0	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g1774	i0	92.961	129.932238193018	483	33	99	1	5	487	716205	715724	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	63277	702	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1008067	1008067	PRJNA1036688_P_NODE_1061_length_685_cov_28.274691_g823_i0	PRJNA1036688	1061	685	28.274691	193.68163335	Granulicella	940557	Bacteria	Bacteria	1206	0	NTclustered	gi\|2626255659\|emb\|OY843766.1\|	1241325	g823	i0	98.676	106.937226277372	680	9	99	0	6	685	3194361	3195040	MAG: uncultured Granulicella sp. isolate e6d70442-04f8-4699-a368-e2225de37168 genome assembly, chromosome: 1	blastn	73252	1206	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	uncultured Granulicella sp.
4836123	4836123	PRJNA1036688_P_NODE_1464_length_585_cov_6.941606_g1193_i0	PRJNA1036688	1464	585	6.941606	40.6083951	Bacteria	2	Bacteria	Bacteria	876	0	NTclustered	gi\|1015624362\|gb\|AH012920.2\|	171953	g1193	i0	93.592	104.873504273504	593	29	100	3	1	585	31128	30537	Uncultured Acidobacteria bacterium clone 46h5 hypothetical protein, putative O-linked GlcNAc transferase, putative two-component response regulator, hypothetical protein, putative penicillin-resistance DD-carboxypeptidase, putative glycosyl transferase, hypothetical protein, conserved hypothetical protein, hypothetical protein, putative MaoC family dehydratase, putative D-3-phosphoglycerate dehydrogenase, putative magnesium and cobalt transport protein, putative phosphatidyl-glycerophosphatase, putative 2-methylthioadenine synthetase, hypothetical protein, putative glutamine cyclotransferase, and hypothetical protein genes, complete cds; 5S ribosomal RNA, 23S ribosomal RNA, tRNA-Ala, tRNA-Met, tRNA-Ile, and 16S ribosomal RNA genes, complete sequence; and hypothetical protein genes, complete cds	blastn	61351	876	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6547704	6547704	PRJNA1036688_P_NODE_4246_length_304_cov_3.715356_g3954_i0	PRJNA1036688	4246	304	3.715356	11.29468224	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	503	6.51e-138	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g3954	i0	96.417	99.7335526315789	307	7	100	3	1	304	318084	317779	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	30319	503	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
6547743	6547743	PRJNA1036688_P_NODE_9346_length_177_cov_1.392857_g9054_i0	PRJNA1036688	9346	177	1.392857	2.46535689	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	165	1.84e-36	NTclustered	gi\|2874254005\|emb\|OY970330.1\|	2699758	g9054	i0	83.616	112.463276836158	177	27	99	2	1	175	4575220	4575044	MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1	blastn	19906	165	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
7822289	7822289	PRJNA1036688_P_NODE_5927_length_242_cov_1.126829_g5635_i0	PRJNA1036688	5927	242	1.126829	2.72692618	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	220	5.65e-53	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g5635	i0	83.197	3.05785123966942	244	38	100	2	1	242	4840459	4840701	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	740	220	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9097272	9097272	PRJNA1036688_P_NODE_688_length_869_cov_15.455529_g487_i0	PRJNA1036688	688	869	15.455529	134.30854701	uncultured Granulicella sp.	1241325	Bacteria	Bacteria	894	0	NTclustered	gi\|2836016418\|emb\|OZ196148.1\|	1241325	g487	i0	85.617	121.413118527043	883	91	99	25	6	869	506238	507103	MAG: uncultured Granulicella sp. isolate 9057d4d9-b77b-4c6f-b84b-ea5519435b63 genome assembly, chromosome: 1	blastn	105508	894	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	uncultured Granulicella sp.
18021537	18021537	PRJNA1036688_P_NODE_5195_length_266_cov_2.000000_g4903_i0	PRJNA1036688	5195	266	2	5.32	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	405	1.62e-108	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g4903	i0	94.318	99.2669172932331	264	15	99	0	3	266	2972175	2972438	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	26405	405	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
23121926	23121926	PRJNA1036688_P_NODE_3759_length_332_cov_3.064407_g3468_i0	PRJNA1036688	3759	332	3.064407	10.17383124	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	315	3.61e-81	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g3468	i0	88.716	73	257	29	77	0	76	332	3559060	3559316	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	24236	315	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
24395701	24395701	PRJNA1036688_P_NODE_2140_length_476_cov_3.603645_g1851_i0	PRJNA1036688	2140	476	3.603645	17.1533502	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	592	2.2099999999999998e-164	NTclustered	gi\|217038907\|gb\|EU810998.1\|	171953	g1851	i0	99.387	410.365546218487	326	2	68	0	1	326	326	1	Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence	blastn	195334	592	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24395705	24395705	PRJNA1036688_P_NODE_2480_length_436_cov_14.288221_g2191_i0	PRJNA1036688	2480	436	14.288221	62.29664356	uncultured Granulicella sp.	1241325	Bacteria	Bacteria	712	0	NTclustered	gi\|2836016418\|emb\|OZ196148.1\|	1241325	g2191	i0	96.101	146.325688073395	436	17	100	0	1	436	505579	506014	MAG: uncultured Granulicella sp. isolate 9057d4d9-b77b-4c6f-b84b-ea5519435b63 genome assembly, chromosome: 1	blastn	63798	712	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	uncultured Granulicella sp.
25234302	25234302	PRJNA1036688_P_NODE_12260_length_150_cov_1.840708_g11968_i0	PRJNA1036688	12260	150	1.840708	2.761062	Luteitalea	2004797	Bacteria	Bacteria	244	1.88e-60	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g11968	i0	96.026	272.713333333333	151	4	100	2	1	150	654614	654763	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	40907	244	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis

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