metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJEB11748" and tax

10 rows where analysis = "diamond", bioproject = "PRJEB11748" and tax_phylum = "Synergistota"

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
26741377	26741377	PRJEB11748_P_NODE_340241_length_202_cov_4.773050_g338058_i0	PRJEB11748	340241	202	4.77305	9.641561	Pyramidobacter	638847	Bacteria	Bacteria	84.7	3.19e-17	NR	WP_244389188.1	638849	g338058	i0	65.5	4.21782178217822	58	20	86.1	0	201	28	214	271	WP_244389188.1 phage portal protein [Pyramidobacter piscolens]	diamond	852	84.7	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Pyramidobacter	Pyramidobacter piscolens
27096130	27096130	PRJEB11748_P_NODE_83842_length_458_cov_4.397985_g81677_i0	PRJEB11748	83842	458	4.397985	20.1427713	Synergistaceae bacterium	2053624	Bacteria	Bacteria	46.2	0.0214	NR	MCL2147280.1	2053624	g81677	i0	40.4	1.31659388646288	57	28	33.4	1	398	246	1380	1436	MCL2147280.1 C10 family peptidase [Synergistaceae bacterium]	diamond	603	46.2	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
27380639	27380639	PRJEB11748_P_NODE_151803_length_333_cov_2.753676_g149622_i0	PRJEB11748	151803	333	2.753676	9.16974108	Synergistaceae bacterium	2053624	Bacteria	Bacteria	68.9	6.43e-13	NR	MBR0079611.1	2053624	g149622	i0	54	0.45045045045045	50	23	45	0	163	312	1	50	MBR0079611.1 hypothetical protein [Synergistaceae bacterium]	diamond	150	68.9	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
27917229	27917229	PRJEB11748_P_NODE_327605_length_207_cov_3.739726_g325422_i0	PRJEB11748	327605	207	3.739726	7.74123282	Synergistales bacterium	2268201	Bacteria	Bacteria	112	2.21e-29	NR	NCC59100.1	2268201	g325422	i0	87.3	0.91304347826087	63	8	91.3	0	17	205	30	92	NCC59100.1 hypothetical protein [Synergistales bacterium]	diamond	189	112	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales			Synergistales bacterium
28201322	28201322	PRJEB11748_P_NODE_310566_length_214_cov_10.444444_g308383_i0	PRJEB11748	310566	214	10.444444	22.35111016	Synergistaceae bacterium	2053624	Bacteria	Bacteria	90.9	4.9300000000000006e-21	NR	MDD3512390.1	2053624	g308383	i0	70.1	0.939252336448598	67	20	93.9	0	206	6	9	75	MDD3512390.1 hypothetical protein [Synergistaceae bacterium]	diamond	201	90.9	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
28390799	28390799	PRJEB11748_P_NODE_113186_length_391_cov_2.600000_g111012_i0	PRJEB11748	113186	391	2.6	10.166	Jonquetella sp. BV3C21	1111126	Bacteria	Bacteria	217	1.31e-66	NR	WP_021775875.1	1111126	g111012	i0	95.5	0.851662404092072	111	5	85.2	0	338	6	1	111	WP_021775875.1 arginine deiminase family protein [Jonquetella sp. BV3C21]	diamond	333	217	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Jonquetella	Jonquetella sp. BV3C21
28991137	28991137	PRJEB11748_P_NODE_248208_length_248_cov_1.951872_g246025_i0	PRJEB11748	248208	248	1.951872	4.84064256	Synergistaceae bacterium	2053624	Bacteria	Bacteria	70.9	3.21e-12	NR	MBQ9565805.1	2053624	g246025	i0	51.6	2.20161290322581	64	31	77.4	0	49	240	4	67	MBQ9565805.1 hypothetical protein [Synergistaceae bacterium]	diamond	546	70.9	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
30317848	30317848	PRJEB11748_P_NODE_357012_length_194_cov_3.736842_g354829_i0	PRJEB11748	357012	194	3.736842	7.24947348	Synergistaceae bacterium	2053624	Bacteria	Bacteria	42.7	0.0123	NR	MBR0256202.1	2053624	g354829	i0	44.7	1.54639175257732	38	21	58.8	0	48	161	90	127	MBR0256202.1 hypothetical protein [Synergistaceae bacterium]	diamond	300	42.7	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
30626852	30626852	PRJEB11748_P_NODE_349713_length_198_cov_2.941606_g347530_i0	PRJEB11748	349713	198	2.941606	5.82437988	Bacteria	2	Bacteria	Bacteria	72.4	9.48e-14	NR	MBQ7562335.1	2053624	g347530	i0	74.4	2.06060606060606	43	11	65.2	0	2	130	148	190	MBQ7562335.1 septum formation inhibitor Maf [Synergistaceae bacterium]	diamond	408	72.8	0.994505494505495	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
32713423	32713423	PRJEB11748_P_NODE_173320_length_308_cov_16.060729_g171137_i0	PRJEB11748	173320	308	16.060729	49.46704532	FCB group	1783270	Bacteria	Bacteria	136	8.48e-36	NR	GHV43000.1	2268201	g171137	i0	69.1	2.74675324675325	94	29	91.6	0	307	26	10	103	GHV43000.1 group II intron reverse transcriptase/maturase [Synergistales bacterium]	diamond	846	136	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales			Synergistales 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);;