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

12 rows where analysis = "blastn", bioproject = "PRJNA558770" and tax_phylum = "Chloroflexota"

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
541028	541028	PRJNA558770_P_NODE_322521_length_233_cov_8.171717_g320516_i0	PRJNA558770	322521	233	8.171717	19.04010061	Leptolinea sp. HRD-7	2830982	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2250018340\|dbj\|AP024710.1\|	2830982	g320516	i0	96.97	0.141630901287554	33	1	14	0	20	52	157974	158006	Leptolinea sp. HRD-7 DNA, complete genome	blastn	33	56.5	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Leptolinea	Leptolinea sp. HRD-7
1815660	1815660	PRJNA558770_P_NODE_249402_length_234_cov_2.321608_g247397_i0	PRJNA558770	249402	234	2.321608	5.43256272	Anaerolineales bacterium	2073117	Bacteria	Bacteria	60.2	1.25e-4	NTclustered	gi\|2107916111\|gb\|CP070811.1\|	2073117	g247397	i0	100	0.384615384615385	32	0	14	0	2	33	2200027	2199996	MAG: Anaerolineales bacterium isolate bin12 chromosome	blastn	90	60.2	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
4367464	4367464	PRJNA558770_P_NODE_256284_length_234_cov_2.170854_g254279_i0	PRJNA558770	256284	234	2.170854	5.07979836	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2621702714\|emb\|OY759598.1\|	2026734	g254279	i0	94.286	0.14957264957265	35	1	15	1	160	193	2429201	2429235	MAG: Dehalococcoidia bacterium isolate 9e3974e8-1b76-4a2a-ace1-a6b9f67a3735 genome assembly, chromosome: 1	blastn	35	52.8	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
4369949	4369949	PRJNA558770_P_NODE_68024_length_252_cov_7.096774_g66019_i0	PRJNA558770	68024	252	7.096774	17.88387048	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	89.8	1.74e-13	NTclustered	gi\|2621701415\|emb\|OY760135.1\|	2026734	g66019	i0	84.043	2.53968253968254	94	13	37	2	160	252	1211756	1211848	MAG: Dehalococcoidia bacterium isolate 28bbf505-4b8f-49ae-a3a4-61061bf7583c genome assembly, chromosome: 1	blastn	640	89.8	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
7507286	7507286	PRJNA558770_P_NODE_241146_length_234_cov_2.512563_g239141_i0	PRJNA558770	241146	234	2.512563	5.87939742	Bacteria	2	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2621706198\|emb\|OY764542.1\|	2026734	g239141	i0	96.875	1.01282051282051	32	1	14	0	171	202	2147654	2147685	MAG: Dehalococcoidia bacterium isolate 6a5b5718-e0ca-4583-9154-875545b380e3 genome assembly, chromosome: 1	blastn	237	54.7	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
17117577	17117577	PRJNA558770_P_NODE_241234_length_234_cov_2.512563_g239229_i0	PRJNA558770	241234	234	2.512563	5.87939742	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	63.9	9.68e-6	NTclustered	gi\|2621703285\|emb\|OY762443.1\|	2026734	g239229	i0	100	1.08974358974359	34	0	15	0	5	38	1808929	1808962	MAG: Dehalococcoidia bacterium isolate e17dd254-e2e4-46ca-aa76-34ed56c1cae1 genome assembly, chromosome: 1	blastn	255	63.9	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
20940940	20940940	PRJNA558770_P_NODE_182957_length_234_cov_4.502513_g180952_i0	PRJNA558770	182957	234	4.502513	10.53588042	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	62.1	3.48e-5	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g180952	i0	100	0.264957264957265	33	0	14	0	175	207	3049565	3049533	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	62	62.1	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
20943243	20943243	PRJNA558770_P_NODE_326897_length_233_cov_7.030303_g324892_i0	PRJNA558770	326897	233	7.030303	16.38060599	Chloroflexota bacterium	2026724	Bacteria	Bacteria	65.8	2.68e-6	NTclustered	gi\|2621701252\|emb\|OY759972.1\|	2026724	g324892	i0	91.489	1.04721030042918	47	4	20	0	159	205	886737	886783	MAG: Chloroflexota bacterium isolate 55c93f92-7b64-48b2-973a-1fcfb2e6d712 genome assembly, chromosome: 1	blastn	244	65.8	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
22217434	22217434	PRJNA558770_P_NODE_268198_length_234_cov_1.939698_g266193_i0	PRJNA558770	268198	234	1.939698	4.53889332	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	95.3	3.43e-15	NTclustered	gi\|2621703475\|emb\|OY762538.1\|	3022862	g266193	i0	92.424	5.65811965811966	66	5	28	0	161	226	38978	39043	MAG: Tepidiformaceae bacterium isolate 22918afd-2252-4b5b-9d47-9fe66d5d45bf genome assembly, chromosome: 1	blastn	1324	95.3	1	Bacteria		Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
23490595	23490595	PRJNA558770_P_NODE_151099_length_234_cov_6.341709_g149094_i0	PRJNA558770	151099	234	6.341709	14.83959906	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	60.2	1.25e-4	NTclustered	gi\|2626255515\|emb\|OY843611.1\|	2026734	g149094	i0	90.909	0.188034188034188	44	4	19	0	7	50	1527913	1527870	MAG: Dehalococcoidia bacterium isolate 0645ce6a-a204-477d-b04f-0f5024184dab genome assembly, chromosome: 1	blastn	44	60.2	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
23492364	23492364	PRJNA558770_P_NODE_245699_length_234_cov_2.402010_g243694_i0	PRJNA558770	245699	234	2.40201	5.6207034	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	60.2	1.25e-4	NTclustered	gi\|2621704081\|emb\|OY761543.1\|	2026734	g243694	i0	97.143	26.1239316239316	35	1	16	0	162	196	818624	818590	MAG: Dehalococcoidia bacterium isolate d8cdd4bd-f85c-46d1-a80f-042a7445dbc9 genome assembly, chromosome: 1	blastn	6113	60.2	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
23492413	23492413	PRJNA558770_P_NODE_248779_length_234_cov_2.336683_g246774_i0	PRJNA558770	248779	234	2.336683	5.46783822	uncultured Dehalococcoidia bacterium	498747	Bacteria	Bacteria	65.8	2.69e-6	NTclustered	gi\|2531950174\|emb\|OY282494.1\|	498747	g246774	i0	97.368	0.465811965811966	38	1	16	0	175	212	3202434	3202471	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	109	65.8	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia 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);;