metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA1010662" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA1010662" 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
2276662	2276662	PRJNA1010662_S_NODE_682_length_344_cov_5.069767_g637_i0	PRJNA1010662	682	344	5.069767	17.43999848	Herpetosiphon	64	Bacteria	Bacteria	593	4.3099999999999986e-165	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g637	i0	97.688	216.186046511628	346	6	100	1	1	344	1988	2333	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	74368	593	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
2705237	2705237	PRJNA1010662_S_NODE_4443_length_164_cov_3.082645_g4398_i0	PRJNA1010662	4443	164	3.082645	5.0555378	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	200	4.62e-47	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g4398	i0	88.957	106.286585365854	163	17	99	1	2	164	596005	596166	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	17431	200	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
3981421	3981421	PRJNA1010662_S_NODE_3024_length_193_cov_2.013333_g2979_i0	PRJNA1010662	3024	193	2.013333	3.88573269	Herpetosiphon aurantiacus	65	Bacteria	Bacteria	339	1.14e-88	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g2979	i0	98.942	57.4922279792746	189	2	98	0	5	193	5446478	5446666	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	11096	339	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
3981423	3981423	PRJNA1010662_S_NODE_3184_length_189_cov_2.876712_g3139_i0	PRJNA1010662	3184	189	2.876712	5.43698568	Herpetosiphon aurantiacus	65	Bacteria	Bacteria	339	1.11e-88	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g3139	i0	98.942	5.77777777777778	189	2	100	0	1	189	1227801	1227989	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	1092	339	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
6533147	6533147	PRJNA1010662_S_NODE_126_length_660_cov_5.155592_g17_i1	PRJNA1010662	126	660	5.155592	34.0269072	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	726	0	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g17	i1	86.738	785.916666666667	656	83	99	4	1	654	597847	597194	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	518705	726	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
6533154	6533154	PRJNA1010662_S_NODE_26_length_1030_cov_6.596758_g17_i0	PRJNA1010662	26	1030	6.596758	67.9466074	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	1345	0	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g17	i0	90.31	577.147572815534	1032	92	99	7	1	1029	598466	597440	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	594462	1345	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
6533159	6533159	PRJNA1010662_S_NODE_3086_length_191_cov_6.006757_g3041_i0	PRJNA1010662	3086	191	6.006757	11.47290587	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	270	4.17e-68	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g3041	i0	92.147	127.973821989529	191	15	100	0	1	191	596777	596967	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	24443	270	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
6533160	6533160	PRJNA1010662_S_NODE_3106_length_191_cov_1.817568_g3061_i0	PRJNA1010662	3106	191	1.817568	3.47155488	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	75	3.51e-9	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g3061	i0	97.727	0.785340314136126	44	0	23	1	22	64	2804628	2804585	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	150	75	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
10358104	10358104	PRJNA1010662_S_NODE_3309_length_186_cov_2.790210_g3264_i0	PRJNA1010662	3309	186	2.79021	5.1897906	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	71.3	4.39e-8	NTclustered	gi\|2107832821\|gb\|CP070822.1\|	2024896	g3264	i0	97.619	0.639784946236559	42	0	23	1	34	75	1948790	1948830	MAG: Anaerolineaceae bacterium isolate bin1136 chromosome	blastn	119	71.3	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
12908653	12908653	PRJNA1010662_S_NODE_131_length_648_cov_4.375207_g104_i0	PRJNA1010662	131	648	4.375207	28.35134136	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	593	8.539999999999997e-165	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g104	i0	84.783	240.233024691358	598	83	92	8	1	595	598971	598379	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	155671	593	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
20556133	20556133	PRJNA1010662_S_NODE_1697_length_240_cov_10.182741_g1652_i0	PRJNA1010662	1697	240	10.182741	24.4385784	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	364	2.4399999999999993e-96	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g1652	i0	94.142	106.108333333333	239	14	99	0	2	240	596740	596978	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	25466	364	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
20556150	20556150	PRJNA1010662_S_NODE_3477_length_182_cov_3.359712_g3432_i0	PRJNA1010662	3477	182	3.359712	6.11467584	Candidatus Brevifilum fermentans	1986204	Bacteria	Bacteria	126	8.99e-25	NTclustered	gi\|1200880094\|emb\|LT859958.1\|	1986204	g3432	i0	86.441	85.489010989011	118	13	64	3	66	181	678255	678371	Anaerolineaceae bacterium CAMBI-1 genome assembly, chromosome: I	blastn	15559	126	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Candidatus Brevifilum	Candidatus Brevifilum fermentans
23107269	23107269	PRJNA1010662_S_NODE_159_length_616_cov_6.071553_g17_i2	PRJNA1010662	159	616	6.071553	37.40076648	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	619	1.33e-172	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g17	i2	84.927	795.590909090909	617	88	99	4	1	615	597847	597234	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	490084	619	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
24381026	24381026	PRJNA1010662_S_NODE_4580_length_163_cov_1.050000_g4535_i0	PRJNA1010662	4580	163	1.05	1.7115	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	239	9.72e-59	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g4535	i0	95.918	41.7546012269939	147	6	90	0	16	162	275902	275756	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	6806	239	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
25227703	25227703	PRJNA1010662_S_NODE_220_length_547_cov_4.081349_g177_i0	PRJNA1010662	220	547	4.081349	22.32497903	Herpetosiphon	64	Bacteria	Bacteria	928	0	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g177	i0	97.258	28.3674588665448	547	15	100	0	1	547	1801	1255	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	15517	928	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
25227723	25227723	PRJNA1010662_S_NODE_3920_length_173_cov_2.969231_g3875_i0	PRJNA1010662	3920	173	2.969231	5.13676963	Herpetosiphon	64	Bacteria	Bacteria	313	6.04e-81	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g3875	i0	99.419	166.543352601156	172	1	99	0	2	173	1140	969	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	28812	313	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus

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