metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA799842" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA799842" 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
1219610	1219610	PRJNA799842_P_NODE_74161_length_333_cov_1.234615_g72588_i0	PRJNA799842	74161	333	1.234615	4.11126795	Chloroflexus	1107	Bacteria	Bacteria	285	2.84e-72	NTclustered	gi\|470482818\|ref\|NR_076553.1\|	1108	g72588	i0	83.178	101.936936936937	321	45	96	7	13	331	578	891	Chloroflexus aurantiacus strain J-10-fl 23S ribosomal RNA gene, complete sequence	blastn	33945	285	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
2069289	2069289	PRJNA799842_P_NODE_142902_length_250_cov_0.870056_g141329_i0	PRJNA799842	142902	250	0.870056	2.17514	Chloroflexota bacterium	2026724	Bacteria	Bacteria	130	1.02e-25	NTclustered	gi\|2108029441\|gb\|CP070764.1\|	2026724	g141329	i0	81.212	1.08	165	27	65	4	73	235	1689709	1689547	MAG: Chloroflexi bacterium isolate bin26 chromosome	blastn	270	130	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
7172171	7172171	PRJNA799842_P_NODE_163686_length_246_cov_0.890173_g162113_i0	PRJNA799842	163686	246	0.890173	2.18982558	Anaerolineales bacterium	2073117	Bacteria	Bacteria	244	3.42e-60	NTclustered	gi\|2556899361\|gb\|CP129481.1\|	2073117	g162113	i0	84.774	0.98780487804878	243	37	99	0	4	246	1735231	1734989	MAG: Anaerolineales bacterium isolate cMAG.15 chromosome, complete genome	blastn	243	244	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
9722011	9722011	PRJNA799842_P_NODE_164528_length_246_cov_0.890173_g162955_i0	PRJNA799842	164528	246	0.890173	2.18982558	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	438	1.4599999999999996e-118	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g162955	i0	98.78	27.6463414634146	246	3	100	0	1	246	2639942	2639697	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	6801	438	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
9722350	9722350	PRJNA799842_P_NODE_183108_length_242_cov_0.911243_g181535_i0	PRJNA799842	183108	242	0.911243	2.20520806	Anaerolineales bacterium	2073117	Bacteria	Bacteria	171	5.77e-38	NTclustered	gi\|2556913751\|gb\|CP129485.1\|	2073117	g181535	i0	86.076	1.30578512396694	158	22	65	0	76	233	522656	522813	MAG: Anaerolineales bacterium isolate cMAG.11 chromosome, complete genome	blastn	316	171	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
10999020	10999020	PRJNA799842_P_NODE_51949_length_394_cov_1.389408_g50376_i0	PRJNA799842	51949	394	1.389408	5.47426752	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	302	3.39e-77	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g50376	i0	82.466	340.42385786802	365	44	90	18	39	394	3521581	3521934	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	134127	302	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
13547352	13547352	PRJNA799842_P_NODE_157131_length_247_cov_0.885057_g155558_i0	PRJNA799842	157131	247	0.885057	2.18609079	Anaerolineales bacterium	2073117	Bacteria	Bacteria	154	5.95e-33	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g155558	i0	78.661	13.6032388663968	239	45	96	6	1	236	681329	681564	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	3360	154	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
13548046	13548046	PRJNA799842_P_NODE_22011_length_637_cov_2.164894_g20487_i0	PRJNA799842	22011	637	2.164894	13.79037478	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	313	2.63e-80	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g20487	i0	76.509	220.408163265306	613	121	95	19	4	605	3522746	3522146	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	140400	313	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
14822738	14822738	PRJNA799842_P_NODE_19332_length_689_cov_2.108766_g17838_i0	PRJNA799842	19332	689	2.108766	14.52939774	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	390	1.28e-103	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g17838	i0	80.374	158.602322206096	535	88	76	15	160	686	273544	274069	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	109277	390	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
16098271	16098271	PRJNA799842_P_NODE_83273_length_316_cov_1.493827_g81700_i0	PRJNA799842	83273	316	1.493827	4.72049332	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	119	2.88e-22	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g81700	i0	89.362	99.5537974683544	94	10	30	0	139	232	3520995	3521088	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	31459	119	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
16522155	16522155	PRJNA799842_P_NODE_43953_length_429_cov_1.941011_g42380_i0	PRJNA799842	43953	429	1.941011	8.32693719	Herpetosiphon	64	Bacteria	Bacteria	359	2.18e-94	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g42380	i0	82.045	168.072261072261	440	61	100	14	1	429	2611	2179	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	72103	359	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
17371216	17371216	PRJNA799842_P_NODE_10614_length_962_cov_2.746907_g9447_i0	PRJNA799842	10614	962	2.746907	26.42524534	Roseiflexus castenholzii	120962	Bacteria	Bacteria	577	1.2999999999999994e-159	NTclustered	gi\|156231356\|gb\|CP000804.1\|	383372	g9447	i0	79.245	151.424116424116	848	143	86	32	19	847	3885864	3885031	Roseiflexus castenholzii DSM 13941, complete genome	blastn	145670	577	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus castenholzii
19920425	19920425	PRJNA799842_P_NODE_148156_length_249_cov_0.875000_g146583_i0	PRJNA799842	148156	249	0.875	2.17875	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	67.6	8.05e-7	NTclustered	gi\|2531948664\|emb\|OY282448.1\|	166587	g146583	i0	87.719	0.409638554216867	57	7	23	0	125	181	551254	551310	MAG: uncultured Chloroflexota bacterium genome assembly, chromosome: 1	blastn	102	67.6	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
24170350	24170350	PRJNA799842_P_NODE_134119_length_251_cov_1.730337_g132546_i0	PRJNA799842	134119	251	1.730337	4.34314587	Chloroflexus	1107	Bacteria	Bacteria	195	3.57e-45	NTclustered	gi\|470483916\|ref\|NR_076619.1\|	152260	g132546	i0	81.967	337.478087649402	244	30	95	13	13	251	1061	827	Chloroflexus aggregans strain MD-66 23S ribosomal RNA gene, complete sequence	blastn	84707	195	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aggregans
25020037	25020037	PRJNA799842_P_NODE_145200_length_249_cov_0.875000_g143627_i0	PRJNA799842	145200	249	0.875	2.17875	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	139	1.68e-28	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g143627	i0	100	22.0200803212851	75	0	30	0	150	224	2825113	2825039	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	5483	139	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
25020055	25020055	PRJNA799842_P_NODE_145880_length_249_cov_0.875000_g144307_i0	PRJNA799842	145880	249	0.875	2.17875	Anaerolineales bacterium	2073117	Bacteria	Bacteria	137	6.0499999999999996e-28	NTclustered	gi\|2556910457\|gb\|CP129484.1\|	2073117	g144307	i0	98.701	2.39357429718876	77	1	31	0	72	148	1165383	1165307	MAG: Anaerolineales bacterium isolate cMAG.12 chromosome, complete genome	blastn	596	137	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
25020489	25020489	PRJNA799842_P_NODE_169060_length_245_cov_0.895349_g167487_i0	PRJNA799842	169060	245	0.895349	2.19360505	Anaerolineales bacterium	2073117	Bacteria	Bacteria	342	1.17e-89	NTclustered	gi\|2556899361\|gb\|CP129481.1\|	2073117	g167487	i0	91.837	1.11428571428571	245	20	100	0	1	245	2298859	2299103	MAG: Anaerolineales bacterium isolate cMAG.15 chromosome, complete genome	blastn	273	342	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
25020552	25020552	PRJNA799842_P_NODE_171860_length_244_cov_0.900585_g170287_i0	PRJNA799842	171860	244	0.900585	2.1974274	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	134	7.640000000000001e-27	NTclustered	gi\|2626233621\|emb\|OY820591.1\|	2026734	g170287	i0	77.253	75.9262295081967	233	49	95	4	8	238	2965766	2965536	MAG: Dehalococcoidia bacterium isolate bad7acc4-ca48-4abb-846f-85865ba1c961 genome assembly, chromosome: 1	blastn	18526	134	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
25020566	25020566	PRJNA799842_P_NODE_172580_length_244_cov_0.900585_g171007_i0	PRJNA799842	172580	244	0.900585	2.1974274	Anaerolineales bacterium	2073117	Bacteria	Bacteria	222	1.59e-53	NTclustered	gi\|2556895010\|gb\|CP129480.1\|	2073117	g171007	i0	83.197	1	244	39	99	2	2	244	1486142	1486384	MAG: Anaerolineales bacterium isolate cMAG.16 chromosome, complete genome	blastn	244	222	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales 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);;