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

12 rows where analysis = "blastn", bioproject = "PRJNA498309" 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
481633	481633	PRJNA498309_P_NODE_98941_length_196_cov_6.528302_g96792_i0	PRJNA498309	98941	196	6.528302	12.79547192	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	200	5.719999999999998e-47	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g96792	i0	94.615	142.091836734694	130	6	66	1	47	175	1822542	1822671	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	27850	200	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
1755531	1755531	PRJNA498309_P_NODE_27582_length_545_cov_4.574803_g25619_i0	PRJNA498309	27582	545	4.574803	24.93267635	uncultured Holophaga sp.	188475	Bacteria	Bacteria	219	4.989999999999999e-52	NTclustered	gi\|2621785467\|emb\|OY781925.1\|	188475	g25619	i0	85.308	0.612844036697248	211	31	39	0	198	408	2219995	2220205	MAG: uncultured Holophaga sp. isolate 48fd71e5-2ffc-43bf-b6f5-ca4e00a42c30 genome assembly, chromosome: 1	blastn	334	219	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Holophaga	uncultured Holophaga sp.
1756529	1756529	PRJNA498309_P_NODE_86682_length_229_cov_21.484375_g84533_i0	PRJNA498309	86682	229	21.484375	49.19921875	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	250	6.75e-62	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g84533	i0	89.394	16.5676855895197	198	21	86	0	2	199	3298459	3298262	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	3794	250	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
1757056	1757056	PRJNA498309_S_NODE_21162_length_434_cov_4.220551_g17954_i1	PRJNA498309	21162	434	4.220551	18.31719134	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	717	0	NTclustered	gi\|76574296\|gb\|DQ139444.1\|	171953	g17954	i1	97.387	100.108294930876	421	11	97	0	14	434	1046	626	Uncultured Acidobacteria bacterium clone CAL5 23S ribosomal RNA gene, partial sequence	blastn	43447	717	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1757475	1757475	PRJNA498309_S_NODE_40602_length_209_cov_3.275862_g38434_i0	PRJNA498309	40602	209	3.275862	6.84655158	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	281	2.15e-71	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g38434	i0	93.651	58.511961722488	189	11	90	1	21	209	1822024	1821837	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	12229	281	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
5585908	5585908	PRJNA498309_S_NODE_32465_length_273_cov_309.424370_g30297_i0	PRJNA498309	32465	273	309.42437	844.7285301	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	350	7.94e-92	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g30297	i0	94.69	80.7069597069597	226	10	82	1	26	249	2908093	2907868	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	22033	350	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
10684898	10684898	PRJNA498309_P_NODE_68369_length_292_cov_1.976471_g66220_i0	PRJNA498309	68369	292	1.976471	5.77129532	Luteitalea pratensis	1855912	Bacteria	Bacteria	239	1.94e-58	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g66220	i0	88.06	0.688356164383562	201	24	69	0	91	291	1994580	1994780	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	201	239	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
15785060	15785060	PRJNA498309_S_NODE_40913_length_207_cov_9.453488_g38745_i0	PRJNA498309	40913	207	9.453488	19.56872016	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	377	2.63e-100	NTclustered	gi\|430803044\|gb\|KC011153.1\|	171953	g38745	i0	99.519	100.492753623188	208	0	100	1	1	207	486	693	Uncultured Acidobacteria bacterium clone bsc54 16S ribosomal RNA gene, partial sequence	blastn	20802	377	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19607049	19607049	PRJNA498309_P_NODE_62776_length_315_cov_4.388489_g60628_i0	PRJNA498309	62776	315	4.388489	13.82374035	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	339	2.02e-88	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g60628	i0	88.421	323.422222222222	285	28	90	4	11	292	3298459	3298177	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	101878	339	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
19607396	19607396	PRJNA498309_P_NODE_85736_length_232_cov_3.830769_g83587_i0	PRJNA498309	85736	232	3.830769	8.88738408	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	322	1.43e-83	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g83587	i0	94.313	93.8362068965517	211	11	91	1	1	211	4355825	4355616	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	21770	322	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19608662	19608662	PRJNA498309_S_NODE_7736_length_967_cov_125.156652_g6151_i0	PRJNA498309	7736	967	125.156652	1210.26482484	Luteitalea pratensis	1855912	Bacteria	Bacteria	1003	0	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g6151	i0	91.417	0.886246122026887	734	60	76	1	24	754	1995313	1994580	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	857	1003	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
23434398	23434398	PRJNA498309_S_NODE_20059_length_456_cov_150.080760_g17954_i0	PRJNA498309	20059	456	150.08076	684.3682656	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	747	0	NTclustered	gi\|76574296\|gb\|DQ139444.1\|	171953	g17954	i0	98.807	93.9078947368421	419	5	92	0	38	456	1044	626	Uncultured Acidobacteria bacterium clone CAL5 23S ribosomal RNA gene, partial sequence	blastn	42822	747	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);;