metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA206070" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA206070" and tax_kingdom = "Metazoa"

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
15083118	15083118	PRJNA206070_S_NODE_14952_length_265_cov_14.986842_g13076_i0	PRJNA206070	14952	265	14.986842	39.7151313	Artemia franciscana	6661	Arthropoda	Arthropoda	160	3.62e-49	NR	KAK2709965.1	6661	g13076	i0	84.9	3.79245283018868	86	13	97.4	0	263	6	3	88	KAK2709965.1 hypothetical protein QYM36_013593 [Artemia franciscana]	diamond	1005	160	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
26884272	26884272	PRJNA206070_S_NODE_24221_length_177_cov_2.485714_g22345_i0	PRJNA206070	24221	177	2.485714	4.39971378	Bombina bombina	8345	Chordata	Chordata	42.7	0.0152	NR	XP_053568838.1	8345	g22345	i0	44.4	0.610169491525424	36	20	61	0	109	2	15	50	XP_053568838.1 tyrosinase-like [Bombina bombina]	diamond	108	42.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bombinatoridae	Bombina	Bombina bombina
27326869	27326869	PRJNA206070_S_NODE_22623_length_187_cov_1.040000_g20747_i0	PRJNA206070	22623	187	1.04	1.9448	Chironomus tepperi	113505	Arthropoda	Arthropoda	88.2	1.75e-18	NR	XP_070507525.1	113505	g20747	i0	63.8	3.41711229946524	69	17	97.9	1	184	2	1	69	XP_070507525.1 vitellogenin-A1-like [Chironomus tepperi]	diamond	639	88.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Chironomus	Chironomus tepperi
28558417	28558417	PRJNA206070_S_NODE_11627_length_333_cov_18.155405_g9751_i0	PRJNA206070	11627	333	18.155405	60.45749865	Hyla sarda	327740	Chordata	Chordata	61.6	1.7e-8	NR	XP_056389893.1	327740	g9751	i0	73.7	2.18018018018018	38	9	33.3	1	213	323	164	201	XP_056389893.1 ORM1-like protein 1 isoform X1 [Hyla sarda]	diamond	726	61.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Hylidae	Hyla	Hyla sarda
29032118	29032118	PRJNA206070_S_NODE_21268_length_196_cov_1.716981_g19392_i0	PRJNA206070	21268	196	1.716981	3.36528276	Saccoglossus kowalevskii	10224	Hemichordata	other_Eukaryota	43.5	0.0101	NR	XP_006823318.1	10224	g19392	i0	42.9	0.642857142857143	42	24	64.3	0	17	142	121	162	XP_006823318.1 PREDICTED: proprotein convertase subtilisin/kexin type 9-like [Saccoglossus kowalevskii]	diamond	126	43.5	1	Eukaryota	Opisthokonta	Metazoa	Hemichordata	Enteropneusta		Harrimaniidae	Saccoglossus	Saccoglossus kowalevskii
29284267	29284267	PRJNA206070_S_NODE_12529_length_311_cov_8.040146_g10653_i0	PRJNA206070	12529	311	8.040146	25.00485406	Cylicocyclus nassatus	53992	Nematoda	Nematoda	64.3	2.3e-9	NR	CAJ0596556.1	53992	g10653	i0	34.4	1.80385852090032	96	60	92.6	2	309	22	5	97	CAJ0596556.1 unnamed protein product [Cylicocyclus nassatus]	diamond	561	64.3	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongylidae	Cylicocyclus	Cylicocyclus nassatus
29649178	29649178	PRJNA206070_S_NODE_26090_length_168_cov_1.488550_g24214_i0	PRJNA206070	26090	168	1.48855	2.500764	root	1	Root_unresolved	Root_unresolved	92	5.97e-20	NR	CDW58230.1	36087	g24214	i0	83.9	2	56	9	100	0	168	1	1323	1378	CDW58230.1 SLT domain containing protein [Trichuris trichiura]	diamond	336	92	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichuridae	Trichuris	Trichuris trichiura
30168556	30168556	PRJNA206070_S_NODE_22352_length_188_cov_3.105960_g20476_i0	PRJNA206070	22352	188	3.10596	5.8392048	Anthophora plagiata	597819	Arthropoda	Arthropoda	43.9	0.00689	NR	CAK9813121.1	597819	g20476	i0	48.6	2.79255319148936	35	18	55.9	0	144	40	222	256	CAK9813121.1 Transposable element Tc1 transposase [Anthophora plagiata]	diamond	525	44.3	0.99097065462754	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Anthophora	Anthophora plagiata
30376539	30376539	PRJNA206070_S_NODE_25872_length_169_cov_1.560606_g23996_i0	PRJNA206070	25872	169	1.560606	2.63742414	Chironomidae	7149	Arthropoda	Arthropoda	63.2	8.69e-10	NR	XP_070499723.1	113505	g23996	i0	60.8	1.61538461538462	51	18	90.5	1	162	10	1390	1438	XP_070499723.1 vitellogenin-A1-like [Chironomus tepperi]	diamond	273	63.5	0.995275590551181	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Chironomus	Chironomus tepperi
30800539	30800539	PRJNA206070_S_NODE_14214_length_278_cov_3.526971_g12338_i0	PRJNA206070	14214	278	3.526971	9.80497938	Grallaria varia	117165	Chordata	Chordata	42.7	0.0415	NR	NXG25108.1	117165	g12338	i0	36.5	0.798561151079137	74	42	75.5	2	3	212	10	82	NXG25108.1 ICT1 hydrolase [Grallaria varia]	diamond	222	42.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Formicariidae	Grallaria	Grallaria varia
30895607	30895607	PRJNA206070_S_NODE_8374_length_446_cov_7.584352_g6503_i0	PRJNA206070	8374	446	7.584352	33.82620992	Erpetoichthys calabaricus	27687	Chordata	Chordata	152	7.05e-42	NR	XP_051791274.1	27687	g6503	i0	61.5	5.77130044843049	143	27	95.5	2	426	1	115	230	XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus]	diamond	2574	152	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus
31179485	31179485	PRJNA206070_S_NODE_31435_length_150_cov_3.309735_g29559_i0	PRJNA206070	31435	150	3.309735	4.9646025	Geodia barretti	519541	Porifera	other_Eukaryota	40.8	0.0499	NR	CAI8024990.1	519541	g29559	i0	52.8	0.72	36	17	72	0	2	109	223	258	CAI8024990.1 Extracellular matrix protein 3, partial [Geodia barretti]	diamond	108	40.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
32160570	32160570	PRJNA206070_S_NODE_15178_length_262_cov_3.462222_g13302_i0	PRJNA206070	15178	262	3.462222	9.07102164	Spinus spinus	160760	Chordata	Chordata	43.5	0.00558	NR	CAM5898072.1	160760	g13302	i0	39.7	0.778625954198473	68	39	77.9	2	40	243	1	66	CAM5898072.1 unnamed protein product [Spinus spinus]	diamond	204	43.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Fringillidae	Spinus	Spinus spinus

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