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

5 rows where analysis = "diamond", bioproject = "PRJNA1198392" and tax_phylum = "Arthropoda"

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
27988547	27988547	PRJNA1198392_P_NODE_12805_length_268_cov_1.579487_g12664_i0	PRJNA1198392	12805	268	1.579487	4.23302516	Daphnia pulex	6669	Arthropoda	Arthropoda	78.6	1.01e-14	NR	EFX86347.1	6669	g12664	i0	48.9	5.89925373134328	88	40	98.5	1	266	3	206	288	EFX86347.1 hypothetical protein DAPPUDRAFT_187536 [Daphnia pulex]	diamond	1581	78.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia pulex
28872500	28872500	PRJNA1198392_P_NODE_17548_length_248_cov_0.880000_g17407_i0	PRJNA1198392	17548	248	0.88	2.1824	Laodelphax striatellus	195883	Arthropoda	Arthropoda	139	4.42e-36	NR	RZF43507.1	195883	g17407	i0	100	1.76612903225806	73	0	88.3	0	220	2	548	620	RZF43507.1 hypothetical protein LSTR_LSTR005243, partial [Laodelphax striatellus]	diamond	438	139	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Delphacidae	Laodelphax	Laodelphax striatellus
29617342	29617342	PRJNA1198392_P_NODE_3070_length_430_cov_1.658263_g2929_i0	PRJNA1198392	3070	430	1.658263	7.1305309	Metazoa	33208	Arthropoda	Arthropoda	69.7	1.18e-10	NR	XP_041673640.1	29029	g2929	i0	38	3.12558139534884	121	67	83	4	71	427	512	626	XP_041673640.1 uncharacterized protein LOC121529754, partial [Drosophila eugracilis]	diamond	1344	70.1	0.994293865905849	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila eugracilis
29680515	29680515	PRJNA1198392_P_NODE_18350_length_246_cov_1.780347_g18209_i0	PRJNA1198392	18350	246	1.780347	4.37965362	root	1	Root_unresolved	Root_unresolved	113	6.6e-30	NR	EFX70935.1	6669	g18209	i0	66.7	5.91463414634146	81	27	98.8	0	244	2	63	143	EFX70935.1 hypothetical protein DAPPUDRAFT_93418 [Daphnia pulex]	diamond	1455	113	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia pulex
31969030	31969030	PRJNA1198392_P_NODE_1618_length_585_cov_1.503906_g1478_i0	PRJNA1198392	1618	585	1.503906	8.7978501	Bombyx mori	7091	Arthropoda	Arthropoda	47.4	0.0181	NR	XP_062532209.1	7091	g1478	i0	100	0.205128205128205	40	0	20.5	0	206	87	483	522	XP_062532209.1 trichohyalin [Bombyx mori]	diamond	120	47.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Bombycidae	Bombyx	Bombyx mori

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