metadata: contig_metadata: 10 rows where bioproject = "PRJEB28062" and tax

10 rows where bioproject = "PRJEB28062" and tax_phylum = "Ignavibacteriota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
8951877	8951877	PRJEB28062_P_NODE_47788_length_518_cov_22.346067_g45442_i0	PRJEB28062	47788	518	22.346067	115.75262706	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	121	1.37e-22	NTclustered	gi\|2621700951\|emb\|OY759785.1\|	2651163	g45442	i0	94.872	19.3474903474903	78	3	15	1	65	142	3637535	3637459	MAG: Ignavibacteriaceae bacterium isolate e3da2468-0b18-4b5b-bfd4-73ebec91e4fc genome assembly, chromosome: 1	blastn	10022	121	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae bacterium
8952719	8952719	PRJEB28062_P_NODE_89028_length_348_cov_2.385455_g86666_i0	PRJEB28062	89028	348	2.385455	8.3013834	Ignavibacterium sp.	2651167	Bacteria	Bacteria	116	2.8e-28	NR	MDT3695740.1	2651167	g86666	i0	78.1	1.6551724137931	64	14	55.2	0	214	23	293	356	MDT3695740.1 T9SS type A sorting domain-containing protein [Ignavibacterium sp.]	diamond	576	116	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacterium	Ignavibacterium sp.
10227494	10227494	PRJEB28062_P_NODE_41189_length_565_cov_50.695122_g38855_i0	PRJEB28062	41189	565	50.695122	286.4274393	Ignavibacterium sp.	2651167	Bacteria	Bacteria	898	0	NTclustered	gi\|2314740639\|dbj\|AP026678.1\|	2651167	g38855	i0	97.18	92.4070796460177	532	14	94	1	24	555	3218486	3219016	MAG: Ignavibacterium sp. KatS3mg037 DNA, complete genome	blastn	52210	898	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacterium	Ignavibacterium sp.
12778761	12778761	PRJEB28062_P_NODE_62411_length_441_cov_10.586957_g60051_i0	PRJEB28062	62411	441	10.586957	46.68848037	Ignavibacterium sp.	2651167	Bacteria	Bacteria	209	2.39e-49	NTclustered	gi\|2108406931\|gb\|CP070637.1\|	2651167	g60051	i0	79.522	12.281179138322	293	60	66	0	30	322	1226579	1226287	MAG: Ignavibacterium sp. isolate bin94 chromosome	blastn	5416	209	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacterium	Ignavibacterium sp.
22976235	22976235	PRJEB28062_P_NODE_19499_length_851_cov_21.416452_g17470_i0	PRJEB28062	19499	851	21.416452	182.25400652	Ignavibacterium	795750	Bacteria	Bacteria	515	3.7099999999999986e-183	NR	MDY0083427.1	2651163	g17470	i0	92.2	3.81081081081081	270	21	95.2	0	835	26	33	302	MDY0083427.1 phosphomannomutase [Ignavibacteriaceae bacterium]	diamond	3243	515	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae bacterium
27760086	27760086	PRJEB28062_P_NODE_126764_length_247_cov_0.885057_g124400_i0	PRJEB28062	126764	247	0.885057	2.18609079	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	91.7	2.45e-19	NR	MDR3611827.1	2651163	g124400	i0	65.4	0.983805668016194	81	28	98.4	0	2	244	565	645	MDR3611827.1 hypothetical protein [Ignavibacteriaceae bacterium]	diamond	243	91.7	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae bacterium
28801520	28801520	PRJEB28062_P_NODE_108168_length_291_cov_4.155963_g105805_i0	PRJEB28062	108168	291	4.155963	12.09385233	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	61.6	1.25e-9	NR	MBN1632766.1	2053306	g105805	i0	43.8	1.2680412371134	64	36	66	0	262	71	64	127	MBN1632766.1 four helix bundle protein [Ignavibacteria bacterium]	diamond	369	61.6	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
29401616	29401616	PRJEB28062_P_NODE_116229_length_270_cov_1.314721_g113866_i0	PRJEB28062	116229	270	1.314721	3.5497467	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	107	7.72e-27	NR	MDP3444970.1	2053306	g113866	i0	63.4	0.911111111111111	82	30	91.1	0	25	270	40	121	MDP3444970.1 proton-conducting transporter membrane subunit [Ignavibacteria bacterium]	diamond	246	107	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
30159323	30159323	PRJEB28062_P_NODE_138172_length_198_cov_5.816000_g135808_i0	PRJEB28062	138172	198	5.816	11.51568	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	87.8	8.3e-20	NR	HOP50169.1	2049428	g135808	i0	91.1	0.681818181818182	45	4	68.2	0	27	161	139	183	HOP50169.1 hypothetical protein [Ignavibacteriales bacterium]	diamond	135	87.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
30949647	30949647	PRJEB28062_P_NODE_29314_length_682_cov_13.183908_g27036_i0	PRJEB28062	29314	682	13.183908	89.91425256	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	249	7.68e-75	NR	MBX3044088.1	2026749	g27036	i0	56	2.83284457478006	216	94	95	1	669	22	460	674	MBX3044088.1 bifunctional (p)ppGpp synthetase/guanosine-3',5'-bis(diphosphate) 3'-pyrophosphohydrolase [Ignavibacteriota bacterium]	diamond	1932	249	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota 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);;