metadata: contig_metadata: 12 rows where bioproject = "PRJNA1245487" and tax

12 rows where bioproject = "PRJNA1245487" 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
350977	350977	PRJNA1245487_P_NODE_20201_length_249_cov_0.886364_g19863_i0	PRJNA1245487	20201	249	0.886364	2.20704636	Meleagris gallopavo	9103	Chordata	Chordata	287	5.670000000000001e-73	NTclustered	gi\|2721460880\|emb\|HG999685.4\|	9103	g19863	i0	87.55	1.91967871485944	249	29	100	1	1	249	5142119	5142365	Meleagris gallopavo genome assembly, chromosome: 5	blastn	478	287	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Meleagris	Meleagris gallopavo
4178258	4178258	PRJNA1245487_P_NODE_13324_length_315_cov_1.933884_g12986_i0	PRJNA1245487	13324	315	1.933884	6.0917346	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	64.7	7.45e-10	NR	XP_019641702.1	7741	g12986	i0	43.3	3.67619047619048	97	54	92.4	1	299	9	6	101	XP_019641702.1 PREDICTED: 60S ribosomal protein L7-like [Branchiostoma belcheri]	diamond	1158	65.1	0.993855606758833	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma belcheri
10555181	10555181	PRJNA1245487_P_NODE_17069_length_270_cov_1.720812_g16731_i0	PRJNA1245487	17069	270	1.720812	4.6461924	Fringilla coelebs	37598	Chordata	Chordata	52.8	0.025	NTclustered	gi\|2917616466\|emb\|OZ228696.1\|	37598	g16731	i0	100	0.207407407407407	28	0	10	0	239	266	24640983	24640956	Fringilla coelebs genome assembly, chromosome: 9	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Fringillidae	Fringilla	Fringilla coelebs
15654144	15654144	PRJNA1245487_P_NODE_21733_length_243_cov_0.917647_g21395_i0	PRJNA1245487	21733	243	0.917647	2.22988221	Gallus gallus	9031	Chordata	Chordata	449	6.65e-122	NTclustered	gi\|113462201\|gb\|AC190398.1\|	9031	g21395	i0	100	3.96707818930041	243	0	100	0	1	243	16300	16542	Gallus gallus BAC clone CH261-55O13 from chromosome z, complete sequence	blastn	964	449	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Gallus	Gallus gallus
15654146	15654146	PRJNA1245487_P_NODE_21773_length_243_cov_0.917647_g21435_i0	PRJNA1245487	21773	243	0.917647	2.22988221	Gallus gallus	9031	Chordata	Chordata	444	3.09e-120	NTclustered	gi\|2024499479\|ref\|XR_005849575.1\|	9031	g21435	i0	99.588	3.01646090534979	243	1	100	0	1	243	309	551	PREDICTED: Gallus gallus uncharacterized LOC121110655 (LOC121110655), ncRNA	blastn	733	444	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Gallus	Gallus gallus
22027746	22027746	PRJNA1245487_P_NODE_10098_length_375_cov_1.599338_g9760_i0	PRJNA1245487	10098	375	1.599338	5.9975175	Apteryx mantelli	2696672	Chordata	Chordata	54.7	0.01	NTclustered	gi\|840016890\|emb\|LK066393.1\|	202946	g9760	i0	100	0.0773333333333333	29	0	8	0	6	34	207549	207577	Apteryx australis mantelli genome assembly AptMant0, scaffold scaffold1803	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Apterygiformes	Apterygidae	Apteryx	Apteryx mantelli
27610766	27610766	PRJNA1245487_P_NODE_23344_length_210_cov_30.408759_g23006_i0	PRJNA1245487	23344	210	30.408759	63.8583939	Pleurodeles waltl	8319	Chordata	Chordata	53.5	2.42e-6	NR	KAJ1185330.1	8319	g23006	i0	52.7	0.785714285714286	55	21	71.4	1	152	3	44	98	KAJ1185330.1 hypothetical protein NDU88_002123 [Pleurodeles waltl]	diamond	165	53.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Pleurodeles	Pleurodeles waltl
28021300	28021300	PRJNA1245487_P_NODE_21245_length_245_cov_0.906977_g20907_i0	PRJNA1245487	21245	245	0.906977	2.22209365	Staurois parvus	386267	Chordata	Chordata	68.2	1.13e-12	NR	CAI9618505.1	386267	g20907	i0	62.2	1.10204081632653	45	17	55.1	0	211	77	7	51	CAI9618505.1 unnamed protein product, partial [Staurois parvus]	diamond	270	68.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
28260059	28260059	PRJNA1245487_P_NODE_13466_length_313_cov_1.583333_g13128_i0	PRJNA1245487	13466	313	1.583333	4.95583229	Metazoa	33208	Chordata	Chordata	159	4.09e-46	NR	XP_039261694.1	7725	g13128	i0	76.7	51.3354632587859	103	24	98.7	0	3	311	49	151	XP_039261694.1 40S ribosomal protein S2 [Styela clava]	diamond	16068	159	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Stolidobranchia	Styelidae	Styela	Styela clava
28273597	28273597	PRJNA1245487_P_NODE_20406_length_248_cov_0.891429_g20068_i0	PRJNA1245487	20406	248	0.891429	2.21074392	Bufotes viridis	30338	Chordata	Chordata	48.5	3.46e-4	NR	CAK8629749.1	30338	g20068	i0	67.9	0.338709677419355	28	9	33.9	0	114	197	337	364	CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis]	diamond	84	48.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
30199726	30199726	PRJNA1245487_P_NODE_21012_length_246_cov_0.872832_g20674_i0	PRJNA1245487	21012	246	0.872832	2.14716672	Oikopleura dioica	34765	Chordata	Chordata	91.3	2.92e-19	NR	CAG5106530.1	34765	g20674	i0	56.3	1.96341463414634	80	33	97.6	1	5	244	364	441	CAG5106530.1 Oidioi.mRNA.OKI2018_I69.chr1.g2885.t1.cds [Oikopleura dioica]	diamond	483	91.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Appendicularia	Copelata	Oikopleuridae	Oikopleura	Oikopleura dioica
30800133	30800133	PRJNA1245487_P_NODE_21474_length_244_cov_0.912281_g21136_i0	PRJNA1245487	21474	244	0.912281	2.22596564	Engystomops pustulosus	76066	Chordata	Chordata	76.3	6.1e-14	NR	KAG8571490.1	76066	g21136	i0	60	2.68032786885246	55	22	67.6	0	32	196	976	1030	KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus]	diamond	654	76.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Leptodactylidae	Engystomops	Engystomops pustulosus

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