metadata: contig_metadata: 20 rows where bioproject = "PRJNA415636" and tax

20 rows where bioproject = "PRJNA415636" and tax_clade = "Embryophyta"

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
419108	419108	PRJNA415636_S_NODE_3961_length_250_cov_1.256158_g3914_i0	PRJNA415636	3961	250	1.256158	3.140395	Oryza sativa	4530	Plants	Plants	377	3.29e-100	NTclustered	gi\|347661380\|gb\|BT131733.1\|	39947	g3914	i0	93.976	0.996	249	15	99	0	1	249	275	523	Oryza sativa clone RRlibD00354 mRNA sequence	blastn	249	377	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
1693936	1693936	PRJNA415636_S_NODE_2202_length_312_cov_6.000000_g2155_i0	PRJNA415636	2202	312	6	18.72	Calluna vulgaris	13385	Plants	Plants	58.4	6.27e-4	NTclustered	gi\|2917555290\|emb\|OZ228607.1\|	13385	g2155	i0	94.595	1.06089743589744	37	2	12	0	32	68	61123213	61123249	Calluna vulgaris genome assembly, chromosome: 4	blastn	331	58.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ericales	Ericaceae	Calluna	Calluna vulgaris
6796859	6796859	PRJNA415636_S_NODE_3026_length_277_cov_2.004348_g2979_i0	PRJNA415636	3026	277	2.004348	5.55204396	Eukaryota	2759	Plants	Plants	95.1	1.81e-20	NR	PPR88358.1	3634	g2979	i0	63.9	21.0541516245487	72	26	78	0	277	62	424	495	PPR88358.1 hypothetical protein GOBAR_AA32326 [Gossypium barbadense]	diamond	5832	95.9	0.991657977059437	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malvales	Malvaceae	Gossypium	Gossypium barbadense
8072406	8072406	PRJNA415636_S_NODE_2467_length_299_cov_1.821429_g2420_i0	PRJNA415636	2467	299	1.821429	5.44607271	Oryza sativa	4530	Plants	Plants	364	3.1399999999999986e-96	NTclustered	gi\|32994248\|dbj\|AK109039.1\|	39947	g2420	i0	90.842	0.91304347826087	273	23	91	2	2	273	562	833	Oryza sativa Japonica Group cDNA clone:002-154-C12, full insert sequence	blastn	273	364	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
10622993	10622993	PRJNA415636_S_NODE_3909_length_251_cov_2.166667_g3862_i0	PRJNA415636	3909	251	2.166667	5.43833417	Eucalyptus grandis	71139	Plants	Plants	195	3.57e-45	NTclustered	gi\|1973646297\|ref\|XM_039308465.1\|	71139	g3862	i0	88.344	24.2988047808765	163	17	65	2	17	178	306	145	PREDICTED: Eucalyptus grandis 40S ribosomal protein S30 (LOC120291292), mRNA	blastn	6099	195	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Myrtales	Myrtaceae	Eucalyptus	Eucalyptus grandis
11897954	11897954	PRJNA415636_S_NODE_3490_length_262_cov_2.032558_g3443_i0	PRJNA415636	3490	262	2.032558	5.32530196	Corylus avellana	13451	Plants	Plants	333	7.619999999999999e-87	NTclustered	gi\|2578518154\|ref\|XM_059595289.1\|	13451	g3443	i0	94.444	8.68702290076336	216	12	82	0	1	216	178	393	PREDICTED: Corylus avellana uncharacterized LOC132182083 (LOC132182083), mRNA	blastn	2276	333	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Betulaceae	Corylus	Corylus avellana
14447997	14447997	PRJNA415636_S_NODE_2252_length_309_cov_8.179389_g2205_i0	PRJNA415636	2252	309	8.179389	25.27431201	Calluna vulgaris	13385	Plants	Plants	56.5	0.002	NTclustered	gi\|2917566876\|emb\|OZ228610.1\|	13385	g2205	i0	97.059	0.653721682847896	34	0	11	1	136	168	49713335	49713368	Calluna vulgaris genome assembly, chromosome: 7	blastn	202	56.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ericales	Ericaceae	Calluna	Calluna vulgaris
14448000	14448000	PRJNA415636_S_NODE_3432_length_264_cov_1.935484_g3385_i0	PRJNA415636	3432	264	1.935484	5.10967776	Oryza sativa	4530	Plants	Plants	340	4.5999999999999996e-89	NTclustered	gi\|32994134\|dbj\|AK108925.1\|	39947	g3385	i0	90.189	1.00378787878788	265	21	100	3	1	264	1044	784	Oryza sativa Japonica Group cDNA clone:002-152-H12, full insert sequence	blastn	265	340	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
14448002	14448002	PRJNA415636_S_NODE_4072_length_247_cov_1.785000_g4025_i0	PRJNA415636	4072	247	1.785	4.40895	Oryza sativa	4530	Plants	Plants	228	3.4599999999999984e-55	NTclustered	gi\|37989474\|dbj\|AK119851.1\|	39947	g4025	i0	92.216	0.821862348178138	167	4	78	8	1	158	2484	2650	Oryza sativa Japonica Group cDNA clone:002-178-F09, full insert sequence	blastn	203	228	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
15721777	15721777	PRJNA415636_S_NODE_253_length_639_cov_4.206081_g223_i0	PRJNA415636	253	639	4.206081	26.87685759	Vitis vinifera	29760	Plants	Plants	54.7	0.018	NTclustered	gi\|147811573\|emb\|AM450020.2\|	29760	g223	i0	100	0.100156494522692	29	0	5	0	18	46	13984	13956	Vitis vinifera contig VV78X043765.9, whole genome shotgun sequence	blastn	64	54.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Vitales	Vitaceae	Vitis	Vitis vinifera
15721785	15721785	PRJNA415636_S_NODE_6953_length_193_cov_11.226027_g6906_i0	PRJNA415636	6953	193	11.226027	21.66623211	Picea abies	3329	Plants	Plants	52.8	0.017	NTclustered	gi\|2835530393\|dbj\|LC777203.1\|	3329	g6906	i0	100	0.145077720207254	28	0	15	0	166	193	59	32	Picea abies Pa-Kumamoto-2022 PaMurJ mRNA for lipid II transferase, complete cds	blastn	28	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Pinopsida	Pinales	Pinaceae	Picea	Picea abies
18270724	18270724	PRJNA415636_S_NODE_1275_length_379_cov_3.162651_g1228_i0	PRJNA415636	1275	379	3.162651	11.98644729	Lotus japonicus	34305	Plants	Plants	66.2	7.67e-11	NR	AFK38515.1	34305	g1228	i0	50.5	0.720316622691293	91	42	72	2	372	100	41	128	AFK38515.1 unknown [Lotus japonicus]	diamond	273	66.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Lotus	Lotus japonicus
20820831	20820831	PRJNA415636_S_NODE_3717_length_256_cov_0.971292_g3670_i0	PRJNA415636	3717	256	0.971292	2.48650752	Phyllostachys edulis	38705	Plants	Plants	468	1.95e-127	NTclustered	gi\|242382032\|emb\|FP097018.1\|	38705	g3670	i0	99.609	1	256	1	100	0	1	256	645	900	Phyllostachys edulis cDNA clone: bphyem112p22, full insert sequence	blastn	256	468	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Phyllostachys	Phyllostachys edulis
23371223	23371223	PRJNA415636_S_NODE_2639_length_292_cov_1.534694_g2592_i0	PRJNA415636	2639	292	1.534694	4.48130648	Vitis vinifera	29760	Plants	Plants	52.8	0.027	NTclustered	gi\|147777539\|emb\|AM432656.2\|	29760	g2592	i0	96.774	0.106164383561644	31	1	11	0	77	107	616	586	Vitis vinifera contig VV78X053000.2, whole genome shotgun sequence	blastn	31	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Vitales	Vitaceae	Vitis	Vitis vinifera
23371228	23371228	PRJNA415636_S_NODE_6819_length_197_cov_2.040000_g6772_i0	PRJNA415636	6819	197	2.04	4.0188	Triticum aestivum	4565	Plants	Plants	91.6	3.62e-14	NTclustered	gi\|2123604979\|ref\|XM_044565676.1\|	4565	g6772	i0	86.585	8.43654822335025	82	11	42	0	116	197	476	395	PREDICTED: Triticum aestivum 60S ribosomal protein L18a-like (LOC123146086), mRNA	blastn	1662	91.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum aestivum
25309417	25309417	PRJNA415636_S_NODE_1760_length_338_cov_1.261168_g1713_i0	PRJNA415636	1760	338	1.261168	4.26274784	Poaceae	4479	Plants	Plants	619	6.969999999999999e-173	NTclustered	gi\|2307846209\|gb\|OM049555.1\|	4545	g1713	i0	99.704	100	338	1	100	0	1	338	503	166	Poa pratensis voucher Po_p_1 chloroplast, complete genome	blastn	33800	619	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Poa	Poa pratensis
27345262	27345262	PRJNA415636_S_NODE_2583_length_294_cov_2.773279_g2536_i0	PRJNA415636	2583	294	2.773279	8.15344026	Magnoliopsida	3398	Plants	Plants	75.9	7.72e-15	NR	XP_012843457.1	4155	g2536	i0	64.9	5.37755102040816	57	19	58.2	1	3	173	105	160	XP_012843457.1 PREDICTED: 40S ribosomal protein S11-2 [Erythranthe guttata]	diamond	1581	76.6	0.990861618798956	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Phrymaceae	Erythranthe	Erythranthe guttata
27408507	27408507	PRJNA415636_S_NODE_1843_length_333_cov_4.339161_g1796_i0	PRJNA415636	1843	333	4.339161	14.44940613	Magnoliopsida	3398	Plants	Plants	44.3	0.0271	NR	XP_012834334.1	4155	g1796	i0	42.6	1.87387387387387	47	27	42.3	0	330	190	177	223	XP_012834334.1 PREDICTED: polygalacturonase inhibitor-like [Erythranthe guttata]	diamond	624	44.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Lamiales	Phrymaceae	Erythranthe	Erythranthe guttata
28402000	28402000	PRJNA415636_S_NODE_3706_length_256_cov_3.186603_g3659_i0	PRJNA415636	3706	256	3.186603	8.15770368	Arabidopsis arenosa	38785	Plants	Plants	47	0.00135	NR	CAE5958279.1	38785	g3659	i0	54.8	0.78515625	42	19	49.2	0	256	131	127	168	CAE5958279.1 unnamed protein product [Arabidopsis arenosa]	diamond	201	47	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Brassicales	Brassicaceae	Arabidopsis	Arabidopsis arenosa
29160009	29160009	PRJNA415636_S_NODE_5989_length_212_cov_0.963636_g5942_i0	PRJNA415636	5989	212	0.963636	2.04290832	Anisodus tanguticus	243964	Plants	Plants	45.1	0.00245	NR	KAK4378931.1	243964	g5942	i0	61.3	0.438679245283019	31	12	43.9	0	203	111	12	42	KAK4378931.1 hypothetical protein RND71_000793 [Anisodus tanguticus]	diamond	93	45.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Solanales	Solanaceae	Anisodus	Anisodus tanguticus

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