metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA982720" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA982720" 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
26677851	26677851	PRJNA982720_S_NODE_10621_length_212_cov_4.223022_g10593_i0	PRJNA982720	10621	212	4.223022	8.95280664	Engystomops pustulosus	76066	Chordata	Chordata	47.4	5.05e-5	NR	KAG8588135.1	76066	g10593	i0	54.3	0.495283018867925	35	16	49.5	0	35	139	35	69	KAG8588135.1 hypothetical protein GDO81_005883 [Engystomops pustulosus]	diamond	105	47.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Leptodactylidae	Engystomops	Engystomops pustulosus
28447700	28447700	PRJNA982720_S_NODE_2866_length_348_cov_5.447273_g2838_i0	PRJNA982720	2866	348	5.447273	18.95651004	Myotis myotis	51298	Chordata	Chordata	57	1.85e-7	NR	KAF6303955.1	51298	g2838	i0	61.2	0.422413793103448	49	16	39.7	1	233	96	80	128	KAF6303955.1 hypothetical protein mMyoMyo1_008938 [Myotis myotis]	diamond	147	57	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Vespertilionidae	Myotis	Myotis myotis
28510705	28510705	PRJNA982720_S_NODE_8267_length_256_cov_3.426230_g8239_i0	PRJNA982720	8267	256	3.42623	8.7711488	Fusarium oxysporum	5507	Fungi	Fungi	109	3.48e-26	NR	KAJ4050974.1	5507	g8239	i0	86.4	0.69140625	59	8	69.1	0	3	179	89	147	KAJ4050974.1 hypothetical protein NW753_007579 [Fusarium oxysporum]	diamond	177	109	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium oxysporum
28573741	28573741	PRJNA982720_S_NODE_10027_length_236_cov_2.748466_g9999_i0	PRJNA982720	10027	236	2.748466	6.48637976	Zalophus californianus	9704	Chordata	Chordata	48.9	1.22e-4	NR	XP_027467811.1	9704	g9999	i0	76.7	0.38135593220339	30	7	38.1	0	132	43	25	54	XP_027467811.1 actin-related protein 2/3 complex subunit 5 isoform X1 [Zalophus californianus]	diamond	90	48.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Otariidae	Zalophus	Zalophus californianus
28794647	28794647	PRJNA982720_S_NODE_5867_length_289_cov_3.328704_g5839_i0	PRJNA982720	5867	289	3.328704	9.61995456	Mytilus edulis	6550	Mollusca	Mollusca	56.6	6.83e-7	NR	CAG2187267.1	6550	g5839	i0	42.9	0.653979238754325	63	35	64.4	1	48	233	192	254	CAG2187267.1 unnamed protein product [Mytilus edulis]	diamond	189	56.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis
29552396	29552396	PRJNA982720_S_NODE_7730_length_263_cov_2.157895_g7702_i0	PRJNA982720	7730	263	2.157895	5.67526385	Mastomys coucha	35658	Chordata	Chordata	48.5	3.85e-4	NR	XP_031196951.1	35658	g7702	i0	46.7	0.901140684410646	45	23	50.2	1	96	227	67	111	XP_031196951.1 thymidine kinase 2, mitochondrial isoform X1 [Mastomys coucha]	diamond	237	48.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mastomys	Mastomys coucha
29811076	29811076	PRJNA982720_S_NODE_8791_length_251_cov_0.865169_g8763_i0	PRJNA982720	8791	251	0.865169	2.17157419	Mammalia	40674	Chordata	Chordata	46.6	0.0015	NR	KAF0871557.1	9678	g8763	i0	44.3	5.83266932270916	61	30	68.1	2	250	80	37	97	KAF0871557.1 LORF2 protein, partial [Crocuta crocuta]	diamond	1464	47	0.991489361702128	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Hyaenidae	Crocuta	Crocuta crocuta
30342813	30342813	PRJNA982720_S_NODE_6052_length_286_cov_4.342723_g6024_i0	PRJNA982720	6052	286	4.342723	12.42018778	Sarocladium strictum	5046	Fungi	Fungi	156	2.8599999999999993e-43	NR	KAK0391662.1	5046	g6024	i0	92.3	1.63636363636364	78	6	81.8	0	53	286	20	97	KAK0391662.1 hypothetical protein NLU13_1161 [Sarocladium strictum]	diamond	468	156	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
31194965	31194965	PRJNA982720_S_NODE_9315_length_245_cov_2.558140_g9287_i0	PRJNA982720	9315	245	2.55814	6.267443	Sarocladium implicatum	1610689	Fungi	Fungi	47	0.00115	NR	KAH8170626.1	1610689	g9287	i0	33.9	0.722448979591837	59	39	72.2	0	63	239	1	59	KAH8170626.1 hypothetical protein LIA77_09407 [Sarocladium implicatum]	diamond	177	47	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium implicatum
32492589	32492589	PRJNA982720_S_NODE_1399_length_404_cov_1.441088_g1371_i0	PRJNA982720	1399	404	1.441088	5.82199552	Rhinolophus ferrumequinum	59479	Chordata	Chordata	65.9	1.47e-9	NR	KAF6390339.1	59479	g1371	i0	53.7	1.89356435643564	67	31	49.8	0	338	138	276	342	KAF6390339.1 hypothetical protein mRhiFer1_007909 [Rhinolophus ferrumequinum]	diamond	765	65.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Rhinolophidae	Rhinolophus	Rhinolophus ferrumequinum

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