metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA638138" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA638138" 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
6258812	6258812	PRJNA638138_P_NODE_11605_length_313_cov_1.283333_g11390_i0	PRJNA638138	11605	313	1.283333	4.01683229	Deinococcus	1298	Bacteria	Bacteria	451	2.4700000000000003e-122	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g11390	i0	92.675	274.08945686901	314	22	100	1	1	313	71189	70876	Deinococcus swuensis strain DY59, complete genome	blastn	85790	451	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
10813473	10813473	PRJNA638138_P_NODE_15209_length_281_cov_0.956731_g14994_i0	PRJNA638138	15209	281	0.956731	2.68841411	Deinococcus ficus	317577	Bacteria	Bacteria	442	1.3199999999999993e-119	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g14994	i0	95.018	171.423487544484	281	14	100	0	1	281	2341346	2341626	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	48170	442	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
11358617	11358617	PRJNA638138_P_NODE_15309_length_280_cov_1.115942_g15094_i0	PRJNA638138	15309	280	1.115942	3.1246376	Deinococcus	1298	Bacteria	Bacteria	433	7.89e-117	NTclustered	gi\|470483488\|ref\|NR_076595.1\|	310783	g15094	i0	95.572	243.935714285714	271	11	97	1	1	271	1154	1423	Deinococcus deserti strain VCD115 23S ribosomal RNA gene, complete sequence	blastn	68302	433	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus deserti
12088837	12088837	PRJNA638138_P_NODE_28690_length_245_cov_0.895349_g28475_i0	PRJNA638138	28690	245	0.895349	2.19360505	Deinococcus ficus	317577	Bacteria	Bacteria	442	1.1199999999999994e-119	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g28475	i0	99.184	11.8857142857143	245	2	100	0	1	245	2685178	2685422	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	2912	442	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
24107193	24107193	PRJNA638138_P_NODE_26759_length_246_cov_1.329480_g26544_i0	PRJNA638138	26759	246	1.32948	3.2705208	Deinococcus	1298	Bacteria	Bacteria	239	1.59e-58	NTclustered	gi\|470483488\|ref\|NR_076595.1\|	310783	g26544	i0	84.146	190.142276422764	246	39	100	0	1	246	174	419	Deinococcus deserti strain VCD115 23S ribosomal RNA gene, complete sequence	blastn	46775	239	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus deserti

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