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

9 rows where analysis = "diamond", bioproject = "PRJNA551951" and tax_clade = "Embryophyta"

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
10724760	10724760	PRJNA551951_S_NODE_3929_length_459_cov_5.686321_g3814_i0	PRJNA551951	3929	459	5.686321	26.10021339	Buddleja alternifolia	168488	Plants	Plants	94.7	3.8900000000000003e-22	NR	KAG8389312.1	168488	g3814	i0	62.7	0.437908496732026	67	20	40.5	1	345	160	27	93	KAG8389312.1 hypothetical protein BUALT_Bualt02G0216300 [Buddleja alternifolia]	diamond	201	94.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Scrophulariaceae	Buddleja	Buddleja alternifolia
10724770	10724770	PRJNA551951_S_NODE_4449_length_425_cov_68.035897_g4334_i0	PRJNA551951	4449	425	68.035897	289.15256225	Aegilops tauschii subsp. strangulata	200361	Plants	Plants	139	8.629999999999999e-37	NR	XP_045087490.1	200361	g4334	i0	56.2	1.68	121	51	84	1	373	17	194	314	XP_045087490.1 uncharacterized protein LOC120969583 [Aegilops tauschii subsp. strangulata]	diamond	714	139	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Aegilops	Aegilops tauschii
26776518	26776518	PRJNA551951_S_NODE_8861_length_261_cov_4.154867_g8743_i0	PRJNA551951	8861	261	4.154867	10.84420287	Fabaceae	3803	Plants	Plants	48.9	6.37e-5	NR	AES89993.1	3880	g8743	i0	56.5	2.28735632183908	62	23	71.3	3	56	241	1	58	AES89993.1 hypothetical protein MTR_4g083010 [Medicago truncatula]	diamond	597	49.3	0.991886409736308	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Medicago	Medicago truncatula
27267827	27267827	PRJNA551951_S_NODE_10083_length_235_cov_1.980000_g9965_i0	PRJNA551951	10083	235	1.98	4.653	Morus notabilis	981085	Plants	Plants	85.5	8.96e-19	NR	XP_010105650.1	981085	g9965	i0	54.5	0.982978723404255	77	35	98.3	0	3	233	52	128	XP_010105650.1 putative invertase inhibitor [Morus notabilis]	diamond	231	85.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Moraceae	Morus	Morus notabilis
27836212	27836212	PRJNA551951_S_NODE_12164_length_201_cov_6.475904_g12046_i0	PRJNA551951	12164	201	6.475904	13.01656704	Carpinus fangiana	176857	Plants	Plants	84	1.05e-19	NR	KAE8038843.1	176857	g12046	i0	93.2	0.656716417910448	44	3	65.7	0	162	31	1	44	KAE8038843.1 hypothetical protein FH972_011315 [Carpinus fangiana]	diamond	132	84	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Betulaceae	Carpinus	Carpinus fangiana
28531133	28531133	PRJNA551951_S_NODE_13747_length_182_cov_3.455782_g13629_i0	PRJNA551951	13747	182	3.455782	6.28952324	Trifolium repens	3899	Plants	Plants	49.3	1.58e-5	NR	KAK2451002.1	3899	g13629	i0	61.7	1.63186813186813	47	10	65.9	2	144	25	61	106	KAK2451002.1 hypothetical protein QL285_010092 [Trifolium repens]	diamond	297	49.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Trifolium	Trifolium repens
29099368	29099368	PRJNA551951_S_NODE_13168_length_189_cov_1.818182_g13050_i0	PRJNA551951	13168	189	1.818182	3.43636398	Taxus chinensis	29808	Plants	Plants	84.3	2.79e-18	NR	KAH9299540.1	29808	g13050	i0	82.1	0.888888888888889	56	10	88.9	0	187	20	67	122	KAH9299540.1 hypothetical protein KI387_031222, partial [Taxus chinensis]	diamond	168	84.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Cupressales	Taxaceae	Taxus	Taxus chinensis
30204332	30204332	PRJNA551951_S_NODE_14472_length_175_cov_2.285714_g14354_i0	PRJNA551951	14472	175	2.285714	3.9999995	Taxus chinensis	29808	Plants	Plants	52.8	2.6e-6	NR	KAH9299540.1	29808	g14354	i0	62.8	0.737142857142857	43	16	73.7	0	130	2	10	52	KAH9299540.1 hypothetical protein KI387_031222, partial [Taxus chinensis]	diamond	129	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Cupressales	Taxaceae	Taxus	Taxus chinensis
31563854	31563854	PRJNA551951_S_NODE_5576_length_370_cov_1.585075_g5458_i0	PRJNA551951	5576	370	1.585075	5.8647775	Aegilops tauschii subsp. strangulata	200361	Plants	Plants	43.9	0.0422	NR	XP_020175858.1	200361	g5458	i0	66.7	0.243243243243243	30	10	24.3	0	123	34	109	138	XP_020175858.1 pistil-specific extensin-like protein [Aegilops tauschii subsp. strangulata]	diamond	90	43.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Aegilops	Aegilops tauschii

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