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

5 rows where analysis = "blastn", bioproject = "PRJNA309466" 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
4890895	4890895	PRJNA309466_P_NODE_15384_length_169_cov_2.650000_g15327_i0	PRJNA309466	15384	169	2.65	4.4785	Deinococcus	1298	Bacteria	Bacteria	219	1.3099999999999999e-52	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g15327	i0	95.62	131.976331360947	137	4	80	2	34	169	2271	2406	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	22304	219	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
4891021	4891021	PRJNA309466_P_NODE_4344_length_276_cov_5.453744_g4288_i0	PRJNA309466	4344	276	5.453744	15.05233344	Deinococcus	1298	Bacteria	Bacteria	496	9.75e-136	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g4288	i0	99.631	181.507246376812	271	1	98	0	6	276	597	327	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	50096	501	0.99001996007984	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
11855497	11855497	PRJNA309466_P_NODE_5430_length_250_cov_1.263682_g5373_i0	PRJNA309466	5430	250	1.263682	3.159205	Deinococcus geothermalis	68909	Bacteria	Bacteria	435	1.92e-117	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g5373	i0	98.77	0.976	244	3	98	0	4	247	2006979	2007222	Deinococcus geothermalis DSM 11300, complete genome	blastn	244	435	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
11855522	11855522	PRJNA309466_P_NODE_8170_length_214_cov_2.993939_g8113_i0	PRJNA309466	8170	214	2.993939	6.40702946	Deinococcus altitudinis	468914	Bacteria	Bacteria	276	1.03e-69	NTclustered	gi\|2865404944\|gb\|CP129415.1\|	468914	g8113	i0	90.141	15.5514018691589	213	19	99	2	3	214	414028	413817	Deinococcus altitudinis strain LMG 24022 chromosome, complete genome	blastn	3328	276	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus altitudinis
16365575	16365575	PRJNA309466_P_NODE_2293_length_444_cov_3.764557_g2237_i0	PRJNA309466	2293	444	3.764557	16.71463308	Deinococcus	1298	Bacteria	Bacteria	804	0	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g2237	i0	100	234.504504504504	435	0	98	0	7	441	1793	1359	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	104120	804	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis

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