metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA478247" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA478247" and tax_phylum = "Streptophyta"

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
1722521	1722521	PRJNA478247_P_NODE_1202_length_356_cov_2.510703_g1096_i0	PRJNA478247	1202	356	2.510703	8.93810268	Hordeum vulgare	4513	Plants	Plants	350	1.07e-91	NTclustered	gi\|326524144\|dbj\|AK365880.1\|	112509	g1096	i0	84.507	72.5589887640449	355	53	99	2	3	356	452	805	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2038I16	blastn	25831	350	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
2372651	2372651	PRJNA478247_P_NODE_1742_length_273_cov_2.250000_g1636_i0	PRJNA478247	1742	273	2.25	6.1425	Cucurbita	3660	Plants	Plants	169	2.3899999999999997e-37	NTclustered	gi\|1279756388\|ref\|XM_023094040.1\|	3662	g1636	i0	79.051	65.3150183150183	253	47	92	6	1	250	554	305	PREDICTED: Cucurbita moschata heat shock cognate protein 80 (LOC111453091), mRNA	blastn	17831	169	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Cucurbitales	Cucurbitaceae	Cucurbita	Cucurbita moschata
5551419	5551419	PRJNA478247_P_NODE_3445_length_157_cov_2.460938_g3339_i0	PRJNA478247	3445	157	2.460938	3.86367266	Oryza sativa	4530	Plants	Plants	185	1.2199999999999999e-42	NTclustered	gi\|32993583\|dbj\|AK108374.1\|	39947	g3339	i0	87.898	88.3757961783439	157	19	100	0	1	157	181	337	Oryza sativa Japonica Group cDNA clone:002-142-D11, full insert sequence	blastn	13875	185	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
9375580	9375580	PRJNA478247_P_NODE_1928_length_252_cov_4.058296_g1822_i0	PRJNA478247	1928	252	4.058296	10.22690592	Lathyrus oleraceus	3888	Plants	Plants	89.8	1.74e-13	NTclustered	gi\|2314320680\|ref\|XR_007796969.1\|	3888	g1822	i0	81.197	2.31349206349206	117	16	45	5	113	226	1838	1951	PREDICTED: Pisum sativum 28S ribosomal RNA (LOC127109700), rRNA	blastn	583	89.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Lathyrus	Lathyrus oleraceus
9375583	9375583	PRJNA478247_P_NODE_3028_length_176_cov_2.142857_g2922_i0	PRJNA478247	3028	176	2.142857	3.77142832	Hibiscus cannabinus	229543	Plants	Plants	189	1.08e-43	NTclustered	gi\|1199285720\|gb\|KY382448.1\|	229543	g2922	i0	91.304	78.1363636363636	138	12	78	0	39	176	981	844	Hibiscus cannabinus elongation factor 1-alpha (EF1a) mRNA, complete cds	blastn	13752	189	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malvales	Malvaceae	Hibiscus	Hibiscus cannabinus
10651467	10651467	PRJNA478247_P_NODE_689_length_513_cov_3.185950_g584_i0	PRJNA478247	689	513	3.18595	16.3439235	Hordeum vulgare	4513	Plants	Plants	507	8.92e-139	NTclustered	gi\|326496930\|dbj\|AK367289.1\|	112509	g584	i0	84.762	78.4717348927875	525	58	100	19	1	513	1096	582	Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2054B13	blastn	40256	507	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
12576129	12576129	PRJNA478247_P_NODE_1050_length_394_cov_2.287671_g944_i0	PRJNA478247	1050	394	2.287671	9.01342374	Eukaryota	2759	Plants	Plants	52.8	0.038	NTclustered	gi\|2583733043\|ref\|XM_059780485.1\|	4283	g944	i0	100	0.284263959390863	28	0	7	0	6	33	453	426	PREDICTED: Cornus florida cell wall protein IFF6-like (LOC132278646), mRNA	blastn	112	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Cornales	Cornaceae	Cornus	Cornus florida
13201398	13201398	PRJNA478247_P_NODE_411_length_730_cov_3.223966_g324_i0	PRJNA478247	411	730	3.223966	23.5349518	Oryza sativa	4530	Plants	Plants	710	0	NTclustered	gi\|32993583\|dbj\|AK108374.1\|	39947	g324	i0	84.509	70.686301369863	723	106	99	6	4	723	769	50	Oryza sativa Japonica Group cDNA clone:002-142-D11, full insert sequence	blastn	51601	710	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
15750416	15750416	PRJNA478247_P_NODE_2573_length_204_cov_1.851429_g2467_i0	PRJNA478247	2573	204	1.851429	3.77691516	Vitis vinifera	29760	Plants	Plants	52.8	0.018	NTclustered	gi\|147835083\|emb\|AM460102.2\|	29760	g2467	i0	100	0.137254901960784	28	0	14	0	14	41	17372	17345	Vitis vinifera contig VV78X115460.2, whole genome shotgun sequence	blastn	28	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Vitales	Vitaceae	Vitis	Vitis vinifera
18948641	18948641	PRJNA478247_P_NODE_2455_length_211_cov_2.472527_g2349_i0	PRJNA478247	2455	211	2.472527	5.21703197	Magnoliopsida	3398	Plants	Plants	122	1.3899999999999998e-23	NTclustered	gi\|1540528823\|ref\|XM_027503055.1\|	3816	g2349	i0	79.121	14.4407582938389	182	34	85	4	6	185	615	436	PREDICTED: Abrus precatorius glyceraldehyde-3-phosphate dehydrogenase, cytosolic-like (LOC113867643), mRNA	blastn	3047	122	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Abrus	Abrus precatorius
22124230	22124230	PRJNA478247_P_NODE_3078_length_173_cov_2.333333_g2972_i0	PRJNA478247	3078	173	2.333333	4.03666609	Mangifera indica	29780	Plants	Plants	91.6	3.08e-14	NTclustered	gi\|2118910496\|ref\|XM_044629905.1\|	29780	g2972	i0	85.227	1.57225433526012	88	13	51	0	78	165	172	259	PREDICTED: Mangifera indica 60S ribosomal protein L23 (LOC123211282), mRNA	blastn	272	91.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Anacardiaceae	Mangifera	Mangifera indica
24049065	24049065	PRJNA478247_P_NODE_2099_length_237_cov_4.076923_g1993_i0	PRJNA478247	2099	237	4.076923	9.66230751	Magnoliopsida	3398	Plants	Plants	422	1.41e-113	NTclustered	gi\|2396003214\|ref\|XR_008051474.1\|	2711	g1993	i0	98.734	100	237	3	100	0	1	237	1054	818	PREDICTED: Citrus sinensis 18S ribosomal RNA (LOC127899596), rRNA	blastn	23700	424	0.995283018867924	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Sapindales	Rutaceae	Citrus	Citrus sinensis

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