metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA813520" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA813520" and tax_clade = "Opisthokonta"

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
12294272	12294272	PRJNA813520_S_NODE_150_length_807_cov_46.645244_g127_i0	PRJNA813520	150	807	46.645244	376.42711908	root	1	Root_unresolved	Root_unresolved	334	3.4499999999999987e-107	NR	ODN03678.1	48709	g127	i0	68.2	166.617100371747	242	73	88.8	3	91	807	6	246	ODN03678.1 Heat shock 70 kDa protein [Orchesella cincta]	diamond	134460	337	0.991097922848665	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Collembola	Entomobryomorpha	Orchesellidae	Orchesella	Orchesella cincta
17393401	17393401	PRJNA813520_S_NODE_14_length_2143_cov_21.780984_g11_i0	PRJNA813520	14	2143	21.780984	466.76648712	Metazoa	33208	Brachiopoda	other_Eukaryota	410	3.4499999999999986e-130	NR	XP_013400629.1	7574	g11	i0	57.4	71.5506299580028	364	138	48.6	2	4	1044	236	599	XP_013400629.1 heat shock cognate 71 kDa protein [Lingula anatina]	diamond	153333	414	0.990338164251208	Eukaryota	Opisthokonta	Metazoa	Brachiopoda	Lingulata	Lingulida	Lingulidae	Lingula	Lingula anatina
27947551	27947551	PRJNA813520_S_NODE_1805_length_271_cov_3.223140_g1758_i0	PRJNA813520	1805	271	3.22314	8.7347094	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	59.7	5.19e-8	NR	VDK74789.1	60516	g1758	i0	37.6	10.5830258302583	85	51	91.9	1	21	269	123	207	VDK74789.1 unnamed protein product, partial [Dibothriocephalus latus]	diamond	2868	60.1	0.993344425956739	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Dibothriocephalus	Dibothriocephalus latus
28010886	28010886	PRJNA813520_S_NODE_105_length_956_cov_18.204962_g85_i0	PRJNA813520	105	956	18.204962	174.03943672	Diptera	7147	Arthropoda	Arthropoda	137	2.2e-35	NR	XP_037894365.1	7396	g85	i0	48.6	9.87866108786611	140	66	43.9	1	188	607	49	182	XP_037894365.1 ADP-ribose glycohydrolase OARD1 isoform X1 [Glossina fuscipes]	diamond	9444	138	0.992753623188406	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Glossinidae	Glossina	Glossina fuscipes
28736880	28736880	PRJNA813520_S_NODE_1967_length_261_cov_2.262931_g1920_i0	PRJNA813520	1967	261	2.262931	5.90624991	root	1	Root_unresolved	Root_unresolved	177	9.29e-51	NR	XP_030110853.2	10090	g1920	i0	98.8	15.816091954023	86	1	98.9	0	260	3	136	221	XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus]	diamond	4128	177	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
31191446	31191446	PRJNA813520_S_NODE_1775_length_272_cov_17.543210_g1728_i0	PRJNA813520	1775	272	17.54321	47.7175312	Haliotis asinina	109174	Mollusca	Mollusca	43.5	0.0267	NR	XP_067657806.1	109174	g1728	i0	35.4	1.41176470588235	65	36	70.6	2	238	47	144	203	XP_067657806.1 uncharacterized protein [Haliotis asinina]	diamond	384	43.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis asinina
32299323	32299323	PRJNA813520_S_NODE_39_length_1374_cov_18.398513_g33_i0	PRJNA813520	39	1374	18.398513	252.79556862	Dimorphilus gyrociliatus	2664684	Annelida	Annelida	83.6	8.33e-13	NR	CAD5121248.1	2664684	g33	i0	55.9	0.296943231441048	59	26	12.9	0	1005	829	1043	1101	CAD5121248.1 DgyrCDS9780 [Dimorphilus gyrociliatus]	diamond	408	83.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Dinophilidae	Dimorphilus	Dimorphilus gyrociliatus

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