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

11 rows where analysis = "diamond", bioproject = "PRJNA977246" 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
26614394	26614394	PRJNA977246_S_NODE_25581_length_257_cov_3.657895_g24589_i0	PRJNA977246	25581	257	3.657895	9.40079015	Branchiostoma belcheri	7741	Chordata	Chordata	45.1	0.00698	NR	KAI8479750.1	7741	g24589	i0	45.2	1.51750972762646	42	23	49	0	132	257	477	518	KAI8479750.1 Titin-like [Branchiostoma belcheri]	diamond	390	45.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma belcheri
26804509	26804509	PRJNA977246_S_NODE_23841_length_272_cov_3.189300_g22849_i0	PRJNA977246	23841	272	3.1893	8.674896	Cricetulus griseus	10029	Chordata	Chordata	68.2	4.34e-11	NR	EGW12488.1	10029	g22849	i0	57.5	3.75	73	18	80.5	2	10	228	258	317	EGW12488.1 Nascent polypeptide-associated complex subunit alpha, muscle-specific form [Cricetulus griseus]	diamond	1020	68.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Cricetulus	Cricetulus griseus
27563003	27563003	PRJNA977246_S_NODE_21664_length_292_cov_3.737643_g20672_i0	PRJNA977246	21664	292	3.737643	10.91391756	Polypterus senegalus	55291	Chordata	Chordata	146	2.889999999999999e-38	NR	KAG2470858.1	55291	g20672	i0	81.3	1.86986301369863	91	17	93.5	0	20	292	272	362	KAG2470858.1 GGT5 hydrolase, partial [Polypterus senegalus]	diamond	546	146	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
27658206	27658206	PRJNA977246_S_NODE_37624_length_190_cov_3.726708_g36632_i0	PRJNA977246	37624	190	3.726708	7.0807452	Mycteria americana	33587	Chordata	Chordata	42.7	0.0192	NR	KAK4810699.1	33587	g36632	i0	68	1.16842105263158	25	8	39.5	0	178	104	455	479	KAK4810699.1 LOW QUALITY PROTEIN: hypothetical protein QYF61_007673 [Mycteria americana]	diamond	222	42.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Ciconiiformes	Ciconiidae	Mycteria	Mycteria americana
27879013	27879013	PRJNA977246_S_NODE_20745_length_301_cov_4.996324_g19753_i0	PRJNA977246	20745	301	4.996324	15.03893524	Styela clava	7725	Chordata	Chordata	108	7.93e-25	NR	XP_039267518.1	7725	g19753	i0	69.4	2.87043189368771	72	22	71.8	0	301	86	1228	1299	XP_039267518.1 ATP-dependent translocase ABCB1-like [Styela clava]	diamond	864	109	0.990825688073395	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Stolidobranchia	Styelidae	Styela	Styela clava
28384147	28384147	PRJNA977246_S_NODE_32286_length_214_cov_3.151351_g31294_i0	PRJNA977246	32286	214	3.151351	6.74389114	Xenopus laevis	8355	Chordata	Chordata	39.7	0.0373	NR	OCT63104.1	8355	g31294	i0	55.3	0.532710280373832	38	12	46.3	2	52	150	7	44	OCT63104.1 hypothetical protein XELAEV_18044200mg [Xenopus laevis]	diamond	114	39.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus laevis
28516707	28516707	PRJNA977246_S_NODE_36967_length_193_cov_2.634146_g35975_i0	PRJNA977246	36967	193	2.634146	5.08390178	Cheloniidae	8465	Chordata	Chordata	48.1	1.92e-4	NR	CAM4559374.1	8467	g35975	i0	70.6	1.07253886010363	34	9	51.3	1	126	28	181	214	CAM4559374.1 unnamed protein product, partial [Caretta caretta]	diamond	207	48.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Testudines	Cheloniidae	Caretta	Caretta caretta
28952786	28952786	PRJNA977246_S_NODE_30468_length_224_cov_2.594872_g29476_i0	PRJNA977246	30468	224	2.594872	5.81251328	Myotis myotis	51298	Chordata	Chordata	43.9	0.00655	NR	KAF6360049.1	51298	g29476	i0	38.2	5.77232142857143	68	36	84.4	2	196	8	75	141	KAF6360049.1 hypothetical protein mMyoMyo1_011007 [Myotis myotis]	diamond	1293	43.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Vespertilionidae	Myotis	Myotis myotis
29400697	29400697	PRJNA977246_S_NODE_15829_length_364_cov_3.370149_g14839_i0	PRJNA977246	15829	364	3.370149	12.26734236	root	1	Root_unresolved	Root_unresolved	243	2.19e-75	NR	XP_030110853.2	10090	g14839	i0	100	15.271978021978	109	0	89.8	0	15	341	178	286	XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus]	diamond	5559	243	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
29747746	29747746	PRJNA977246_S_NODE_22270_length_286_cov_4.696498_g21278_i0	PRJNA977246	22270	286	4.696498	13.43198428	Aves	8782	Chordata	Chordata	50.4	1.14e-4	NR	KFP09774.1	188379	g21278	i0	70	1.25874125874126	30	9	31.5	0	104	15	111	140	KFP09774.1 Transcription factor CP2, partial [Egretta garzetta]	diamond	360	50.8	0.992125984251969	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Pelecaniformes	Ardeidae	Egretta	Egretta garzetta
32618469	32618469	PRJNA977246_S_NODE_21920_length_289_cov_7316.330769_g20928_i0	PRJNA977246	21920	289	7316.330769	21144.19592241	Staurois parvus	386267	Chordata	Chordata	53.9	1.03e-6	NR	CAI9606385.1	386267	g20928	i0	36.8	1.27681660899654	76	36	78.9	2	235	8	4	67	CAI9606385.1 unnamed protein product, partial [Staurois parvus]	diamond	369	54.3	0.992633517495396	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus

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