metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA492280" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA492280" 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
3650288	3650288	PRJNA492280_P_NODE_9523_length_173_cov_20.330882_g9416_i0	PRJNA492280	9523	173	20.330882	35.17242586	Caldilinea	233191	Bacteria	Bacteria	276	7.92e-70	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g9416	i0	95.376	104.64161849711	173	8	100	0	1	173	2443	2271	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	18103	276	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
4279212	4279212	PRJNA492280_P_NODE_8524_length_182_cov_3.917241_g8417_i0	PRJNA492280	8524	182	3.917241	7.12937862	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	106	1.17e-18	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g8417	i0	79.739	1.45604395604396	153	25	82	6	15	164	7911	8060	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	265	106	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
11930740	11930740	PRJNA492280_P_NODE_5690_length_215_cov_6.483146_g5583_i0	PRJNA492280	5690	215	6.483146	13.9387639	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	147	8.45e-31	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g5583	i0	89.076	75.7069767441861	119	11	55	2	1	118	3521967	3521850	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	16277	147	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
13205615	13205615	PRJNA492280_P_NODE_13551_length_164_cov_5.346457_g13444_i0	PRJNA492280	13551	164	5.346457	8.76818948	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2621704077\|emb\|OY761541.1\|	2026734	g13444	i0	100	1.75	30	0	18	0	6	35	639799	639770	MAG: Dehalococcoidia bacterium isolate f9b9afb7-0d58-404f-89de-58ff16bbafec genome assembly, chromosome: 1	blastn	287	56.5	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
13852686	13852686	PRJNA492280_P_NODE_5531_length_218_cov_6.524862_g5424_i0	PRJNA492280	5531	218	6.524862	14.22419916	Dehalogenimonas	670486	Bacteria	Bacteria	67.6	6.88e-7	NTclustered	gi\|470486512\|ref\|NR_076762.1\|	552810	g5424	i0	89.286	0.513761467889908	56	3	25	3	1	54	419	365	Dehalogenimonas lykanthroporepellens strain BL-DC-9 23S ribosomal RNA gene, complete sequence	blastn	112	67.6	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales	Dehalococcoidaceae	Dehalogenimonas	Dehalogenimonas lykanthroporepellens
18303553	18303553	PRJNA492280_P_NODE_19855_length_164_cov_3.354331_g19748_i0	PRJNA492280	19855	164	3.354331	5.50110284	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	195	2.15e-45	NTclustered	gi\|2575803493\|emb\|OY729430.1\|	2614250	g19748	i0	85.455	107.243902439024	165	21	99	2	1	162	1510917	1510753	MAG: Caldilineaceae bacterium isolate ee78b5b4-03fb-4fb3-b3ee-46148e6ffba5 genome assembly, chromosome: 1	blastn	17588	195	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
19577696	19577696	PRJNA492280_P_NODE_12896_length_164_cov_5.913386_g12789_i0	PRJNA492280	12896	164	5.913386	9.69795304	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	69.4	1.36e-7	NTclustered	gi\|2626282194\|emb\|OY839116.1\|	2026734	g12789	i0	97.5	0.24390243902439	40	1	24	0	15	54	2064383	2064344	MAG: Dehalococcoidia bacterium isolate 44b3abb6-b6b9-4f11-be96-93ee54cc77f6 genome assembly, chromosome: 1	blastn	40	69.4	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
22128298	22128298	PRJNA492280_P_NODE_1498_length_361_cov_3.533951_g1395_i0	PRJNA492280	1498	361	3.533951	12.75756311	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	228	5.2999999999999996e-55	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g1395	i0	92.994	55.2797783933518	157	10	68	1	4	160	8221	8376	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	19956	228	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
23404210	23404210	PRJNA492280_P_NODE_18499_length_164_cov_3.590551_g18392_i0	PRJNA492280	18499	164	3.590551	5.88850364	Thermosporothrix sp. COM3	2490863	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|1606557374\|dbj\|AP019376.1\|	2490863	g18392	i0	100	1.09756097560976	30	0	18	0	125	154	3564639	3564610	Thermosporothrix sp. COM3 DNA, nearly complete genome	blastn	180	56.5	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Thermosporotrichaceae	Thermosporothrix	Thermosporothrix sp. COM3
24050801	24050801	PRJNA492280_P_NODE_22599_length_164_cov_2.921260_g22492_i0	PRJNA492280	22599	164	2.92126	4.7908664	root	1	Root_unresolved	Root_unresolved	58.4	2.94e-4	NTclustered	gi\|269790643\|gb\|CP001826.1\|	525904	g22492	i0	97.059	1.1890243902439	34	1	21	0	111	144	1052775	1052808	Thermobaculum terrenum ATCC BAA-798 chromosome 2, complete sequence	blastn	195	58.4	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Thermobaculales	Candidatus Thermobaculaceae	Thermobaculum	Thermobaculum terrenum
24678130	24678130	PRJNA492280_P_NODE_33680_length_150_cov_3.743363_g33573_i0	PRJNA492280	33680	150	3.743363	5.6150445	Chloroflexus aurantiacus	1108	Bacteria	Bacteria	67.6	4.36e-7	NTclustered	gi\|163666892\|gb\|CP000909.1\|	324602	g33573	i0	88.889	1.39333333333333	54	6	36	0	90	143	3507298	3507351	Chloroflexus aurantiacus J-10-fl, complete genome	blastn	209	67.6	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
25324961	25324961	PRJNA492280_P_NODE_10420_length_167_cov_4.184615_g10313_i0	PRJNA492280	10420	167	4.184615	6.98830705	Bacteria	2	Bacteria	Bacteria	76.8	8.31e-10	NTclustered	gi\|470482818\|ref\|NR_076553.1\|	1108	g10313	i0	100	11.1616766467066	41	0	25	0	31	71	493	533	Chloroflexus aurantiacus strain J-10-fl 23S ribosomal RNA gene, complete sequence	blastn	1864	76.8	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
25324982	25324982	PRJNA492280_P_NODE_11580_length_164_cov_9.606299_g11473_i0	PRJNA492280	11580	164	9.606299	15.75433036	Caldilinea	233191	Bacteria	Bacteria	95.3	2.24e-15	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g11473	i0	89.474	66.469512195122	76	7	46	1	89	164	1616	1690	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	10901	95.3	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila

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);;