metadata: contig_metadata: 14 rows where bioproject = "PRJNA488043" and tax

14 rows where bioproject = "PRJNA488043" 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
1724524	1724524	PRJNA488043_P_NODE_14082_length_241_cov_4.566038_g11840_i0	PRJNA488043	14082	241	4.566038	11.00415158	Gallus gallus	9031	Chordata	Chordata	265	2.5599999999999996e-66	NTclustered	gi\|15341323\|gb\|AF401307.1\|AF401307	9031	g11840	i0	88.584	19.7676348547718	219	23	100	2	2	220	377	161	Gallus gallus clone pG728_T7-end CNM repeat sequence	blastn	4764	265	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Gallus	Gallus gallus
1724621	1724621	PRJNA488043_P_NODE_21622_length_157_cov_2.523438_g19380_i0	PRJNA488043	21622	157	2.523438	3.96179766	Gallus gallus	9031	Chordata	Chordata	243	7.159999999999999e-60	NTclustered	gi\|15341324\|gb\|AF401308.1\|AF401308	9031	g19380	i0	94.41	11.9426751592357	161	3	99	2	1	156	22	181	Gallus gallus clone pG193_T3-end CNM repeat sequence	blastn	1875	243	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Gallus	Gallus gallus
4926102	4926102	PRJNA488043_P_NODE_4404_length_656_cov_2.285486_g2603_i0	PRJNA488043	4404	656	2.285486	14.99278816	root	1	Root_unresolved	Root_unresolved	658	0	NTclustered	gi\|686613822\|ref\|XM_009285442.1\|	9233	g2603	i0	99.721	29.172256097561	359	1	96	0	298	656	1999	1641	PREDICTED: Aptenodytes forsteri silver exporting P-type ATPase (LOC103904088), mRNA	blastn	19137	664	0.990963855421687	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Sphenisciformes	Spheniscidae	Aptenodytes	Aptenodytes forsteri
10653547	10653547	PRJNA488043_P_NODE_18769_length_184_cov_2.470968_g16527_i0	PRJNA488043	18769	184	2.470968	4.54658112	Gallus gallus	9031	Chordata	Chordata	224	3.139999999999999e-54	NTclustered	gi\|297306307\|dbj\|AB556668.1\|	9031	g16527	i0	89.011	7.1195652173913	182	19	99	1	1	181	288	469	Gallus gallus DNA, CENP-A associated sequence, partial sequence, clone: CAIP#397	blastn	1310	224	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Gallus	Gallus gallus
15125895	15125895	PRJNA488043_P_NODE_18472_length_187_cov_2.208861_g16230_i0	PRJNA488043	18472	187	2.208861	4.13057007	root	1	Root_unresolved	Root_unresolved	248	1.9e-61	NTclustered	gi\|1110999473\|ref\|XM_019470584.1\|	9233	g16230	i0	89.904	3.2192513368984	208	0	100	1	1	187	1450	1657	PREDICTED: Aptenodytes forsteri uncharacterized protein y4hP-like (LOC109279307), mRNA	blastn	602	248	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Sphenisciformes	Spheniscidae	Aptenodytes	Aptenodytes forsteri
17027184	17027184	PRJNA488043_P_NODE_22114_length_153_cov_2.645161_g19872_i0	PRJNA488043	22114	153	2.645161	4.04709633	Meleagris gallopavo	9103	Chordata	Chordata	76.8	7.44e-10	NTclustered	gi\|2721460824\|emb\|HG999682.4\|	9103	g19872	i0	83.951	0.797385620915033	81	11	52	2	1	80	89337865	89337786	Meleagris gallopavo genome assembly, chromosome: 3	blastn	122	76.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Meleagris	Meleagris gallopavo
18301653	18301653	PRJNA488043_P_NODE_9915_length_342_cov_5.485623_g7676_i0	PRJNA488043	9915	342	5.485623	18.76083066	Sus scrofa	9823	Chordata	Chordata	355	2.2e-93	NTclustered	gi\|509046\|emb\|X70941.1\|	9823	g7676	i0	96.296	48.5146198830409	216	8	86	0	127	342	273	58	S.scrofa DNA for centromere specific motif	blastn	16592	355	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
18949450	18949450	PRJNA488043_P_NODE_22095_length_153_cov_3.137097_g19853_i0	PRJNA488043	22095	153	3.137097	4.79975841	Phasianidae	9005	Chordata	Chordata	267	4.1099999999999994e-67	NTclustered	gi\|2201669100\|ref\|XR_006938892.1\|	9031	g19853	i0	98.039	6392.07189542484	153	3	100	0	1	153	15106	15258	PREDICTED: Gallus gallus uncharacterized LOC124418349 (LOC124418349), ncRNA	blastn	977987	267	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Gallus	Gallus gallus
20851400	20851400	PRJNA488043_P_NODE_11837_length_286_cov_3.295720_g9596_i0	PRJNA488043	11837	286	3.29572	9.4257592	Mus musculus	10090	Chordata	Chordata	259	1.45e-64	NTclustered	gi\|2904935057\|gb\|PQ737980.1\|	10090	g9596	i0	83.746	0.989510489510489	283	37	97	9	9	286	299	21	Mus musculus lncRNA390 lncRNA, complete sequence	blastn	283	259	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
20851658	20851658	PRJNA488043_P_NODE_9917_length_342_cov_4.060703_g7678_i0	PRJNA488043	9917	342	4.060703	13.88760426	Mus musculus	10090	Chordata	Chordata	579	1.1999999999999996e-160	NTclustered	gi\|2904935057\|gb\|PQ737980.1\|	10090	g7678	i0	97.093	1.00584795321637	344	8	100	2	1	342	21	364	Mus musculus lncRNA390 lncRNA, complete sequence	blastn	344	579	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
22774901	22774901	PRJNA488043_P_NODE_18518_length_187_cov_1.639241_g16276_i0	PRJNA488043	18518	187	1.639241	3.06538067	root	1	Root_unresolved	Root_unresolved	346	6.56e-91	NTclustered	gi\|686605868\|ref\|XM_009281128.1\|	9233	g16276	i0	100	23.6363636363636	187	0	100	0	1	187	750	936	PREDICTED: Aptenodytes forsteri copper resistance protein A-like (LOC103900443), partial mRNA	blastn	4420	346	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Sphenisciformes	Spheniscidae	Aptenodytes	Aptenodytes forsteri
23402068	23402068	PRJNA488043_P_NODE_12379_length_275_cov_1.865854_g10138_i0	PRJNA488043	12379	275	1.865854	5.1310985	Mus musculus	10090	Chordata	Chordata	451	2.13e-122	NTclustered	gi\|124504303\|gb\|BC128469.1\|	10090	g10138	i0	95.804	77.96	286	1	100	1	1	275	5	290	Mus musculus cDNA clone IMAGE:40090117	blastn	21439	451	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
25324074	25324074	PRJNA488043_P_NODE_11540_length_294_cov_2.641509_g9299_i0	PRJNA488043	11540	294	2.641509	7.76603646	root	1	Root_unresolved	Root_unresolved	525	1.3399999999999995e-144	NTclustered	gi\|2633738512\|ref\|XM_061382358.1\|	9906	g9299	i0	99.31	1507.35034013605	290	2	99	0	5	294	1341	1630	PREDICTED: Bos javanicus cornichon family AMPA receptor auxiliary protein 3 (CNIH3), transcript variant X30, mRNA	blastn	443161	525	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos javanicus
27107740	27107740	PRJNA488043_P_NODE_17282_length_199_cov_3.111765_g15040_i0	PRJNA488043	17282	199	3.111765	6.19241235	Pleurodeles waltl	8319	Chordata	Chordata	56.6	1.54e-7	NR	KAJ1174501.1	8319	g15040	i0	55.9	1.0251256281407	68	13	76.9	2	155	3	128	195	KAJ1174501.1 hypothetical protein NDU88_006322 [Pleurodeles waltl]	diamond	204	56.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Pleurodeles	Pleurodeles waltl

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