metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA450343" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA450343" 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
439130	439130	PRJNA450343_P_NODE_7841_length_193_cov_1.152778_g7773_i0	PRJNA450343	7841	193	1.152778	2.22486154	Deinococcus yunweiensis	367282	Bacteria	Bacteria	357	3.1499999999999996e-94	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g7773	i0	100	167.896373056995	193	0	100	0	1	193	2671674	2671866	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	32404	357	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
1092508	1092508	PRJNA450343_P_NODE_14181_length_157_cov_2.361111_g14113_i0	PRJNA450343	14181	157	2.361111	3.70694427	Deinococcus	1298	Bacteria	Bacteria	224	2.5899999999999994e-54	NTclustered	gi\|470483488\|ref\|NR_076595.1\|	310783	g14113	i0	97.037	188.757961783439	135	0	85	4	25	157	1204	1336	Deinococcus deserti strain VCD115 23S ribosomal RNA gene, complete sequence	blastn	29635	224	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus deserti
6195553	6195553	PRJNA450343_P_NODE_625_length_720_cov_1.737705_g571_i0	PRJNA450343	625	720	1.737705	12.511476	Deinococcus	1298	Bacteria	Bacteria	1046	0	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g571	i0	93.258	379.631944444444	712	44	98	4	1	709	69957	69247	Deinococcus swuensis strain DY59, complete genome	blastn	273335	1055	0.991469194312796	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
11917756	11917756	PRJNA450343_P_NODE_11470_length_166_cov_0.871795_g11402_i0	PRJNA450343	11470	166	0.871795	1.4471797	Deinococcus aetherius	200252	Bacteria	Bacteria	241	2.76e-59	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g11402	i0	92.771	11.6265060240964	166	12	100	0	1	166	3046127	3045962	Deinococcus aetherius ST0316 DNA, complete genome	blastn	1930	241	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
18290698	18290698	PRJNA450343_P_NODE_1835_length_407_cov_2.067039_g1767_i0	PRJNA450343	1835	407	2.067039	8.41284873	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	636	8.479999999999999e-178	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g1767	i0	94.853	262.334152334152	408	19	100	2	1	407	544559	544965	Deinococcus sp. NW-56 chromosome, complete genome	blastn	106770	636	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
20218708	20218708	PRJNA450343_P_NODE_10196_length_170_cov_1.495868_g10128_i0	PRJNA450343	10196	170	1.495868	2.5429756	Deinococcus	1298	Bacteria	Bacteria	309	7.64e-80	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g10128	i0	99.412	177.9	170	1	100	0	1	170	2671961	2672130	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	30243	309	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
20218719	20218719	PRJNA450343_P_NODE_5576_length_225_cov_2.522727_g5508_i0	PRJNA450343	5576	225	2.522727	5.67613575	Deinococcus	1298	Bacteria	Bacteria	309	1.08e-79	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g5508	i0	91.593	166.902222222222	226	16	100	3	1	225	236	13	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	37553	309	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis

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