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

12 rows where analysis = "blastn", bioproject = "PRJNA432257" 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
429760	429760	PRJNA432257_S_NODE_47661_length_235_cov_3.752525_g47280_i0	PRJNA432257	47661	235	3.752525	8.81843375	Paludibaculum fermentans	1473598	Bacteria	Bacteria	161	3.3499999999999996e-35	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g47280	i0	79.31	0.987234042553191	232	46	98	2	4	234	8798736	8798506	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	232	161	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
2980997	2980997	PRJNA432257_S_NODE_92063_length_182_cov_41.937931_g91682_i0	PRJNA432257	92063	182	41.937931	76.32703442	Thermoanaerobaculum sp.	2510637	Bacteria	Bacteria	226	8.619999999999999e-55	NTclustered	gi\|2314712957\|dbj\|AP024672.1\|	2510637	g91682	i0	98.438	0.703296703296703	128	2	70	0	17	144	1312024	1311897	MAG: Thermoanaerobaculum sp. KatS3mg007 DNA, complete genome	blastn	128	226	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae	Thermoanaerobaculum	Thermoanaerobaculum sp.
4256197	4256197	PRJNA432257_S_NODE_15404_length_351_cov_186.742038_g15023_i0	PRJNA432257	15404	351	186.742038	655.46455338	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	370	8.06e-98	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g15023	i0	88.387	278.797720797721	310	33	88	3	7	314	317557	317249	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	97858	370	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
4257042	4257042	PRJNA432257_S_NODE_71264_length_202_cov_2.442424_g70883_i0	PRJNA432257	71264	202	2.442424	4.93369648	Geothrix oryzae	2927975	Bacteria	Bacteria	278	2.67e-70	NTclustered	gi\|2490888707\|dbj\|AP027079.1\|	2927975	g70883	i0	91.584	1	202	16	100	1	1	202	2945922	2946122	Geothrix oryzae Red222 DNA, complete genome	blastn	202	278	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix oryzae
6807122	6807122	PRJNA432257_S_NODE_25766_length_295_cov_1.883721_g25385_i0	PRJNA432257	25766	295	1.883721	5.55697695	uncultured Granulicella sp.	1241325	Bacteria	Bacteria	226	1.52e-54	NTclustered	gi\|2836016424\|emb\|OZ196154.1\|	1241325	g25385	i0	80.612	0.996610169491525	294	55	99	2	3	295	1168393	1168685	MAG: uncultured Granulicella sp. isolate 9057d4d9-b77b-4c6f-b84b-ea5519435b63 genome assembly, chromosome: 7	blastn	294	226	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	uncultured Granulicella sp.
8083607	8083607	PRJNA432257_S_NODE_91407_length_183_cov_2.034247_g91026_i0	PRJNA432257	91407	183	2.034247	3.72267201	uncultured Holophaga sp.	188475	Bacteria	Bacteria	150	5.37e-32	NTclustered	gi\|2621702213\|emb\|OY760195.1\|	188475	g91026	i0	83.951	54.0765027322404	162	20	86	4	7	163	4397	4237	MAG: uncultured Holophaga sp. isolate 19663c38-e6f5-42a8-8268-146037a524bf genome assembly, chromosome: 1	blastn	9896	150	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Holophaga	uncultured Holophaga sp.
17007194	17007194	PRJNA432257_S_NODE_61374_length_214_cov_2.683616_g60993_i0	PRJNA432257	61374	214	2.683616	5.74293824	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	178	2.98e-40	NTclustered	gi\|2874253744\|emb\|OY969603.1\|	171953	g60993	i0	82.16	7.83644859813084	213	33	98	5	6	214	3967268	3967057	MAG: uncultured Acidobacteriota bacterium isolate MFD01476.bin.c.1 genome assembly, chromosome: 1	blastn	1677	178	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19555782	19555782	PRJNA432257_S_NODE_58196_length_218_cov_17.044199_g57815_i0	PRJNA432257	58196	218	17.044199	37.15635382	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	99	2.44e-16	NTclustered	gi\|112980879\|gb\|DQ829683.1\|	171953	g57815	i0	80.597	8.1651376146789	134	21	61	4	1	132	487	357	Uncultured Acidobacteria bacterium clone DON28 23S ribosomal RNA gene, partial sequence	blastn	1780	99	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21490429	21490429	PRJNA432257_S_NODE_11977_length_383_cov_154.202312_g11604_i0	PRJNA432257	11977	383	154.202312	590.59485496	Terriglobia	204432	Bacteria	Bacteria	135	3.53e-27	NTclustered	gi\|2874253796\|emb\|OY969780.1\|	194844	g11604	i0	98.684	32.9660574412533	76	1	20	0	93	168	4340764	4340839	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1	blastn	12626	135	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
22106472	22106472	PRJNA432257_S_NODE_58058_length_218_cov_102.640884_g57677_i0	PRJNA432257	58058	218	102.640884	223.75712712	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	200	6.4999999999999985e-47	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g57677	i0	87.5	53.6926605504587	176	18	80	2	1	174	4554995	4555168	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	11705	200	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
23381187	23381187	PRJNA432257_S_NODE_10639_length_399_cov_26.563536_g10278_i0	PRJNA432257	10639	399	26.563536	105.98850864	Mesoterricola sediminis	2927980	Bacteria	Bacteria	60.2	2.28e-4	NTclustered	gi\|2490895851\|dbj\|AP027081.1\|	2927980	g10278	i0	91.111	0.270676691729323	45	3	11	1	167	210	4453831	4453787	Mesoterricola sediminis W786 DNA, complete genome	blastn	108	60.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Mesoterricola	Mesoterricola sediminis
24656374	24656374	PRJNA432257_S_NODE_71360_length_202_cov_1.890909_g70979_i0	PRJNA432257	71360	202	1.890909	3.81963618	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	268	1.5999999999999998e-67	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g70979	i0	99.324	105.648514851485	148	1	73	0	55	202	4358146	4357999	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	21341	268	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);;