metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJEB29441" and tax

9 rows where analysis = "diamond", bioproject = "PRJEB29441" 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
11504749	11504749	PRJEB29441_P_NODE_36190_length_173_cov_2.056452_g35749_i0	PRJEB29441	36190	173	2.056452	3.55766196	Aethina tumida	116153	Arthropoda	Arthropoda	75.5	4.13e-14	NR	XP_049817035.1	116153	g35749	i0	67.9	1.83815028901734	53	17	91.9	0	1	159	336	388	XP_049817035.1 sodium/potassium-transporting ATPase subunit alpha-like [Aethina tumida]	diamond	318	75.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Nitidulidae	Aethina	Aethina tumida
27475663	27475663	PRJEB29441_P_NODE_34003_length_179_cov_1.884615_g33562_i0	PRJEB29441	34003	179	1.884615	3.37346085	Anthophora plagiata	597819	Arthropoda	Arthropoda	43.9	0.0061	NR	CAK9813121.1	597819	g33562	i0	48.6	2.93296089385475	35	18	58.7	0	157	53	222	256	CAK9813121.1 Transposable element Tc1 transposase [Anthophora plagiata]	diamond	525	44.3	0.99097065462754	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Anthophora	Anthophora plagiata
28384765	28384765	PRJEB29441_P_NODE_28866_length_195_cov_1.397260_g28425_i0	PRJEB29441	28866	195	1.39726	2.724657	Arthropoda	6656	Arthropoda	Arthropoda	48.9	1.36e-4	NR	XP_016658134.1	7029	g28425	i0	34.8	5.50769230769231	69	33	87.7	1	195	25	717	785	XP_016658134.1 uncharacterized protein LOC107883144 [Acyrthosiphon pisum]	diamond	1074	49.3	0.991886409736308	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Acyrthosiphon	Acyrthosiphon pisum
28889894	28889894	PRJEB29441_P_NODE_45968_length_162_cov_0.902655_g45527_i0	PRJEB29441	45968	162	0.902655	1.4623011	Insecta	50557	Arthropoda	Arthropoda	48.1	1.5e-4	NR	CAD7576871.1	61474	g45527	i0	60.5	3.72222222222222	38	15	70.4	0	26	139	201	238	CAD7576871.1 unnamed protein product [Timema californicum]	diamond	603	48.5	0.991752577319588	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema californicum
29180856	29180856	PRJEB29441_P_NODE_19789_length_240_cov_1.068063_g19348_i0	PRJEB29441	19789	240	1.068063	2.5633512	Episyrphus balteatus	286459	Arthropoda	Arthropoda	96.7	3.89e-21	NR	XP_055840663.1	286459	g19348	i0	70.5	2.4125	61	18	76.3	0	183	1	579	639	XP_055840663.1 uncharacterized protein LOC129908283 [Episyrphus balteatus]	diamond	579	96.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Syrphidae	Episyrphus	Episyrphus balteatus
30349760	30349760	PRJEB29441_P_NODE_45732_length_162_cov_0.902655_g45291_i0	PRJEB29441	45732	162	0.902655	1.4623011	Stomoxys calcitrans	35570	Arthropoda	Arthropoda	53.9	1.38e-6	NR	XP_059220721.1	35570	g45291	i0	49	3.77777777777778	51	26	94.4	0	157	5	1	51	XP_059220721.1 arylphorin subunit A4-like [Stomoxys calcitrans]	diamond	612	53.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Muscidae	Stomoxys	Stomoxys calcitrans
30696653	30696653	PRJEB29441_P_NODE_40834_length_166_cov_0.871795_g40393_i0	PRJEB29441	40834	166	0.871795	1.4471797	Tyrophagus putrescentiae	59818	Arthropoda	Arthropoda	77.8	5.77e-15	NR	KAH9399200.1	59818	g40393	i0	100	0.596385542168675	33	0	59.6	0	165	67	508	540	KAH9399200.1 hypothetical protein TYRP_018108 [Tyrophagus putrescentiae]	diamond	99	77.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Acaridae	Tyrophagus	Tyrophagus putrescentiae
32278059	32278059	PRJEB29441_P_NODE_31639_length_186_cov_1.489051_g31198_i0	PRJEB29441	31639	186	1.489051	2.76963486	Pediculus humanus corporis	121224	Arthropoda	Arthropoda	73.6	2.33e-13	NR	XP_002432713.1	121224	g31198	i0	52.5	4.88709677419355	61	29	98.4	0	185	3	144	204	XP_002432713.1 basic juvenile hormone sensitive hemolymph protein two, putative [Pediculus humanus corporis]	diamond	909	73.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Psocodea	Pediculidae	Pediculus	Pediculus humanus
32531149	32531149	PRJEB29441_P_NODE_47039_length_161_cov_0.910714_g46598_i0	PRJEB29441	47039	161	0.910714	1.46624954	Notodromas monacha	399045	Arthropoda	Arthropoda	67.8	1.74e-11	NR	CAD7274932.1	399045	g46598	i0	62.3	6.98757763975155	53	18	98.8	1	159	1	255	305	CAD7274932.1 unnamed protein product [Notodromas monacha]	diamond	1125	67.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Cyprididae	Notodromas	Notodromas monacha

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