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

5 rows where analysis = "blastn", bioproject = "PRJNA914897" 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
4723372	4723372	PRJNA914897_P_NODE_23184_length_343_cov_1.814815_g22760_i0	PRJNA914897	23184	343	1.814815	6.22481545	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	424	5.97e-114	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g22760	i0	89.049	175.446064139942	347	30	100	8	1	343	1361266	1360924	Deinococcus sp. QL22 chromosome, complete genome	blastn	60178	424	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
14922810	14922810	PRJNA914897_P_NODE_2772_length_1175_cov_2.183303_g2538_i0	PRJNA914897	2772	1175	2.183303	25.65381025	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	1724	0	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g2538	i0	93.209	252.912340425532	1178	70	100	10	1	1175	1509056	1507886	Deinococcus sp. QL22 chromosome, complete genome	blastn	297172	1724	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
16197738	16197738	PRJNA914897_P_NODE_25273_length_324_cov_2.135458_g24849_i0	PRJNA914897	25273	324	2.135458	6.91888392	Deinococcus radiophilus	32062	Bacteria	Bacteria	494	4.21e-135	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g24849	i0	94.462	201.722222222222	325	11	100	6	1	324	2018524	2018842	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	65358	494	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
16553489	16553489	PRJNA914897_P_NODE_39593_length_246_cov_0.890173_g39169_i0	PRJNA914897	39593	246	0.890173	2.18982558	Deinococcus	1298	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|545344372\|gb\|KF507604.1\|	158789	g39169	i0	99.593	99.0609756097561	246	1	100	0	1	246	195	440	Uncultured Deinococcus sp. clone 7270 16S ribosomal RNA gene, partial sequence	blastn	24369	449	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	uncultured Deinococcus sp.
17473179	17473179	PRJNA914897_P_NODE_4014_length_997_cov_1.111472_g3723_i0	PRJNA914897	4014	997	1.111472	11.08137584	Thermotoga caldifontis	1508419	Bacteria	Bacteria	62.1	1.68e-4	NTclustered	gi\|597439397\|dbj\|AP014509.1\|	1408159	g3723	i0	94.872	0.0391173520561685	39	2	4	0	163	201	240180	240218	Thermotoga caldifontis AZM44c09 DNA, complete genome	blastn	39	62.1	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga caldifontis

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