metadata: contig_metadata: 17 rows where bioproject = "PRJEB11748", tax_kingdom = "Thermotogati" and tax

17 rows where bioproject = "PRJEB11748", tax_kingdom = "Thermotogati" 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
6086938	6086938	PRJEB11748_P_NODE_244445_length_250_cov_6.650794_g242262_i0	PRJEB11748	244445	250	6.650794	16.626985	Pyramidobacter	638847	Bacteria	Bacteria	187	5.949999999999998e-43	NTclustered	gi\|2188906985\|dbj\|AP025585.1\|	638849	g242262	i0	82.629	1.74	213	35	85	2	15	226	2217942	2217731	Pyramidobacter piscolens CE91-St28 DNA, complete genome	blastn	435	187	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Pyramidobacter	Pyramidobacter piscolens
11187504	11187504	PRJEB11748_P_NODE_296049_length_221_cov_5.331250_g293866_i0	PRJEB11748	296049	221	5.33125	11.7820625	Pyramidobacter	638847	Bacteria	Bacteria	279	8.25e-71	NTclustered	gi\|167996909\|gb\|EU379932.1\|	352165	g293866	i0	92	34.0226244343891	200	15	90	1	23	221	1838	2037	Synergistes sp. W5455 16S ribosomal RNA gene, 16S-23S ribosomal RNA intergenic spacer, 23S ribosomal RNA gene, 23S-5S ribosomal RNA intergenic spacer, and 5S ribosomal RNA gene, complete sequence	blastn	7519	279	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Pyramidobacter	Pyramidobacter piscolens
15318115	15318115	PRJEB11748_P_NODE_198513_length_285_cov_2.200893_g196330_i0	PRJEB11748	198513	285	2.200893	6.27254505	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	322	1.82e-83	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g196330	i0	90.535	0.852631578947368	243	23	85	0	21	263	1523129	1522887	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	243	322	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
15318570	15318570	PRJEB11748_P_NODE_220913_length_267_cov_1.577670_g218730_i0	PRJEB11748	220913	267	1.57767	4.2123789	Thermanaerovibrio acidaminovorans	81462	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|269099254\|gb\|CP001818.1\|	525903	g218730	i0	96.774	0.116104868913858	31	1	12	0	24	54	1469920	1469890	Thermanaerovibrio acidaminovorans DSM 6589, complete genome	blastn	31	52.8	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae	Thermanaerovibrio	Thermanaerovibrio acidaminovorans
17867506	17867506	PRJEB11748_P_NODE_191895_length_291_cov_1.304348_g189712_i0	PRJEB11748	191895	291	1.304348	3.79565268	Pyramidobacter piscolens	638849	Bacteria	Bacteria	368	2.36e-97	NTclustered	gi\|167996909\|gb\|EU379932.1\|	352165	g189712	i0	89.931	12.6460481099656	288	25	98	3	1	286	2989	3274	Synergistes sp. W5455 16S ribosomal RNA gene, 16S-23S ribosomal RNA intergenic spacer, 23S ribosomal RNA gene, 23S-5S ribosomal RNA intergenic spacer, and 5S ribosomal RNA gene, complete sequence	blastn	3680	368	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Pyramidobacter	Pyramidobacter piscolens
17867988	17867988	PRJEB11748_P_NODE_217395_length_269_cov_7.966346_g215212_i0	PRJEB11748	217395	269	7.966346	21.42947074	Thermanaerovibrio acidaminovorans	81462	Bacteria	Bacteria	412	9.81e-111	NTclustered	gi\|269099254\|gb\|CP001818.1\|	525903	g215212	i0	98.298	0.87360594795539	235	4	87	0	19	253	925605	925839	Thermanaerovibrio acidaminovorans DSM 6589, complete genome	blastn	235	412	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae	Thermanaerovibrio	Thermanaerovibrio acidaminovorans
20417925	20417925	PRJEB11748_P_NODE_274437_length_232_cov_9.941520_g272254_i0	PRJEB11748	274437	232	9.94152	23.0643264	Pyramidobacter sp. YE332	3068894	Bacteria	Bacteria	342	1.0999999999999999e-89	NTclustered	gi\|2601021520\|gb\|CP133038.1\|	3068894	g272254	i0	95.794	1.82758620689655	214	6	91	3	18	228	978192	977979	Pyramidobacter sp. YE332 chromosome, complete genome	blastn	424	342	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Pyramidobacter	Pyramidobacter sp. YE332
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);;