metadata: contig_metadata: 10 rows where bioproject = "PRJNA1115053", tax_kingdom = "Bacillati" and tax

10 rows where bioproject = "PRJNA1115053", tax_kingdom = "Bacillati" 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
16326959	16326959	PRJNA1115053_S_NODE_2413_length_1035_cov_9.360887_g1656_i0	PRJNA1115053	2413	1035	9.360887	96.885180449999993	Chloroflexus	1107	Bacteria	Bacteria	590	1.8e-163	NTclustered	gi\|470482818\|ref\|NR_076553.1\|	1108	g1656	i0	82.03	493.2	729	98	69	21	1	718	1160	454	Chloroflexus aurantiacus strain J-10-fl 23S ribosomal RNA gene, complete sequence	blastn	510462	592	0.996621621621622	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
18078102	18078102	PRJNA1115053_S_NODE_27315_length_414_cov_1.975741_g25505_i0	PRJNA1115053	27315	414	1.975741	8.17956774	Litorilinea aerophila	1204385	Bacteria	Bacteria	444	5.62e-120	NTclustered	gi\|393193706\|gb\|JQ733906.1\|	1204385	g25505	i0	86.275	117.413043478261	408	56	99	0	7	414	4569	4162	Litorilinea aerophila strain PRI-4131 small subunit ribosomal RNA, tRNA-Ile (trnI), and large subunit ribosomal RNA genes, complete sequence	blastn	48609	444	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Litorilinea	Litorilinea aerophila
27447467	27447467	PRJNA1115053_S_NODE_241543_length_178_cov_2.133333_g239726_i0	PRJNA1115053	241543	178	2.133333	3.79733274	Ktedonobacterales bacterium	2306968	Bacteria	Bacteria	42.4	0.0209	NR	HEX8998246.1	2306968	g239726	i0	52.6	2.56179775280899	38	10	55.6	2	9	107	31	65	HEX8998246.1 hypothetical protein [Ktedonobacterales bacterium]	diamond	456	42.4	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales			Ktedonobacterales bacterium
27763240	27763240	PRJNA1115053_S_NODE_202064_length_193_cov_1.460000_g200247_i0	PRJNA1115053	202064	193	1.46	2.8178	Chloroflexota bacterium	2026724	Bacteria	Bacteria	42.4	0.0185	NR	MFN8525726.1	2026724	g200247	i0	41.4	0.901554404145078	58	34	90.2	0	179	6	41	98	MFN8525726.1 chromate transporter [Chloroflexota bacterium]	diamond	174	42.4	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28047114	28047114	PRJNA1115053_S_NODE_315905_length_157_cov_1.684211_g314088_i0	PRJNA1115053	315905	157	1.684211	2.64421127	Ardenticatenaceae bacterium	2614247	Bacteria	Bacteria	41.2	0.0417	NR	HEX8680913.1	2614247	g314088	i0	37.8	0.859872611464968	45	27	86	1	136	2	507	550	HEX8680913.1 hypothetical protein [Ardenticatenaceae bacterium]	diamond	135	41.2	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Ardenticatenales	Ardenticatenaceae		Ardenticatenaceae bacterium
29910208	29910208	PRJNA1115053_S_NODE_332791_length_153_cov_1.745455_g330974_i0	PRJNA1115053	332791	153	1.745455	2.67054615	Chloroflexota bacterium	2026724	Bacteria	Bacteria	40.4	0.0408	NR	MEA3342494.1	2026724	g330974	i0	45.5	0.647058823529412	33	18	64.7	0	4	102	32	64	MEA3342494.1 hypothetical protein [Chloroflexota bacterium]	diamond	99	40.4	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29973222	29973222	PRJNA1115053_S_NODE_327771_length_154_cov_2.162162_g325954_i0	PRJNA1115053	327771	154	2.162162	3.32972948	Anaerolineales bacterium	2073117	Bacteria	Bacteria	44.3	0.00309	NR	HZM24489.1	2073117	g325954	i0	36	2.86363636363636	50	32	97.4	0	153	4	139	188	HZM24489.1 ABC-2 family transporter protein [Anaerolineales bacterium]	diamond	441	44.3	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
30478867	30478867	PRJNA1115053_S_NODE_123873_length_238_cov_0.984615_g122056_i0	PRJNA1115053	123873	238	0.984615	2.3433837	Anaerolineales bacterium	2073117	Bacteria	Bacteria	42.7	0.0348	NR	MCA9964519.1	2073117	g122056	i0	31.1	0.76890756302521	61	37	76.9	1	51	233	179	234	MCA9964519.1 amino acid adenylation domain-containing protein [Anaerolineales bacterium]	diamond	183	42.7	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
30478876	30478876	PRJNA1115053_S_NODE_184413_length_201_cov_1.215190_g182596_i0	PRJNA1115053	184413	201	1.21519	2.4425319	Chloroflexota bacterium	2026724	Bacteria	Bacteria	43.1	0.0141	NR	HET6319007.1	2026724	g182596	i0	45.3	0.791044776119403	53	27	79.1	1	168	10	168	218	HET6319007.1 plastocyanin/azurin family copper-binding protein [Chloroflexota bacterium]	diamond	159	43.1	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32439475	32439475	PRJNA1115053_S_NODE_347259_length_151_cov_2.666667_g345442_i0	PRJNA1115053	347259	151	2.666667	4.02666717	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	42	0.0174	NR	MEO6197821.1	2026734	g345442	i0	56.1	0.814569536423841	41	16	81.5	2	16	138	55	93	MEO6197821.1 pyridoxal 5'-phosphate synthase glutaminase subunit PdxT [Dehalococcoidia bacterium]	diamond	123	42	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia 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);;