metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA379145" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA379145" 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
8054358	8054358	PRJNA379145_P_NODE_65687_length_170_cov_3.284672_g63533_i0	PRJNA379145	65687	170	3.284672	5.5839424	Thermosporothrix sp. COM3	2490863	Bacteria	Bacteria	67.6	5.08e-7	NTclustered	gi\|1606557374\|dbj\|AP019376.1\|	2490863	g63533	i0	90.566	0.311764705882353	53	2	31	3	6	58	4867043	4866994	Thermosporothrix sp. COM3 DNA, nearly complete genome	blastn	53	67.6	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Thermosporotrichaceae	Thermosporothrix	Thermosporothrix sp. COM3
8054413	8054413	PRJNA379145_P_NODE_72467_length_154_cov_1.198347_g70312_i0	PRJNA379145	72467	154	1.198347	1.84545438	Thermosporothrix sp. COM3	2490863	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|1606557374\|dbj\|AP019376.1\|	2490863	g70312	i0	100	0.181818181818182	28	0	18	0	106	133	1035009	1034982	Thermosporothrix sp. COM3 DNA, nearly complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Thermosporotrichaceae	Thermosporothrix	Thermosporothrix sp. COM3
9329112	9329112	PRJNA379145_P_NODE_57688_length_198_cov_1.321212_g55534_i0	PRJNA379145	57688	198	1.321212	2.61599976	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	145	2.75e-30	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g55534	i0	80.296	7.57070707070707	203	30	100	10	1	198	240389	240192	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	1499	145	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
11879907	11879907	PRJNA379145_P_NODE_70430_length_158_cov_2.576000_g68275_i0	PRJNA379145	70430	158	2.576	4.07008	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	115	1.6400000000000002e-21	NTclustered	gi\|2893356069\|emb\|OZ220492.1\|	2614250	g68275	i0	95.775	81.9556962025316	71	3	45	0	88	158	2777223	2777153	MAG: Caldilineaceae bacterium isolate e886e3b1-96bd-41d4-96ed-8e2f365de7fb genome assembly, chromosome: 1	blastn	12949	115	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
13154809	13154809	PRJNA379145_P_NODE_59811_length_189_cov_3.301282_g57657_i0	PRJNA379145	59811	189	3.301282	6.23942298	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	250	5.36e-62	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g57657	i0	90.526	139.396825396825	190	16	100	2	1	189	274001	274189	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	26346	250	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
15703698	15703698	PRJNA379145_P_NODE_50673_length_230_cov_1.370558_g48519_i0	PRJNA379145	50673	230	1.370558	3.1522834	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	224	4.11e-54	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g48519	i0	84.783	8.10434782608696	230	28	100	3	1	230	1400	1178	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	1864	224	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
20802549	20802549	PRJNA379145_P_NODE_65637_length_171_cov_1.072464_g63483_i0	PRJNA379145	65637	171	1.072464	1.83391344	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	158	2.9499999999999992e-34	NTclustered	gi\|2621706198\|emb\|OY764542.1\|	2026734	g63483	i0	83.425	43.9356725146199	181	18	99	10	2	171	2051852	2052031	MAG: Dehalococcoidia bacterium isolate 6a5b5718-e0ca-4583-9154-875545b380e3 genome assembly, chromosome: 1	blastn	7513	158	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
22077234	22077234	PRJNA379145_P_NODE_25138_length_493_cov_2.378261_g23108_i0	PRJNA379145	25138	493	2.378261	11.72482673	uncultured Dehalococcoidia bacterium	498747	Bacteria	Bacteria	122	3.62e-23	NTclustered	gi\|2531976022\|emb\|OY282355.1\|	498747	g23108	i0	82.734	11.7342799188641	139	22	28	2	310	447	2403026	2402889	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	5785	122	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
22077339	22077339	PRJNA379145_P_NODE_33718_length_367_cov_2.071856_g31574_i0	PRJNA379145	33718	367	2.071856	7.60371152	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|2891482216\|emb\|OZ219949.1\|	2026734	g31574	i0	100	0.152588555858311	28	0	8	0	31	58	1658994	1659021	MAG: Dehalococcoidia bacterium isolate 99137651-b1e7-4859-9a90-ab3a7f48d20f genome assembly, chromosome: 5	blastn	56	52.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
23352653	23352653	PRJNA379145_P_NODE_21679_length_558_cov_3.099048_g19749_i0	PRJNA379145	21679	558	3.099048	17.29268784	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	654	0	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g19749	i0	88.406	161.34229390681	552	52	97	9	17	558	273452	274001	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	90029	654	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia 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);;