metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA1016321" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA1016321" 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
19285746	19285746	PRJNA1016321_P_NODE_7556_length_740_cov_1.992504_g7355_i0	PRJNA1016321	7556	740	1.992504	14.7445296	Pediculus humanus corporis	121224	Arthropoda	Arthropoda	375	4.9799999999999996e-129	NR	XP_002426249.1	121224	g7355	i0	91.7	0.835135135135135	206	17	83.5	0	718	101	1	206	XP_002426249.1 40S ribosomal protein S6, putative [Pediculus humanus corporis]	diamond	618	375	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Psocodea	Pediculidae	Pediculus	Pediculus humanus
26908325	26908325	PRJNA1016321_P_NODE_51962_length_246_cov_0.890173_g51731_i0	PRJNA1016321	51962	246	0.890173	2.18982558	Aedes aegypti	7159	Arthropoda	Arthropoda	82.4	4.31e-16	NR	XP_021702187.1	7159	g51731	i0	55.6	0.878048780487805	72	31	86.6	1	31	243	894	965	XP_021702187.1 unconventional myosin-VIIa isoform X2 [Aedes aegypti]	diamond	216	82.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Aedes	Aedes aegypti
27161007	27161007	PRJNA1016321_P_NODE_35922_length_298_cov_1.751111_g35691_i0	PRJNA1016321	35922	298	1.751111	5.21831078	Aphis gossypii	80765	Arthropoda	Arthropoda	42.7	0.0388	NR	CAH1737507.1	80765	g35691	i0	38.5	0.523489932885906	52	28	48.3	1	136	279	12	63	CAH1737507.1 unnamed protein product [Aphis gossypii]	diamond	156	42.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Aphis	Aphis gossypii
32745522	32745522	PRJNA1016321_P_NODE_38700_length_285_cov_2.089623_g38469_i0	PRJNA1016321	38700	285	2.089623	5.95542555	Ixodes	6944	Arthropoda	Arthropoda	56.2	1.11e-6	NR	XP_040360213.1	6945	g38469	i0	38.6	7.90526315789474	88	47	92.6	1	285	22	305	385	XP_040360213.1 uncharacterized protein LOC120847811 [Ixodes scapularis]	diamond	2253	56.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Ixodidae	Ixodes	Ixodes scapularis

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