metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA641707" and tax_clade = "Candidatus Thermofonsia Clade 3"

14 rows where analysis = "blastn", bioproject = "PRJNA641707" and tax_clade = "Candidatus Thermofonsia Clade 3"

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_genus	tax_species
613025	613025	PRJNA641707_P_NODE_199221_length_197_cov_10.209459_g196558_i0	PRJNA641707	199221	197	10.209459	20.11263423	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	93.5	1.01e-14	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g196558	i0	98.113	48.0406091370558	53	1	27	0	144	196	3492420	3492472	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	9464	93.5	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
615939	615939	PRJNA641707_P_NODE_32501_length_379_cov_666.203030_g29887_i0	PRJNA641707	32501	379	666.20303	2524.9094837	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	401	3.1099999999999995e-107	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g29887	i0	89.164	181.306068601583	323	34	85	1	54	376	3496990	3497311	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	68715	401	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
1892470	1892470	PRJNA641707_P_NODE_34122_length_370_cov_17.239875_g31496_i0	PRJNA641707	34122	370	17.239875	63.7875375	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	424	6.47e-114	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g31496	i0	87.738	6.21621621621622	367	39	99	6	1	365	3496053	3495691	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	2300	424	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
3168161	3168161	PRJNA641707_P_NODE_8103_length_751_cov_13.901709_g4558_i1	PRJNA641707	8103	751	13.901709	104.40183459000001	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	510	1.03e-139	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g4558	i1	81.529	75.1784287616511	628	89	82	18	1	617	3495332	3494721	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	56459	510	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
5719831	5719831	PRJNA641707_P_NODE_34645_length_368_cov_3.366771_g32018_i0	PRJNA641707	34645	368	3.366771	12.38971728	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	311	5.22e-80	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g32018	i0	90.041	60.2934782608696	241	22	85	2	1	240	3497323	3497084	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	22188	311	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
6990954	6990954	PRJNA641707_P_NODE_175326_length_200_cov_13.039735_g172663_i0	PRJNA641707	175326	200	13.039735	26.07947	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	115	2.1800000000000003e-21	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g172663	i0	87.879	16.085	99	10	49	2	3	99	2104886	2104984	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	3217	115	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
8270116	8270116	PRJNA641707_P_NODE_5967_length_867_cov_24.141809_g907_i2	PRJNA641707	5967	867	24.141809	209.30948403	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	1035	0	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g907	i2	88.364	60.4509803921569	868	91	99	10	4	867	3495418	3496279	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	52411	1035	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
9540160	9540160	PRJNA641707_P_NODE_1388_length_1526_cov_25.163169_g907_i0	PRJNA641707	1388	1526	25.163169	383.98995894	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	599	4.4599999999999985e-166	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g907	i0	88.119	34.1395806028834	505	58	72	2	629	1133	3495357	3495859	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	52097	599	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
15919687	15919687	PRJNA641707_P_NODE_6053_length_862_cov_12.547355_g4558_i0	PRJNA641707	6053	862	12.547355	108.1582001	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	462	3.3899999999999996e-125	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g4558	i0	86.682	65.2656612529002	428	43	50	11	435	862	3494919	3495332	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	56259	462	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
18465439	18465439	PRJNA641707_P_NODE_2115_length_1319_cov_20.755906_g907_i1	PRJNA641707	2115	1319	20.755906	273.77040014	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	603	2.97e-167	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g907	i1	88.294	182.122820318423	504	57	44	2	394	897	3495859	3495358	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	240220	603	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
23567021	23567021	PRJNA641707_P_NODE_257259_length_179_cov_5.346154_g254596_i0	PRJNA641707	257259	179	5.346154	9.56961566	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	237	3.9e-58	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g254596	i0	90.909	165.871508379888	176	16	98	0	4	179	3497330	3497505	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	29691	237	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
23569098	23569098	PRJNA641707_P_NODE_41819_length_336_cov_819.665505_g39178_i0	PRJNA641707	41819	336	819.665505	2754.0760968	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	407	5.869999999999999e-109	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g39178	i0	89.474	240.761904761905	323	33	96	1	11	333	3496990	3497311	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	80896	407	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
23569635	23569635	PRJNA641707_P_NODE_639_length_1962_cov_1453.224255_g49_i3	PRJNA641707	639	1962	1453.224255	28512.2598831	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	1404	0	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g49	i3	81.845	74.3511722731906	1702	280	86	23	124	1812	3496064	3494379	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	145877	1404	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.
24843088	24843088	PRJNA641707_P_NODE_56120_length_285_cov_11.728814_g53459_i0	PRJNA641707	56120	285	11.728814	33.4271199	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	350	8.34e-92	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g53459	i0	89.247	200.673684210526	279	30	98	0	2	280	3497935	3497657	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	57192	350	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia	Candidatus Roseilinea	Candidatus Roseilinea sp.

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