metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA796975" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA796975" and tax_phylum = "Deinococcota"

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
781222	781222	PRJNA796975_S_NODE_5761_length_199_cov_1.193333_g5684_i0	PRJNA796975	5761	199	1.193333	2.37473267	Deinococcus aetherius	200252	Bacteria	Bacteria	239	1.24e-58	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g5684	i0	88.557	1.81407035175879	201	18	100	5	1	199	3039266	3039069	Deinococcus aetherius ST0316 DNA, complete genome	blastn	361	239	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
3768560	3768560	PRJNA796975_S_NODE_14863_length_161_cov_0.910714_g14786_i0	PRJNA796975	14863	161	0.910714	1.46624954	Thermus	270	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|2894814231\|gb\|CP178485.1\|	56957	g14786	i0	100	5	161	0	100	0	1	161	1324523	1324363	Thermus oshimai strain Blanco chromosome, complete genome	blastn	805	298	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus oshimai
4609486	4609486	PRJNA796975_S_NODE_10344_length_166_cov_0.871795_g10267_i0	PRJNA796975	10344	166	0.871795	1.4471797	Deinococcus ficus	317577	Bacteria	Bacteria	215	1.68e-51	NTclustered	gi\|1220365372\|gb\|CP021083.1\|	317577	g10267	i0	91.139	0.951807228915663	158	14	95	0	9	166	28624	28467	Deinococcus ficus strain CC-FR2-10 plasmid pDFI2, complete sequence	blastn	158	215	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
5044977	5044977	PRJNA796975_S_NODE_13004_length_163_cov_0.894737_g12927_i0	PRJNA796975	13004	163	0.894737	1.45842131	Deinococcus	1298	Bacteria	Bacteria	294	2.04e-75	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g12927	i0	99.383	175.59509202454	162	1	99	0	2	163	1964194	1964355	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	28622	294	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
5884649	5884649	PRJNA796975_S_NODE_10025_length_167_cov_0.864407_g9948_i0	PRJNA796975	10025	167	0.864407	1.44355969	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|1435319096\|gb\|CP031163.1\|	980427	g9948	i0	100	1	167	0	100	0	1	167	350833	350999	Deinococcus wulumuqiensis strain NEB 479 plasmid pDrdI, complete sequence	blastn	167	309	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
5884696	5884696	PRJNA796975_S_NODE_13545_length_163_cov_0.894737_g13468_i0	PRJNA796975	13545	163	0.894737	1.45842131	Deinococcus aetherius	200252	Bacteria	Bacteria	195	2.13e-45	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g13468	i0	88.679	0.975460122699387	159	18	98	0	1	159	1596228	1596386	Deinococcus aetherius ST0316 DNA, complete genome	blastn	159	195	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
5884754	5884754	PRJNA796975_S_NODE_5845_length_198_cov_1.026846_g5768_i0	PRJNA796975	5845	198	1.026846	2.03315508	Deinococcus aetherius	200252	Bacteria	Bacteria	233	5.71e-57	NTclustered	gi\|2281898193\|dbj\|AP026561.1\|	200252	g5768	i0	87.879	3	198	24	100	0	1	198	71167	70970	Deinococcus aetherius ST0316 plasmid pDAETH-1 DNA, complete genome	blastn	594	233	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
10985125	10985125	PRJNA796975_S_NODE_10169_length_166_cov_1.572650_g10092_i0	PRJNA796975	10169	166	1.57265	2.610599	Deinococcus aetherius	200252	Bacteria	Bacteria	211	2.17e-50	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g10092	i0	89.697	9.56626506024096	165	17	99	0	2	166	3038755	3038591	Deinococcus aetherius ST0316 DNA, complete genome	blastn	1588	211	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
10985168	10985168	PRJNA796975_S_NODE_14009_length_162_cov_0.902655_g13932_i0	PRJNA796975	14009	162	0.902655	1.4623011	Deinococcus aetherius	200252	Bacteria	Bacteria	222	9.709999999999999e-54	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g13932	i0	91.358	20.179012345679	162	14	100	0	1	162	3104837	3104998	Deinococcus aetherius ST0316 DNA, complete genome	blastn	3269	222	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
10985174	10985174	PRJNA796975_S_NODE_14489_length_162_cov_0.902655_g14412_i0	PRJNA796975	14489	162	0.902655	1.4623011	Deinococcus aetherius	200252	Bacteria	Bacteria	189	9.85e-44	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g14412	i0	87.654	1	162	20	100	0	1	162	1078016	1078177	Deinococcus aetherius ST0316 DNA, complete genome	blastn	162	189	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
11420734	11420734	PRJNA796975_S_NODE_13749_length_162_cov_1.433628_g13672_i0	PRJNA796975	13749	162	1.433628	2.32247736	Deinococcus	1298	Bacteria	Bacteria	233	4.49e-57	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g13672	i0	92.593	64.9197530864197	162	12	100	0	1	162	2113158	2113319	Deinococcus sp. NW-56 chromosome, complete genome	blastn	10517	233	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
14809698	14809698	PRJNA796975_S_NODE_12652_length_164_cov_0.886957_g12575_i0	PRJNA796975	12652	164	0.886957	1.45460948	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	287	3.45e-73	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g12575	i0	98.171	2	164	3	100	0	1	164	239797	239634	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	328	287	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
15245243	15245243	PRJNA796975_S_NODE_11072_length_165_cov_1.275862_g10995_i0	PRJNA796975	11072	165	1.275862	2.1051723	Meiothermus	65551	Bacteria	Bacteria	254	3.52e-63	NTclustered	gi\|290469363\|gb\|CP001743.1\|	504728	g10995	i0	94.512	3.16969696969697	164	9	99	0	1	164	1064029	1063866	Meiothermus ruber DSM 1279, complete genome	blastn	523	254	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
19907997	19907997	PRJNA796975_S_NODE_12936_length_163_cov_1.087719_g12859_i0	PRJNA796975	12936	163	1.087719	1.77298197	Deinococcus aetherius	200252	Bacteria	Bacteria	196	5.93e-46	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g12859	i0	88.344	12	163	19	100	0	1	163	3119638	3119800	Deinococcus aetherius ST0316 DNA, complete genome	blastn	1956	196	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
19908008	19908008	PRJNA796975_S_NODE_14096_length_162_cov_0.902655_g14019_i0	PRJNA796975	14096	162	0.902655	1.4623011	Trueperaceae bacterium	2026798	Bacteria	Bacteria	171	3.57e-38	NTclustered	gi\|2621706202\|emb\|OY764543.1\|	2026798	g14019	i0	86.842	72.1851851851852	152	20	94	0	1	152	1388872	1388721	MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1	blastn	11694	171	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
21183619	21183619	PRJNA796975_S_NODE_12017_length_164_cov_0.886957_g11940_i0	PRJNA796975	12017	164	0.886957	1.45460948	Deinococcus aetherius	200252	Bacteria	Bacteria	119	1.33e-22	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g11940	i0	82.857	0.853658536585366	140	16	85	5	25	164	1356900	1356769	Deinococcus aetherius ST0316 DNA, complete genome	blastn	140	119	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
21618966	21618966	PRJNA796975_S_NODE_13337_length_163_cov_0.894737_g13260_i0	PRJNA796975	13337	163	0.894737	1.45842131	Deinococcus	1298	Bacteria	Bacteria	230	5.8499999999999985e-56	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g13260	i0	92.025	95.7239263803681	163	13	100	0	1	163	2590094	2589932	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	15603	230	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
24168481	24168481	PRJNA796975_S_NODE_4399_length_219_cov_0.970588_g4322_i0	PRJNA796975	4399	219	0.970588	2.12558772	Deinococcus	1298	Bacteria	Bacteria	172	1.43e-38	NTclustered	gi\|1220364820\|gb\|CP021082.1\|	317577	g4322	i0	81.532	4.84474885844749	222	29	100	7	1	219	190674	190462	Deinococcus ficus strain CC-FR2-10 plasmid pDFI1, complete sequence	blastn	1061	172	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus

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