metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA827593" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA827593" 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
9749585	9749585	PRJNA827593_P_NODE_58368_length_258_cov_2.000000_g58069_i0	PRJNA827593	58368	258	2	5.16	Ktedonosporobacter rubrisoli	2509675	Bacteria	Bacteria	117	8.2100000000000005e-22	NTclustered	gi\|1574824432\|gb\|CP035758.1\|	2509675	g58069	i0	83.465	0.492248062015504	127	19	49	2	39	164	5828292	5828167	Ktedonosporobacter rubrisoli strain SCAWS-G2 chromosome, complete genome	blastn	127	117	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonosporobacteraceae	Ktedonosporobacter	Ktedonosporobacter rubrisoli
11024761	11024761	PRJNA827593_P_NODE_28669_length_388_cov_1.711111_g28370_i0	PRJNA827593	28669	388	1.711111	6.63911068	Ktedonobacteria bacterium brp13	2717365	Bacteria	Bacteria	327	5.5e-85	NTclustered	gi\|1915456248\|dbj\|AP024096.1\|	2717365	g28370	i0	83.668	0.899484536082474	349	55	90	2	39	386	6341407	6341060	Ktedonobacteria bacterium brp13 DNA, complete genome	blastn	349	327	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria				Ktedonobacteria bacterium brp13
16124256	16124256	PRJNA827593_P_NODE_63973_length_247_cov_0.885057_g63674_i0	PRJNA827593	63973	247	0.885057	2.18609079	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	180	9.82e-41	NTclustered	gi\|2893356069\|emb\|OZ220492.1\|	2614250	g63674	i0	84.699	97.1052631578947	183	24	73	4	2	181	2778060	2778241	MAG: Caldilineaceae bacterium isolate e886e3b1-96bd-41d4-96ed-8e2f365de7fb genome assembly, chromosome: 1	blastn	23985	180	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
17399971	17399971	PRJNA827593_P_NODE_63534_length_247_cov_1.770115_g63235_i0	PRJNA827593	63534	247	1.770115	4.37218405	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	58.4	4.8e-4	NTclustered	gi\|2893358428\|emb\|OZ220720.1\|	2026734	g63235	i0	100	1.92307692307692	31	0	13	0	15	45	3746098	3746128	MAG: Dehalococcoidia bacterium isolate c1ccb28d-03af-49da-9b48-84a9185dfe7a genome assembly, chromosome: 1	blastn	475	58.4	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
18672778	18672778	PRJNA827593_P_NODE_51855_length_277_cov_1.132353_g51556_i0	PRJNA827593	51855	277	1.132353	3.13661781	Thermobaculum terrenum	166501	Bacteria	Bacteria	73.1	1.96e-8	NTclustered	gi\|269790643\|gb\|CP001826.1\|	525904	g51556	i0	93.75	5.39350180505415	48	3	17	0	183	230	337548	337595	Thermobaculum terrenum ATCC BAA-798 chromosome 2, complete sequence	blastn	1494	73.1	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Thermobaculales	Candidatus Thermobaculaceae	Thermobaculum	Thermobaculum terrenum
18672830	18672830	PRJNA827593_P_NODE_5495_length_964_cov_2.548822_g5249_i0	PRJNA827593	5495	964	2.548822	24.57064408	Thermogemmatispora argillosa	2045280	Bacteria	Bacteria	132	1.22e-25	NTclustered	gi\|1606537458\|dbj\|AP019377.1\|	2045280	g5249	i0	97.403	4.71473029045643	77	2	8	0	372	448	2867029	2867105	Thermogemmatispora sp. A3-2 DNA, complete genome	blastn	4545	132	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Thermogemmatisporales	Thermogemmatisporaceae	Thermogemmatispora	Thermogemmatispora argillosa
22497991	22497991	PRJNA827593_P_NODE_40958_length_317_cov_1.217213_g40659_i0	PRJNA827593	40958	317	1.217213	3.85856521	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	63.9	1.37e-5	NTclustered	gi\|2621706198\|emb\|OY764542.1\|	2026734	g40659	i0	93.182	0.905362776025237	44	1	16	2	94	136	1379509	1379551	MAG: Dehalococcoidia bacterium isolate 6a5b5718-e0ca-4583-9154-875545b380e3 genome assembly, chromosome: 1	blastn	287	63.9	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
23773634	23773634	PRJNA827593_P_NODE_38939_length_326_cov_1.098814_g38640_i0	PRJNA827593	38939	326	1.098814	3.58213364	Chloroflexota bacterium	2026724	Bacteria	Bacteria	63.9	1.42e-5	NTclustered	gi\|2621702192\|emb\|OY760183.1\|	2026724	g38640	i0	100	114.463190184049	34	0	13	0	113	146	678595	678562	MAG: Chloroflexota bacterium isolate 1e5240b1-722b-4dd6-bc08-6f4f73fd4587 genome assembly, chromosome: 1	blastn	37315	63.9	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota 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);;