metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA546018" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA546018" 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
3061778	3061778	PRJNA546018_S_NODE_28243_length_297_cov_2.173729_g27918_i0	PRJNA546018	28243	297	2.173729	6.45597513	root	1	Root_unresolved	Root_unresolved	167	1.69e-45	NR	XP_029332929.1	10089	g27918	i0	96.2	13.3939393939394	78	3	78.8	0	247	14	769	846	XP_029332929.1 LOW QUALITY PROTEIN: uncharacterized protein LOC110295489 [Mus caroli]	diamond	3978	168	0.994047619047619	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus caroli
18970786	18970786	PRJNA546018_S_NODE_43195_length_233_cov_2.627907_g42870_i0	PRJNA546018	43195	233	2.627907	6.12302331	Podarcis lilfordi	74358	Chordata	Chordata	58.5	3.39e-9	NR	CAI5783983.1	74358	g42870	i0	68.8	1.50643776824034	32	10	41.2	0	136	231	12	43	CAI5783983.1 E3 ubiquitin-protein ligase RBX1, partial [Podarcis lilfordi]	diamond	351	58.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Lacertidae	Podarcis	Podarcis lilfordi
26888317	26888317	PRJNA546018_S_NODE_54241_length_207_cov_0.890411_g53916_i0	PRJNA546018	54241	207	0.890411	1.84315077	Bufotes viridis	30338	Chordata	Chordata	60.5	1.29e-8	NR	CAK8637325.1	30338	g53916	i0	44.3	3.66666666666667	61	34	88.4	0	185	3	689	749	CAK8637325.1 LINE-1 retrotransposable element ORF2 protein [Bufotes viridis]	diamond	759	60.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
27930747	27930747	PRJNA546018_S_NODE_48005_length_219_cov_3.050633_g47680_i0	PRJNA546018	48005	219	3.050633	6.68088627	Varanus komodoensis	61221	Chordata	Chordata	64.7	2.77e-10	NR	KAF7248073.1	61221	g47680	i0	64.7	2.17808219178082	51	17	68.5	1	6	155	88	138	KAF7248073.1 Neuronal vesicle trafficking-associated protein 1 [Varanus komodoensis]	diamond	477	64.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Varanidae	Varanus	Varanus komodoensis
28261141	28261141	PRJNA546018_S_NODE_7326_length_657_cov_4.171141_g7030_i0	PRJNA546018	7326	657	4.171141	27.40439637	Chordata	7711	Chordata	Chordata	153	8.12e-39	NR	XP_041036564.1	13397	g7030	i0	69.3	3.28767123287671	101	31	46.1	0	23	325	534	634	XP_041036564.1 coatomer subunit alpha [Carcharodon carcharias]	diamond	2160	154	0.993506493506494	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Lamniformes	Alopiidae	Carcharodon	Carcharodon carcharias
29730210	29730210	PRJNA546018_S_NODE_24570_length_322_cov_2.302682_g24245_i0	PRJNA546018	24570	322	2.302682	7.41463604	Dasypus novemcinctus	9361	Chordata	Chordata	44.7	0.0183	NR	XP_058138150.1	9361	g24245	i0	44.7	0.437888198757764	47	26	43.8	0	131	271	314	360	XP_058138150.1 inactive serine/threonine-protein kinase PLK5 [Dasypus novemcinctus]	diamond	141	44.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Cingulata	Dasypodidae	Dasypus	Dasypus novemcinctus
30741378	30741378	PRJNA546018_S_NODE_31194_length_280_cov_5.534247_g30869_i0	PRJNA546018	31194	280	5.534247	15.4958916	Mus musculus	10090	Chordata	Chordata	43.1	0.0439	NR	BAC65677.3	10090	g30869	i0	100	0.192857142857143	18	0	19.3	0	227	280	684	701	BAC65677.3 mKIAA0890 protein, partial [Mus musculus]	diamond	54	43.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
31341900	31341900	PRJNA546018_S_NODE_46956_length_222_cov_2.093168_g46631_i0	PRJNA546018	46956	222	2.093168	4.64683296	Podarcis lilfordi	74358	Chordata	Chordata	55.1	1.23e-6	NR	CAI5781766.1	74358	g46631	i0	59	0.527027027027027	39	15	51.4	1	60	173	40	78	CAI5781766.1 domain-containing 21 isoform X3 [Podarcis lilfordi]	diamond	117	55.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Lacertidae	Podarcis	Podarcis lilfordi
31689706	31689706	PRJNA546018_S_NODE_34657_length_264_cov_1.280788_g34332_i0	PRJNA546018	34657	264	1.280788	3.38128032	Cricetulus griseus	10029	Chordata	Chordata	163	2.3399999999999997e-47	NR	ERE47265.1	10029	g34332	i0	100	1	88	0	100	0	264	1	23	110	ERE47265.1 PilN family type IV pilus biogeneis protein, partial [Cricetulus griseus]	diamond	264	163	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Cricetulus	Cricetulus griseus
31847869	31847869	PRJNA546018_S_NODE_35337_length_261_cov_1.625000_g35012_i0	PRJNA546018	35337	261	1.625	4.24125	Phyllostomus discolor	89673	Chordata	Chordata	52	4.34e-6	NR	KAF6109612.1	89673	g35012	i0	54.8	0.482758620689655	42	19	48.3	0	215	90	81	122	KAF6109612.1 hypothetical protein HJG60_010865 [Phyllostomus discolor]	diamond	126	52	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Phyllostomidae	Phyllostomus	Phyllostomus discolor
32827565	32827565	PRJNA546018_S_NODE_46700_length_223_cov_1.506173_g46375_i0	PRJNA546018	46700	223	1.506173	3.35876579	Petromyzon marinus	7757	Chordata	Chordata	89	3.64e-19	NR	XP_032800945.1	7757	g46375	i0	65	6.73991031390134	60	20	79.4	1	201	25	102	161	XP_032800945.1 transmembrane protein 189 isoform X1 [Petromyzon marinus]	diamond	1503	89	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Petromyzon	Petromyzon marinus

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