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

12 rows where analysis = "blastn", bioproject = "PRJEB28062" 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
2574760	2574760	PRJEB28062_P_NODE_47083_length_523_cov_5.542222_g44738_i0	PRJEB28062	47083	523	5.542222	28.98582106	Anaerolineales bacterium	2073117	Bacteria	Bacteria	676	0	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g44738	i0	91.383	135.351816443595	499	35	94	7	10	503	2031088	2030593	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	70789	676	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
3851687	3851687	PRJEB28062_P_NODE_79864_length_377_cov_12.733553_g77502_i0	PRJEB28062	79864	377	12.733553	48.00549481	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	141	7.45e-29	NTclustered	gi\|2891482144\|emb\|OZ219877.1\|	3069543	g77502	i0	78.873	0.660477453580902	213	42	56	3	20	230	661041	661252	MAG: Phototrophicaceae bacterium isolate a0ca3ffb-69cb-424d-9738-2476a81df9ad genome assembly, chromosome: 3	blastn	249	141	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
4814730	4814730	PRJEB28062_P_NODE_103724_length_304_cov_1.207792_g101361_i0	PRJEB28062	103724	304	1.207792	3.67168768	Chloroflexota	200795	Bacteria	Bacteria	86.1	2.79e-12	NTclustered	gi\|2621704004\|emb\|OY762959.1\|	2026734	g101361	i0	84.444	16.2796052631579	90	11	29	3	200	287	2409211	2409123	MAG: Dehalococcoidia bacterium isolate a8fc5444-7059-4be1-bdcb-92646be6befe genome assembly, chromosome: 1	blastn	4949	86.1	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
5128286	5128286	PRJEB28062_P_NODE_98845_length_318_cov_3.551020_g96483_i0	PRJEB28062	98845	318	3.55102	11.2922436	Anaerolineales bacterium	2073117	Bacteria	Bacteria	183	1.01e-41	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g96483	i0	82.609	2.09119496855346	207	36	65	0	10	216	2479576	2479370	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	665	183	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
8950646	8950646	PRJEB28062_P_NODE_109068_length_289_cov_1.578704_g106705_i0	PRJEB28062	109068	289	1.578704	4.56245456	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	363	1.09e-95	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g106705	i0	89.384	47.2733564013841	292	25	100	6	1	289	1857912	1857624	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	13662	363	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
8950948	8950948	PRJEB28062_P_NODE_126128_length_248_cov_0.880000_g123764_i0	PRJEB28062	126128	248	0.88	2.1824	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	163	9.93e-36	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g123764	i0	78.862	6.37903225806452	246	49	98	3	5	248	165609	165365	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	1582	163	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
8951301	8951301	PRJEB28062_P_NODE_21648_length_804_cov_98.671683_g19513_i0	PRJEB28062	21648	804	98.671683	793.32033132	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	556	1.3999999999999998e-153	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g19513	i0	80.307	87.0310945273632	782	116	94	31	18	775	273812	273045	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	69973	556	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
12777288	12777288	PRJEB28062_P_NODE_114971_length_273_cov_1.925000_g112608_i0	PRJEB28062	114971	273	1.925	5.25525	Herpetosiphon aurantiacus	65	Bacteria	Bacteria	444	3.54e-120	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g112608	i0	95.971	1	273	11	100	0	1	273	1507264	1507536	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	273	444	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
13741107	13741107	PRJEB28062_P_NODE_57791_length_462_cov_9.478149_g55435_i0	PRJEB28062	57791	462	9.478149	43.78904838	FCB group	1783270	Bacteria	Bacteria	52.8	0.045	NTclustered	gi\|2531948664\|emb\|OY282448.1\|	166587	g55435	i0	100	0.121212121212121	28	0	6	0	190	217	1733218	1733191	MAG: uncultured Chloroflexota bacterium genome assembly, chromosome: 1	blastn	56	52.8	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
16289564	16289564	PRJEB28062_P_NODE_104273_length_302_cov_2.764192_g101910_i0	PRJEB28062	104273	302	2.764192	8.34785984	Bacteria	2	Bacteria	Bacteria	250	9.29e-62	NTclustered	gi\|1879344079\|gb\|CP059258.1\|	2052143	g101910	i0	85.837	86.1092715231788	233	31	77	2	28	259	801462	801693	MAG: Anaerolineae bacterium isolate SSC4 chromosome	blastn	26005	252	0.992063492063492	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
16601424	16601424	PRJEB28062_P_NODE_34354_length_626_cov_4.412297_g32039_i0	PRJEB28062	34354	626	4.412297	27.62097922	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	307	1.2e-78	NTclustered	gi\|2891482205\|emb\|OZ219938.1\|	2026734	g32039	i0	83.188	249.769968051118	345	49	54	8	267	607	40231	39892	MAG: Dehalococcoidia bacterium isolate d5105c1e-37dd-4811-a55b-ed3c3c49e222 genome assembly, chromosome: 12	blastn	156356	307	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
20425951	20425951	PRJEB28062_P_NODE_65997_length_426_cov_67.552408_g63636_i0	PRJEB28062	65997	426	67.552408	287.77325808	Anaerolineae bacterium	2052143	Bacteria	Bacteria	52.8	0.041	NTclustered	gi\|2621780275\|emb\|OY776562.1\|	2052143	g63636	i0	100	0.0657276995305164	28	0	7	0	217	244	1027085	1027112	MAG: Anaerolineae bacterium isolate f6896fb1-f4fb-4b0c-86b4-943ec43acfa7 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae 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);;