metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA675042" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA675042" 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
26638654	26638654	PRJNA675042_P_NODE_45261_length_333_cov_0.976923_g44811_i0	PRJNA675042	45261	333	0.976923	3.25315359	Thermus oshimai	56957	Bacteria	Bacteria	91.7	1.04e-20	NR	GAA6742159.1	56957	g44811	i0	60.6	0.846846846846847	94	30	78.4	1	333	73	29	122	GAA6742159.1 hypothetical protein Thermus77359_23470 [Thermus oshimai]	diamond	282	91.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus oshimai
26935499	26935499	PRJNA675042_P_NODE_89882_length_269_cov_1.326531_g89432_i0	PRJNA675042	89882	269	1.326531	3.56836839	root	1	Root_unresolved	Root_unresolved	47.8	3.99e-4	NR	GAA6742159.1	56957	g89432	i0	44.4	0.947955390334573	54	30	60.2	0	225	64	16	69	GAA6742159.1 hypothetical protein Thermus77359_23470 [Thermus oshimai]	diamond	255	47.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus oshimai
30840183	30840183	PRJNA675042_P_NODE_434_length_1914_cov_8.552960_g8_i19	PRJNA675042	434	1914	8.55296	163.7036544	Thermus oshimai	56957	Bacteria	Bacteria	100	1.55e-20	NR	GAA6742159.1	56957	g8	i19	55.1	0.184952978056426	118	53	18.5	0	868	1221	42	159	GAA6742159.1 hypothetical protein Thermus77359_23470 [Thermus oshimai]	diamond	354	100	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus oshimai
31250881	31250881	PRJNA675042_P_NODE_146475_length_246_cov_0.878613_g146025_i0	PRJNA675042	146475	246	0.878613	2.16138798	Thermus oshimai	56957	Bacteria	Bacteria	52.8	3.86e-6	NR	GAA6742159.1	56957	g146025	i0	64.7	0.414634146341463	34	12	41.5	0	15	116	1	34	GAA6742159.1 hypothetical protein Thermus77359_23470 [Thermus oshimai]	diamond	102	52.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus oshimai
32104939	32104939	PRJNA675042_P_NODE_1218_length_1183_cov_10.077477_g8_i24	PRJNA675042	1218	1183	10.077477	119.21655291	Thermus oshimai	56957	Bacteria	Bacteria	125	2.26e-30	NR	GAA6742159.1	56957	g8	i24	53.3	0.385460693153001	152	64	36.8	1	56	490	8	159	GAA6742159.1 hypothetical protein Thermus77359_23470 [Thermus oshimai]	diamond	456	125	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus oshimai
32295265	32295265	PRJNA675042_P_NODE_2059_length_928_cov_9.189474_g1707_i0	PRJNA675042	2059	928	9.189474	85.27831872	Thermus oshimai	56957	Bacteria	Bacteria	99.4	2.54e-21	NR	GAA6742159.1	56957	g1707	i0	67.4	0.517241379310345	95	24	28.4	1	154	417	28	122	GAA6742159.1 hypothetical protein Thermus77359_23470 [Thermus oshimai]	diamond	480	99.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus oshimai

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