metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA438111" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA438111" and tax_kingdom = "Thermotogati"

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
1708971	1708971	PRJNA438111_P_NODE_34862_length_205_cov_4.454545_g34237_i0	PRJNA438111	34862	205	4.454545	9.13181725	Deinococcus taeanensis	2737050	Bacteria	Bacteria	93.5	1.05e-14	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g34237	i0	85.556	23.2682926829268	90	11	43	2	8	96	66733	66821	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	4770	93.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
2984498	2984498	PRJNA438111_P_NODE_18723_length_246_cov_5.170507_g18098_i0	PRJNA438111	18723	246	5.170507	12.71944722	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	255	1.58e-63	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g18098	i0	98.611	376.882113821138	144	2	100	0	42	185	2608809	2608952	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	92713	255	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
4918948	4918948	PRJNA438111_P_NODE_76184_length_161_cov_1.060606_g75559_i0	PRJNA438111	76184	161	1.060606	1.70757566	Truepera	332248	Bacteria	Bacteria	130	6.01e-26	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g75559	i0	91.489	1.18633540372671	94	8	58	0	53	146	967064	967157	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	191	130	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
12569627	12569627	PRJNA438111_P_NODE_71770_length_163_cov_3.179104_g71145_i0	PRJNA438111	71770	163	3.179104	5.18193952	Truepera	332248	Bacteria	Bacteria	185	1.28e-42	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g71145	i0	88.816	93.3251533742331	152	15	93	2	3	153	2466232	2466382	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	15212	185	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
13187689	13187689	PRJNA438111_P_NODE_30491_length_210_cov_4.143646_g29866_i0	PRJNA438111	30491	210	4.143646	8.7016566	Deinococcus deserti	310783	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|226316800\|gb\|CP001114.1\|	546414	g29866	i0	96.97	0.157142857142857	33	1	16	0	124	156	1842353	1842321	Deinococcus deserti VCD115, complete genome	blastn	33	56.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus deserti
13187928	13187928	PRJNA438111_P_NODE_48371_length_183_cov_4.129870_g47746_i0	PRJNA438111	48371	183	4.12987	7.5576621	Deinococcus sp. AJ005	2652443	Bacteria	Bacteria	294	2.35e-75	NTclustered	gi\|1761809830\|gb\|CP044990.1\|	2652443	g47746	i0	95.628	19.431693989071	183	8	100	0	1	183	187151	186969	Deinococcus sp. AJ005 chromosome, complete genome	blastn	3556	294	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AJ005
15736578	15736578	PRJNA438111_P_NODE_26533_length_212_cov_4.344262_g25908_i0	PRJNA438111	26533	212	4.344262	9.20983544	Deinococcus altitudinis	468914	Bacteria	Bacteria	159	1.0699999999999999e-34	NTclustered	gi\|2865408885\|gb\|CP129418.1\|	468914	g25908	i0	80.412	2.20283018867925	194	30	88	3	11	196	282240	282047	Deinococcus altitudinis strain LMG 24022 plasmid unnamed3, complete sequence	blastn	467	159	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus altitudinis
20835957	20835957	PRJNA438111_P_NODE_53077_length_178_cov_3.624161_g52452_i0	PRJNA438111	53077	178	3.624161	6.45100658	Deinococcus yunweiensis	367282	Bacteria	Bacteria	307	2.91e-79	NTclustered	gi\|2890657416\|gb\|CP177256.1\|	367282	g52452	i0	97.753	1	178	4	100	0	1	178	37445	37268	Deinococcus yunweiensis strain KCTC 3955 plasmid pDYP4, complete sequence	blastn	178	307	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
21492368	21492368	PRJNA438111_P_NODE_32797_length_209_cov_7.694444_g32172_i0	PRJNA438111	32797	209	7.694444	16.08138796	Truepera	332248	Bacteria	Bacteria	124	3.83e-24	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g32172	i0	89	0.956937799043062	100	11	48	0	110	209	862932	862833	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	200	124	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix

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