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

8 rows where analysis = "blastn", bioproject = "PRJNA615351" 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
1871679	1871679	PRJNA615351_P_NODE_176822_length_159_cov_0.975806_g162722_i0	PRJNA615351	176822	159	0.975806	1.55153154	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	189	9.62e-44	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g162722	i0	93.651	2.27672955974843	126	8	79	0	1	126	273051	273176	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	362	189	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
4423023	4423023	PRJNA615351_P_NODE_109104_length_283_cov_2.004032_g95005_i0	PRJNA615351	109104	283	2.004032	5.67141056	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	255	1.85e-63	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g95005	i0	83.453	194.787985865724	278	42	97	3	4	278	274536	274812	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	55125	255	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
4423189	4423189	PRJNA615351_P_NODE_166604_length_169_cov_1.380597_g152504_i0	PRJNA615351	166604	169	1.380597	2.33320893	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	143	8.139999999999998e-30	NTclustered	gi\|2893358382\|emb\|OZ220676.1\|	2614250	g152504	i0	83.333	78.2189349112426	162	20	93	7	1	158	357184	357342	MAG: Caldilineaceae bacterium isolate 6911f4b3-f793-4dac-9473-b80504ec0e1d genome assembly, chromosome: 1	blastn	13219	143	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
6253758	6253758	PRJNA615351_P_NODE_84805_length_395_cov_1.711111_g70744_i0	PRJNA615351	84805	395	1.711111	6.75888845	Roseiflexus	120961	Bacteria	Bacteria	425	1.93e-114	NTclustered	gi\|470482403\|ref\|NR_076530.1\|	120962	g70744	i0	88.483	101.549367088608	356	35	89	5	2	353	955	602	Roseiflexus castenholzii strain HLO8 23S ribosomal RNA gene, complete sequence	blastn	40112	425	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus castenholzii
13903980	13903980	PRJNA615351_P_NODE_94371_length_343_cov_3.074675_g80282_i0	PRJNA615351	94371	343	3.074675	10.54613525	Caldilinea	233191	Bacteria	Bacteria	442	1.6499999999999995e-119	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g80282	i0	90.265	20.0116618075802	339	32	99	1	1	338	1666	1328	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	6864	442	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
20276427	20276427	PRJNA615351_P_NODE_177716_length_158_cov_1.300813_g163616_i0	PRJNA615351	177716	158	1.300813	2.05528454	Caldilinea	233191	Bacteria	Bacteria	165	1.61e-36	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g163616	i0	86.986	60.6772151898734	146	19	92	0	13	158	711	856	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	9587	165	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
22272720	22272720	PRJNA615351_P_NODE_138178_length_209_cov_3.367816_g124078_i0	PRJNA615351	138178	209	3.367816	7.03873544	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	137	4.92e-28	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g124078	i0	80.645	102.043062200957	186	28	89	6	24	208	199	21	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	21327	137	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
23548166	23548166	PRJNA615351_P_NODE_168739_length_167_cov_1.053030_g154639_i0	PRJNA615351	168739	167	1.05303	1.7585601	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	128	2.26e-25	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g154639	i0	90.722	5.88622754491018	97	8	58	1	21	117	248	153	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	983	128	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1

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