metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA638724" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA638724" 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
4437304	4437304	PRJNA638724_P_NODE_1924_length_427_cov_3.110169_g1838_i0	PRJNA638724	1924	427	3.110169	13.28042163	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	617	3.24e-172	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g1838	i0	93.317	243.412177985948	419	26	98	2	1	418	2417237	2417654	Deinococcus sp. NW-56 chromosome, complete genome	blastn	103937	617	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
4983571	4983571	PRJNA638724_P_NODE_5124_length_281_cov_4.865385_g5038_i0	PRJNA638724	5124	281	4.865385	13.67173185	Deinococcus	1298	Bacteria	Bacteria	459	1.31e-124	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g5038	i0	97.398	231.391459074733	269	7	96	0	1	269	2341518	2341786	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	65021	459	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
5713214	5713214	PRJNA638724_P_NODE_3345_length_337_cov_2.829545_g3259_i0	PRJNA638724	3345	337	2.829545	9.53556665	Deinococcus ficus	317577	Bacteria	Bacteria	540	5.569999999999999e-149	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g3259	i0	96.364	237.836795252226	330	9	97	3	11	337	2341542	2341213	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	80151	540	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
5713219	5713219	PRJNA638724_P_NODE_725_length_635_cov_2.380783_g642_i0	PRJNA638724	725	635	2.380783	15.11797205	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	902	0	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g642	i0	92.812	312.544881889764	626	40	98	5	11	635	543219	543840	Deinococcus sp. NW-56 chromosome, complete genome	blastn	198466	902	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
16458080	16458080	PRJNA638724_P_NODE_3293_length_339_cov_2.293233_g3207_i0	PRJNA638724	3293	339	2.293233	7.77405987	Deinococcus	1298	Bacteria	Bacteria	497	3.42e-136	NTclustered	gi\|389546753\|gb\|JQ401681.1\|	158789	g3207	i0	93.921	102.967551622419	329	20	97	0	1	329	422	94	Uncultured Deinococcus sp. clone CNY_01851 16S ribosomal RNA gene, partial sequence	blastn	34906	497	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	uncultured Deinococcus sp.
19006845	19006845	PRJNA638724_P_NODE_7295_length_243_cov_2.005882_g7209_i0	PRJNA638724	7295	243	2.005882	4.87429326	Deinococcus	1298	Bacteria	Bacteria	392	1.14e-104	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g7209	i0	97.021	187.617283950617	235	3	96	4	11	243	2578	2810	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	45591	392	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);;