metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA890871" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA890871" 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
28508369	28508369	PRJNA890871_P_NODE_90127_length_232_cov_2.433962_g89992_i0	PRJNA890871	90127	232	2.433962	5.64679184	Cyphomyrmex costatus	456900	Arthropoda	Arthropoda	112	5.41e-30	NR	KYN02133.1	456900	g89992	i0	72.7	0.995689655172414	77	20	99.6	1	2	232	25	100	KYN02133.1 hypothetical protein ALC62_07054 [Cyphomyrmex costatus]	diamond	231	112	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Formicidae	Cyphomyrmex	Cyphomyrmex costatus
28768621	28768621	PRJNA890871_P_NODE_85827_length_241_cov_0.916667_g85692_i0	PRJNA890871	85827	241	0.916667	2.20916747	Lepidoptera	7088	Arthropoda	Arthropoda	74.7	2e-13	NR	CAG4949239.1	42296	g85692	i0	54.5	4.13278008298755	66	30	82.2	0	213	16	594	659	CAG4949239.1 unnamed protein product [Colias eurytheme]	diamond	996	75.1	0.994673768308922	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Pieridae	Colias	Colias eurytheme
28982121	28982121	PRJNA890871_P_NODE_21948_length_351_cov_4.733813_g21813_i0	PRJNA890871	21948	351	4.733813	16.61568363	Armadillidium vulgare	13347	Arthropoda	Arthropoda	44.7	0.0245	NR	RXG52979.1	13347	g21813	i0	34.3	0.598290598290598	70	41	55.6	2	90	284	209	278	RXG52979.1 hypothetical protein Avbf_07865 [Armadillidium vulgare]	diamond	210	44.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Isopoda	Armadillidiidae	Armadillidium	Armadillidium vulgare
29834439	29834439	PRJNA890871_P_NODE_80291_length_243_cov_1.805882_g80156_i0	PRJNA890871	80291	243	1.805882	4.38829326	Dermatophagoides farinae	6954	Arthropoda	Arthropoda	125	6.01e-34	NR	KAH9493819.1	6954	g80156	i0	78.8	0.987654320987654	80	17	98.8	0	1	240	48	127	KAH9493819.1 hypothetical protein DERF_014547 [Dermatophagoides farinae]	diamond	240	125	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Pyroglyphidae	Dermatophagoides	Dermatophagoides farinae
29960756	29960756	PRJNA890871_P_NODE_8291_length_529_cov_4.567982_g8156_i0	PRJNA890871	8291	529	4.567982	24.16462478	Lasius niger	67767	Arthropoda	Arthropoda	229	6.479999999999999e-72	NR	KMQ83476.1	67767	g8156	i0	69.1	0.992438563327032	175	54	99.2	0	3	527	56	230	KMQ83476.1 spfh band 7 phb domain protein [Lasius niger]	diamond	525	229	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Formicidae	Lasius	Lasius niger
30718969	30718969	PRJNA890871_P_NODE_62714_length_251_cov_1.235955_g62579_i0	PRJNA890871	62714	251	1.235955	3.10224705	Blattella germanica	6973	Arthropoda	Arthropoda	125	1.1499999999999999e-32	NR	PSN43849.1	6973	g62579	i0	98.3	3.58565737051793	60	1	71.7	0	251	72	78	137	PSN43849.1 hypothetical protein C0J52_11883 [Blattella germanica]	diamond	900	125	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Blattodea	Blattellidae	Blattella	Blattella germanica
31667334	31667334	PRJNA890871_P_NODE_54997_length_260_cov_1.566845_g54862_i0	PRJNA890871	54997	260	1.566845	4.073797	Homalodisca vitripennis	197043	Arthropoda	Arthropoda	157	2.2399999999999992e-43	NR	KAG8247866.1	197043	g54862	i0	84.7	3.92307692307692	85	13	98.1	0	2	256	306	390	KAG8247866.1 hypothetical protein J6590_052285 [Homalodisca vitripennis]	diamond	1020	157	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Cicadellidae	Homalodisca	Homalodisca vitripennis
32836676	32836676	PRJNA890871_P_NODE_92560_length_226_cov_2.013072_g92425_i0	PRJNA890871	92560	226	2.013072	4.54954272	Allacma fusca	39272	Arthropoda	Arthropoda	111	1.74e-26	NR	CAG7725366.1	39272	g92425	i0	86.3	0.676991150442478	51	7	67.7	0	2	154	16032	16082	CAG7725366.1 unnamed protein product [Allacma fusca]	diamond	153	111	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Collembola	Symphypleona	Sminthuridae	Allacma	Allacma fusca

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