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

5 rows where analysis = "diamond", bioproject = "PRJEB65099" 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
18845526	18845526	PRJEB65099_P_NODE_6175_length_246_cov_0.901734_g6070_i0	PRJEB65099	6175	246	0.901734	2.21826564	Uloborus diversus	327109	Arthropoda	Arthropoda	118	5.710000000000001e-29	NR	XP_054711886.1	327109	g6070	i0	67.9	2.9390243902439	81	25	98.8	1	245	3	263	342	XP_054711886.1 aldehyde dehydrogenase, mitochondrial-like [Uloborus diversus]	diamond	723	118	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Uloboridae	Uloborus	Uloborus diversus
26812423	26812423	PRJEB65099_P_NODE_1721_length_459_cov_1.277202_g1616_i0	PRJEB65099	1721	459	1.277202	5.86235718	Tribolium castaneum	7070	Arthropoda	Arthropoda	46.6	0.0147	NR	XP_008199173.3	7070	g1616	i0	35.8	0.830065359477124	81	49	51.6	3	158	394	470	549	XP_008199173.3 protein bride of sevenless [Tribolium castaneum]	diamond	381	47	0.991489361702128	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Tenebrionidae	Tribolium	Tribolium castaneum
29370847	29370847	PRJEB65099_P_NODE_3749_length_288_cov_1.437209_g3644_i0	PRJEB65099	3749	288	1.437209	4.13916192	Dermatophagoides pteronyssinus	6956	Arthropoda	Arthropoda	140	2.28e-36	NR	KAH9423303.1	6956	g3644	i0	98.6	0.739583333333333	71	1	74	0	213	1	91	161	KAH9423303.1 Inositol hexakisphosphate and diphosphoinositol-pentakisphosphate kinase 2 [Dermatophagoides pteronyssinus]	diamond	213	140	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Pyroglyphidae	Dermatophagoides	Dermatophagoides pteronyssinus
30381887	30381887	PRJEB65099_P_NODE_6793_length_242_cov_0.923077_g6688_i0	PRJEB65099	6793	242	0.923077	2.23384634	Artemia franciscana	6661	Arthropoda	Arthropoda	52.8	1.1e-5	NR	XP_065575607.1	6661	g6688	i0	37.3	1.41322314049587	67	38	81.8	2	198	1	89	152	XP_065575607.1 tyrosine-protein kinase Abl-like isoform X3 [Artemia franciscana]	diamond	342	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
32783547	32783547	PRJEB65099_P_NODE_4820_length_254_cov_1.723757_g4715_i0	PRJEB65099	4820	254	1.723757	4.37834278	Daphnia magna	35525	Arthropoda	Arthropoda	40.4	0.0427	NR	KZR97555.1	35525	g4715	i0	73.9	0.271653543307087	23	6	27.2	0	220	152	2	24	KZR97555.1 Uncharacterized protein APZ42_007495, partial [Daphnia magna]	diamond	69	40.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia magna

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