metadata: contig_metadata: 18 rows where bioproject = "PRJNA546018" and tax

18 rows where bioproject = "PRJNA546018" 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
3062240	3062240	PRJNA546018_S_NODE_56503_length_203_cov_2.281690_g56178_i0	PRJNA546018	56503	203	2.28169	4.6318307	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	167	6.0599999999999995e-37	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g56178	i0	83.511	359.20197044335	188	21	88	5	25	203	634600	634414	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	72918	167	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
10714975	10714975	PRJNA546018_S_NODE_25509_length_315_cov_2.086614_g25184_i0	PRJNA546018	25509	315	2.086614	6.5728341	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	505	1.8799999999999995e-138	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g25184	i0	95.556	144.653968253968	315	14	100	0	1	315	2365681	2365995	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	45566	505	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13264639	13264639	PRJNA546018_S_NODE_24691_length_321_cov_2.134615_g24366_i0	PRJNA546018	24691	321	2.134615	6.85211415	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	470	7.02e-128	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g24366	i0	95.033	135.034267912773	302	10	93	5	2	299	3299477	3299177	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	43346	470	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
13265007	13265007	PRJNA546018_S_NODE_44151_length_230_cov_4.917160_g43826_i0	PRJNA546018	44151	230	4.91716	11.309468	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	239	1.47e-58	NTclustered	gi\|217038907\|gb\|EU810998.1\|	171953	g43826	i0	100	102.504347826087	129	0	56	0	1	129	129	1	Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence	blastn	23576	239	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14539404	14539404	PRJNA546018_S_NODE_10972_length_518_cov_14.645514_g10649_i0	PRJNA546018	10972	518	14.645514	75.86376252	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	597	5.1999999999999986e-166	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g10649	i0	88.462	252.552123552124	494	57	95	0	1	494	494	1	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	130822	597	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15813436	15813436	PRJNA546018_S_NODE_14973_length_429_cov_6.244565_g14648_i0	PRJNA546018	14973	429	6.244565	26.78918385	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	79.7	3.7e-15	NR	HJU55860.1	2283092	g14648	i0	37.6	0.818181818181818	117	67	77.6	1	405	73	77	193	HJU55860.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	351	79.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
18362392	18362392	PRJNA546018_S_NODE_24735_length_321_cov_1.261538_g24410_i0	PRJNA546018	24735	321	1.261538	4.04953698	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	150	1.33e-40	NR	HXT72181.1	2910147	g24410	i0	78.2	0.94392523364486	101	22	94.4	0	12	314	55	155	HXT72181.1 ATP-binding protein [Vicinamibacterales bacterium]	diamond	303	150	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
20913116	20913116	PRJNA546018_S_NODE_4017_length_922_cov_8.210221_g3803_i0	PRJNA546018	4017	922	8.210221	75.69823762	Terriglobus roseus	392734	Bacteria	Bacteria	1531	0	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g3803	i0	97.961	99.3937093275488	883	18	96	0	17	899	2078313	2077431	Terriglobus roseus DSM 18391, complete genome	blastn	91641	1531	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
22187511	22187511	PRJNA546018_S_NODE_1698_length_1420_cov_2.263429_g1559_i0	PRJNA546018	1698	1420	2.263429	32.1406918	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	471	1.6099999999999996e-153	NR	HEX2460229.1	2910147	g1559	i0	80.3	0.665492957746479	315	61	66.3	1	1195	254	1	315	HEX2460229.1 protein kinase [Vicinamibacterales bacterium]	diamond	945	471	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
27140764	27140764	PRJNA546018_S_NODE_40522_length_242_cov_2.480663_g40197_i0	PRJNA546018	40522	242	2.480663	6.00320446	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	73.2	1.62e-13	NR	HVH29626.1	2910147	g40197	i0	51.4	7.22727272727273	70	34	86.8	0	213	4	31	100	HVH29626.1 response regulator [Vicinamibacterales bacterium]	diamond	1749	73.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
27520266	27520266	PRJNA546018_S_NODE_55223_length_205_cov_1.805556_g54898_i0	PRJNA546018	55223	205	1.805556	3.7013898	Terriglobales bacterium	2282142	Bacteria	Bacteria	120	2.24e-30	NR	HZS98367.1	2282142	g54898	i0	87.9	1.93170731707317	66	8	96.6	0	8	205	217	282	HZS98367.1 metallophosphoesterase [Terriglobales bacterium]	diamond	396	120	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales bacterium
27551630	27551630	PRJNA546018_S_NODE_19364_length_369_cov_2.081169_g19039_i0	PRJNA546018	19364	369	2.081169	7.67951361	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	81.3	4.19e-15	NR	MBS1877142.1	1978231	g19039	i0	78.7	1.91056910569106	47	10	38.2	0	357	217	383	429	MBS1877142.1 ribosome biogenesis GTPase Der [Acidobacteriota bacterium]	diamond	705	81.3	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27835892	27835892	PRJNA546018_S_NODE_36824_length_255_cov_2.293814_g36499_i0	PRJNA546018	36824	255	2.293814	5.8492257	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	103	1.6099999999999997e-24	NR	MCD9185946.1	2283092	g36499	i0	79.1	0.788235294117647	67	14	78.8	0	246	46	236	302	MCD9185946.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	201	103	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
29540903	29540903	PRJNA546018_S_NODE_47430_length_221_cov_1.525000_g47105_i0	PRJNA546018	47430	221	1.525	3.37025	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	129	1.3199999999999998e-32	NR	MCD9185977.1	2283092	g47105	i0	98.4	0.828054298642534	61	1	82.8	0	11	193	708	768	MCD9185977.1 BamA/TamA family outer membrane protein [Pyrinomonadaceae bacterium]	diamond	183	129	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
29776753	29776753	PRJNA546018_S_NODE_21271_length_349_cov_9.270833_g20946_i0	PRJNA546018	21271	349	9.270833	32.35520717	Bacteria	2	Bacteria	Bacteria	108	4.03e-27	NR	MCU1288629.1	1978231	g20946	i0	71	2.69054441260745	62	18	53.3	0	327	142	115	176	MCU1288629.1 spermine/spermidine N-acetyltransferase [Acidobacteriota bacterium]	diamond	939	109	0.990825688073395	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31388503	31388503	PRJNA546018_S_NODE_52636_length_209_cov_1.506757_g52311_i0	PRJNA546018	52636	209	1.506757	3.14912213	Bacteria	2	Bacteria	Bacteria	81.3	2.58e-18	NR	MBZ5678364.1	2081523	g52311	i0	86.7	3.22966507177033	45	6	64.6	0	73	207	1	45	MBZ5678364.1 DUF378 domain-containing protein [Terriglobia bacterium]	diamond	675	81.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
32480934	32480934	PRJNA546018_S_NODE_29179_length_291_cov_3.886957_g28854_i0	PRJNA546018	29179	291	3.886957	11.31104487	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	83.2	7.47e-18	NR	HEY3738940.1	2212468	g28854	i0	73.5	0.505154639175258	49	13	50.5	0	128	274	1	49	HEY3738940.1 NUDIX hydrolase [Bryobacteraceae bacterium]	diamond	147	83.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
32701463	32701463	PRJNA546018_S_NODE_29360_length_290_cov_3.886463_g29035_i0	PRJNA546018	29360	290	3.886463	11.2707427	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	42.7	0.0449	NR	MFL6197426.1	2651171	g29035	i0	32.8	0.693103448275862	67	43	67.2	1	257	63	52	118	MFL6197426.1 hypothetical protein [Thermoanaerobaculia bacterium]	diamond	201	42.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia 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);;