metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA853203" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA853203" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
841328	841328	PRJNA853203_P_NODE_14861_length_277_cov_1.661765_g14712_i0	PRJNA853203	14861	277	1.661765	4.60308905	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	311	3.81e-80	NTclustered	gi\|2874253725\|emb\|OY969567.1\|	1672391	g14712	i0	87.273	186.357400722022	275	31	99	4	2	275	2429185	2428914	MAG: uncultured Chloroflexia bacterium isolate MFD01561.bin.c.1 genome assembly, chromosome: 1	blastn	51621	311	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
841329	841329	PRJNA853203_P_NODE_14921_length_277_cov_1.529412_g14772_i0	PRJNA853203	14921	277	1.529412	4.23647124	Herpetosiphon aurantiacus	65	Bacteria	Bacteria	451	2.15e-122	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g14772	i0	96.029	1	277	11	100	0	1	277	137196	136920	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	277	451	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
2116755	2116755	PRJNA853203_P_NODE_2042_length_433_cov_1.455556_g1895_i0	PRJNA853203	2042	433	1.455556	6.30255748	Anaerolineales bacterium	2073117	Bacteria	Bacteria	771	0	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g1895	i0	98.843	385.039260969977	432	5	99	0	1	432	2029102	2028671	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	166722	771	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
2116968	2116968	PRJNA853203_P_NODE_5502_length_326_cov_3.806324_g5353_i0	PRJNA853203	5502	326	3.806324	12.40861624	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	361	4.4799999999999996e-95	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g5353	i0	86.89	118.981595092025	328	36	100	7	1	326	2828884	2829206	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	38788	361	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
3391987	3391987	PRJNA853203_P_NODE_10583_length_287_cov_2.093458_g10434_i0	PRJNA853203	10583	287	2.093458	6.00822446	Herpetosiphon aurantiacus	65	Bacteria	Bacteria	283	8.64e-72	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g10434	i0	84.859	1.12543554006969	284	39	98	4	6	287	1486737	1486456	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	323	283	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
3392140	3392140	PRJNA853203_P_NODE_33263_length_249_cov_1.772727_g33114_i0	PRJNA853203	33263	249	1.772727	4.41409023	Chloroflexota bacterium	2026724	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2621702192\|emb\|OY760183.1\|	2026724	g33114	i0	97.059	1.17670682730924	34	0	14	1	195	228	88044	88076	MAG: Chloroflexota bacterium isolate 1e5240b1-722b-4dd6-bc08-6f4f73fd4587 genome assembly, chromosome: 1	blastn	293	56.5	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
3392264	3392264	PRJNA853203_P_NODE_6423_length_314_cov_0.970954_g6274_i0	PRJNA853203	6423	314	0.970954	3.04879556	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	259	1.6100000000000002e-64	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g6274	i0	82.026	81.4394904458599	306	53	97	2	8	312	4104562	4104258	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	25572	259	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
5944723	5944723	PRJNA853203_P_NODE_4365_length_347_cov_1.562044_g4216_i0	PRJNA853203	4365	347	1.562044	5.42029268	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	213	1.42e-50	NTclustered	gi\|2893358390\|emb\|OZ220681.1\|	2026734	g4216	i0	83.913	79.7291066282421	230	29	65	7	10	235	461344	461119	MAG: Dehalococcoidia bacterium isolate b3870ce4-b2c0-4886-bd94-d5608d47d969 genome assembly, chromosome: 1	blastn	27666	213	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
7612638	7612638	PRJNA853203_P_NODE_1046_length_600_cov_2.529412_g899_i0	PRJNA853203	1046	600	2.529412	15.176472	Phototrophicus	2922426	Bacteria	Bacteria	363	2.4199999999999994e-95	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g899	i0	78.197	55.0483333333333	610	103	100	22	1	600	2828568	2827979	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	33029	364	0.997252747252747	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
8494476	8494476	PRJNA853203_P_NODE_47667_length_242_cov_0.923077_g47518_i0	PRJNA853203	47667	242	0.923077	2.23384634	Herpetosiphon aurantiacus	65	Bacteria	Bacteria	78.7	3.6e-10	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g47518	i0	92.593	0.504132231404959	54	4	38	0	181	234	4371757	4371704	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	122	78.7	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
9769386	9769386	PRJNA853203_P_NODE_17228_length_272_cov_1.547739_g17079_i0	PRJNA853203	17228	272	1.547739	4.20985008	Anaerolineales bacterium	2073117	Bacteria	Bacteria	388	1.67e-103	NTclustered	gi\|2556899361\|gb\|CP129481.1\|	2073117	g17079	i0	92.593	108.069852941176	270	20	99	0	3	272	1232422	1232691	MAG: Anaerolineales bacterium isolate cMAG.15 chromosome, complete genome	blastn	29395	388	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
9769564	9769564	PRJNA853203_P_NODE_41308_length_245_cov_0.906977_g41159_i0	PRJNA853203	41308	245	0.906977	2.22209365	Chloroflexota bacterium	2026724	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2108392809\|gb\|CP070642.1\|	2026724	g41159	i0	100	0.118367346938776	29	0	12	0	52	80	678055	678027	MAG: Chloroflexi bacterium isolate bin905 chromosome	blastn	29	54.7	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
11045248	11045248	PRJNA853203_P_NODE_48549_length_239_cov_2.777108_g48400_i0	PRJNA853203	48549	239	2.777108	6.63728812	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	178	3.4e-40	NTclustered	gi\|2891482139\|emb\|OZ219872.1\|	2026734	g48400	i0	81.659	140.769874476987	229	29	95	7	10	236	448963	449180	MAG: Dehalococcoidia bacterium isolate adc01b0e-c114-4b94-a05b-fd73c1a39460 genome assembly, chromosome: 6	blastn	33644	178	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
12320769	12320769	PRJNA853203_P_NODE_450_length_991_cov_1.596950_g334_i0	PRJNA853203	450	991	1.59695	15.8257745	Anaerolineales bacterium	2073117	Bacteria	Bacteria	1720	0	NTclustered	gi\|2556903179\|gb\|CP129482.1\|	2073117	g334	i0	97.984	439.708375378406	992	19	100	1	1	991	3065475	3066466	MAG: Anaerolineales bacterium isolate cMAG.14 chromosome, complete genome	blastn	435751	1720	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
13595137	13595137	PRJNA853203_P_NODE_23911_length_258_cov_1.345946_g23762_i0	PRJNA853203	23911	258	1.345946	3.47254068	uncultured sludge bacterium S41	117462	Bacteria	Bacteria	468	1.97e-127	NTclustered	gi\|13171292\|gb\|AF234734.1\|	117462	g23762	i0	99.225	99.8875968992248	258	2	100	0	1	258	226	483	Uncultured sludge bacterium S41 16S ribosomal RNA gene, partial sequence	blastn	25771	468	1	Bacteria		Bacillati	Chloroflexota					uncultured sludge bacterium S41
13595271	13595271	PRJNA853203_P_NODE_40731_length_245_cov_1.813953_g40582_i0	PRJNA853203	40731	245	1.813953	4.44418485	Herpetosiphon aurantiacus	65	Bacteria	Bacteria	278	3.35e-70	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g40582	i0	87.764	0.96734693877551	237	29	97	0	1	237	4430110	4430346	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	237	278	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
16144134	16144134	PRJNA853203_P_NODE_21933_length_262_cov_1.481481_g21784_i0	PRJNA853203	21933	262	1.481481	3.88148022	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	219	2.2299999999999994e-52	NTclustered	gi\|2891482139\|emb\|OZ219872.1\|	2026734	g21784	i0	81.923	237.25572519084	260	45	99	2	1	259	446558	446300	MAG: Dehalococcoidia bacterium isolate adc01b0e-c114-4b94-a05b-fd73c1a39460 genome assembly, chromosome: 6	blastn	62161	219	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
17419811	17419811	PRJNA853203_P_NODE_7874_length_298_cov_1.391111_g7725_i0	PRJNA853203	7874	298	1.391111	4.14551078	Anaerolineales bacterium	2073117	Bacteria	Bacteria	490	4.95e-134	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g7725	i0	96.309	223.345637583893	298	11	100	0	1	298	2030636	2030933	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	66557	490	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
19967953	19967953	PRJNA853203_P_NODE_23796_length_258_cov_1.572973_g23647_i0	PRJNA853203	23796	258	1.572973	4.05827034	Herpetosiphon aurantiacus	65	Bacteria	Bacteria	254	6e-63	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g23647	i0	84.646	0.984496124031008	254	39	98	0	5	258	4756915	4756662	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	254	254	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
21243524	21243524	PRJNA853203_P_NODE_30297_length_251_cov_0.876404_g30148_i0	PRJNA853203	30297	251	0.876404	2.19977404	Herpetosiphon aurantiacus	65	Bacteria	Bacteria	298	2.65e-76	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g30148	i0	88.048	1	251	30	100	0	1	251	4614530	4614780	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	251	298	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
25067533	25067533	PRJNA853203_P_NODE_26500_length_253_cov_1.311111_g26351_i0	PRJNA853203	26500	253	1.311111	3.31711083	Herpetosiphon aurantiacus	65	Bacteria	Bacteria	300	7.43e-77	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g26351	i0	88.095	0.99604743083004	252	30	99	0	1	252	1473810	1473559	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	252	300	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
25461309	25461309	PRJNA853203_P_NODE_22440_length_261_cov_1.377660_g22291_i0	PRJNA853203	22440	261	1.37766	3.5956926	Chloroflexus	1107	Bacteria	Bacteria	315	2.75e-81	NTclustered	gi\|470483916\|ref\|NR_076619.1\|	152260	g22291	i0	88.716	32.639846743295	257	29	98	0	1	257	2680	2936	Chloroflexus aggregans strain MD-66 23S ribosomal RNA gene, complete sequence	blastn	8519	315	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aggregans

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