metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA283169" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA283169" and tax_phylum = "Chordata"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
26598975	26598975	PRJNA283169_P_NODE_4401_length_201_cov_1.309211_g4338_i0	PRJNA283169	4401	201	1.309211	2.63151411	Hypanus sabinus	79690	Chordata	Chordata	44.3	0.00591	NR	XP_059837717.1	79690	g4338	i0	43.1	1.55223880597015	51	27	73.1	1	17	163	200	250	XP_059837717.1 uncharacterized protein LOC132400604 [Hypanus sabinus]	diamond	312	44.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Myliobatiformes	Dasyatidae	Hypanus	Hypanus sabinus
26694188	26694188	PRJNA283169_S_NODE_3481_length_161_cov_0.857143_g3467_i0	PRJNA283169	3481	161	0.857143	1.38000023	Staurois parvus	386267	Chordata	Chordata	43.9	0.00122	NR	CAI9618505.1	386267	g3467	i0	50	1.49068322981366	40	20	74.5	0	2	121	12	51	CAI9618505.1 unnamed protein product, partial [Staurois parvus]	diamond	240	43.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
30913419	30913419	PRJNA283169_P_NODE_6094_length_173_cov_1.580645_g6031_i0	PRJNA283169	6094	173	1.580645	2.73451585	Opisthokonta	33154	Chordata	Chordata	61.6	3.18e-9	NR	XP_053571958.1	8345	g6031	i0	73.7	4.59537572254335	38	10	65.9	0	58	171	1209	1246	XP_053571958.1 maestro heat-like repeat-containing protein family member 1 [Bombina bombina]	diamond	795	61.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bombinatoridae	Bombina	Bombina bombina
31008086	31008086	PRJNA283169_P_NODE_714_length_453_cov_2.002475_g652_i0	PRJNA283169	714	453	2.002475	9.07121175	root	1	Root_unresolved	Root_unresolved	171	3.2899999999999993e-46	NR	CAK8618466.1	30338	g652	i0	56.5	23.3576158940397	147	64	97.4	0	449	9	538	684	CAK8618466.1 Transposon Tf2-6 polyprotein [Bufotes viridis]	diamond	10581	172	0.994186046511628	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
32160754	32160754	PRJNA283169_P_NODE_8038_length_162_cov_0.920354_g7975_i0	PRJNA283169	8038	162	0.920354	1.49097348	Staurois parvus	386267	Chordata	Chordata	56.2	6.51e-9	NR	CAI9620946.1	386267	g7975	i0	71.4	0.648148148148148	35	10	64.8	0	161	57	25	59	CAI9620946.1 unnamed protein product [Staurois parvus]	diamond	105	56.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus

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