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

9 rows where analysis = "diamond", bioproject = "PRJNA1192965" and tax_phylum = "Chordata"

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
6698361	6698361	PRJNA1192965_P_NODE_146_length_889_cov_4.316176_g133_i0	PRJNA1192965	146	889	4.316176	38.37080464	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	267	1.23e-85	NR	AAZ38987.1	8668	g133	i0	58.3	44.4060742407199	235	85	78	4	177	869	10	235	AAZ38987.1 40S ribosomal protein S2, partial [Oxyuranus scutellatus]	diamond	39477	269	0.992565055762082	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Elapidae	Oxyuranus	Oxyuranus scutellatus
19446532	19446532	PRJNA1192965_P_NODE_2216_length_289_cov_1.375000_g2197_i0	PRJNA1192965	2216	289	1.375	3.97375	Bufonidae	8382	Chordata	Chordata	82.8	4.79e-16	NR	XP_044144730.1	30331	g2197	i0	47.8	16.9411764705882	92	47	95.5	1	287	12	169	259	XP_044144730.1 peptidyl-prolyl cis-trans isomerase-like 4 [Bufo gargarizans]	diamond	4896	82.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufo	Bufo gargarizans
21997225	21997225	PRJNA1192965_P_NODE_2398_length_282_cov_1.473684_g2379_i0	PRJNA1192965	2398	282	1.473684	4.15578888	Hymenochirus boettgeri	247094	Chordata	Chordata	130	1.99e-33	NR	KAG8449897.1	247094	g2379	i0	67	4.98936170212766	94	30	98.9	1	281	3	258	351	KAG8449897.1 hypothetical protein GDO86_016536 [Hymenochirus boettgeri]	diamond	1407	130	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Hymenochirus	Hymenochirus boettgeri
28165279	28165279	PRJNA1192965_P_NODE_2865_length_264_cov_1.068063_g2846_i0	PRJNA1192965	2865	264	1.068063	2.81968632	Anura	8342	Chordata	Chordata	48.9	2.65e-4	NR	KAE8614077.1	8364	g2846	i0	50	2.02272727272727	50	21	55.7	2	3	149	134	180	KAE8614077.1 hypothetical protein XENTR_v10007970 [Xenopus tropicalis]	diamond	534	49.3	0.991886409736308	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus tropicalis
28588437	28588437	PRJNA1192965_P_NODE_4007_length_247_cov_0.885057_g3988_i0	PRJNA1192965	4007	247	0.885057	2.18609079	Sciurus carolinensis	30640	Chordata	Chordata	42.7	0.0389	NR	MBZ3885995.1	30640	g3988	i0	32.5	0.935222672064777	77	45	93.5	1	240	10	104	173	MBZ3885995.1 Torsin-1A-interacting protein 1 [Sciurus carolinensis]	diamond	231	42.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Sciuridae	Sciurus	Sciurus carolinensis
29125305	29125305	PRJNA1192965_P_NODE_1549_length_330_cov_1.198444_g1530_i0	PRJNA1192965	1549	330	1.198444	3.9548652	Bombina bombina	8345	Chordata	Chordata	78.6	2.56e-14	NR	XP_053563259.1	8345	g1530	i0	53.8	1.18181818181818	65	27	59.1	1	25	219	345	406	XP_053563259.1 antizyme inhibitor 2 [Bombina bombina]	diamond	390	78.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bombinatoridae	Bombina	Bombina bombina
29175792	29175792	PRJNA1192965_P_NODE_3829_length_248_cov_0.880000_g3810_i0	PRJNA1192965	3829	248	0.88	2.1824	Opisthokonta	33154	Chordata	Chordata	117	3.5099999999999993e-31	NR	XP_060228253.1	10047	g3810	i0	72.2	47.4193548387097	79	22	95.6	0	12	248	26	104	XP_060228253.1 large ribosomal subunit protein uL11-like [Meriones unguiculatus]	diamond	11760	118	0.991525423728814	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Meriones	Meriones unguiculatus
29459470	29459470	PRJNA1192965_P_NODE_4450_length_245_cov_0.895349_g4431_i0	PRJNA1192965	4450	245	0.895349	2.19360505	Mammalia	40674	Chordata	Chordata	65.1	5.23e-10	NR	XP_049994972.1	100897	g4431	i0	39.2	6.48979591836735	74	44	90.6	1	18	239	469	541	XP_049994972.1 sperm flagellar protein 2 isoform X3 [Alexandromys fortis]	diamond	1590	65.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Alexandromys	Alexandromys fortis
30735801	30735801	PRJNA1192965_P_NODE_3334_length_251_cov_0.865169_g3315_i0	PRJNA1192965	3334	251	0.865169	2.17157419	Balaenoptera physalus	9770	Chordata	Chordata	75.5	1.16e-14	NR	KAB0394347.1	9770	g3315	i0	68.9	0.537848605577689	45	14	53.8	0	240	106	77	121	KAB0394347.1 hypothetical protein E2I00_003872, partial [Balaenoptera physalus]	diamond	135	75.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Balaenopteridae	Balaenoptera	Balaenoptera physalus

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