metadata: contig_metadata: 17 rows where bioproject = "PRJNA393181" and tax

17 rows where bioproject = "PRJNA393181" 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
2961620	2961620	PRJNA393181_S_NODE_463_length_1044_cov_4.138034_g416_i0	PRJNA393181	463	1044	4.138034	43.20107496	Hordeum vulgare	4513	Plants	Plants	1868	0	NTclustered	gi\|151426205\|dbj\|AK252797.1\|	112509	g416	i0	98.946	85.2298850574713	1044	11	100	0	1	1044	1107	64	Hordeum vulgare subsp. vulgare cDNA clone: FLbaf172m04, mRNA sequence	blastn	88980	1868	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
3629061	3629061	PRJNA393181_S_NODE_11563_length_355_cov_2.468553_g11457_i0	PRJNA393181	11563	355	2.468553	8.76336315	root	1	Root_unresolved	Root_unresolved	568	2.6999999999999993e-157	NTclustered	gi\|417451531\|gb\|KC129717.1\|	75702	g11457	i0	95.493	100.045070422535	355	16	100	0	1	355	64553	64199	Populus euphratica clone BIBAC2A1F6, complete sequence	blastn	35516	568	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malpighiales	Salicaceae	Populus	Populus euphratica
6788117	6788117	PRJNA393181_S_NODE_25206_length_228_cov_3.879581_g25100_i0	PRJNA393181	25206	228	3.879581	8.84544468	Oryza sativa	4530	Plants	Plants	124	4.25e-24	NTclustered	gi\|2668294530\|dbj\|AP027385.1\|	1771142	g25100	i0	80.702	35.3728070175439	171	23	73	6	63	228	2024153	2023988	Oryza sativa indica subgroup Inn Ma Yebaw DNA, chromosome: 1	blastn	8065	124	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza sativa
7456529	7456529	PRJNA393181_S_NODE_37726_length_176_cov_1.676259_g37620_i0	PRJNA393181	37726	176	1.676259	2.95021584	root	1	Root_unresolved	Root_unresolved	309	7.98e-80	NTclustered	gi\|417451531\|gb\|KC129717.1\|	75702	g37620	i0	98.295	99.8977272727273	176	3	100	0	1	176	81329	81154	Populus euphratica clone BIBAC2A1F6, complete sequence	blastn	17582	309	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malpighiales	Salicaceae	Populus	Populus euphratica
8064096	8064096	PRJNA393181_S_NODE_41627_length_164_cov_3.267717_g41521_i0	PRJNA393181	41627	164	3.267717	5.35905588	Populus euphratica	75702	Plants	Plants	248	1.63e-61	NTclustered	gi\|417451531\|gb\|KC129717.1\|	75702	g41521	i0	93.902	100.024390243902	164	10	100	0	1	164	37595	37758	Populus euphratica clone BIBAC2A1F6, complete sequence	blastn	16404	248	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malpighiales	Salicaceae	Populus	Populus euphratica
8064381	8064381	PRJNA393181_S_NODE_9447_length_392_cov_2.600000_g9341_i0	PRJNA393181	9447	392	2.6	10.192	Hordeum vulgare	4513	Plants	Plants	52.8	0.037	NTclustered	gi\|326519449\|dbj\|AK365521.1\|	112509	g9341	i0	100	0.142857142857143	28	0	7	0	246	273	368	395	Hordeum vulgare subsp. vulgare mRNA for predicted protein, partial cds, clone: NIASHv2034M16	blastn	56	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
8731281	8731281	PRJNA393181_S_NODE_35647_length_183_cov_1.520548_g35541_i0	PRJNA393181	35647	183	1.520548	2.78260284	Poaceae	4479	Plants	Plants	60.2	9.31e-5	NTclustered	gi\|2123983829\|ref\|XM_044583439.1\|	4565	g35541	i0	97.143	1.66666666666667	35	1	19	0	58	92	367	333	PREDICTED: Triticum aestivum ABC transporter C family member 10-like (LOC123165727), transcript variant X3, mRNA	blastn	305	60.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum aestivum
10614694	10614694	PRJNA393181_S_NODE_44229_length_158_cov_1.685950_g44123_i0	PRJNA393181	44229	158	1.68595	2.663801	Phragmites australis	29695	Plants	Plants	56.5	0.001	NTclustered	gi\|2649475268\|ref\|XM_062337977.1\|	29695	g44123	i0	96.97	0.208860759493671	33	1	21	0	109	141	669	701	PREDICTED: Phragmites australis probable polygalacturonase (LOC133897301), mRNA	blastn	33	56.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Phragmites	Phragmites australis
12557358	12557358	PRJNA393181_S_NODE_47230_length_151_cov_2.052632_g47124_i0	PRJNA393181	47230	151	2.052632	3.09947432	Oryza	4527	Plants	Plants	54.7	0.003	NTclustered	gi\|2348138281\|ref\|XM_052291434.1\|	4538	g47124	i0	100	0.80794701986755	29	0	19	0	115	143	184	156	PREDICTED: Oryza glaberrima uncharacterized LOC127766379 (LOC127766379), mRNA	blastn	122	54.7	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Oryza	Oryza glaberrima
13164800	13164800	PRJNA393181_S_NODE_7931_length_424_cov_1.966408_g7825_i0	PRJNA393181	7931	424	1.966408	8.33756992	Eragrostis tef	110835	Plants	Plants	52.8	0.041	NTclustered	gi\|2710185557\|gb\|CP137586.1\|	110835	g7825	i0	100	0.0660377358490566	28	0	7	0	51	78	22921640	22921667	Eragrostis tef cultivar Dabbi chromosome 3A	blastn	28	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Eragrostis	Eragrostis tef
15712777	15712777	PRJNA393181_S_NODE_14033_length_321_cov_4.940141_g13927_i0	PRJNA393181	14033	321	4.940141	15.85785261	Phyllostachys edulis	38705	Plants	Plants	76.8	1.79e-9	NTclustered	gi\|242375395\|emb\|FP096158.1\|	38705	g13927	i0	84.416	1.601246105919	77	12	24	0	238	314	158	82	Phyllostachys edulis cDNA clone: bphyem001c01, full insert sequence	blastn	514	76.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Phyllostachys	Phyllostachys edulis
19535902	19535902	PRJNA393181_S_NODE_13536_length_328_cov_1.896907_g13430_i0	PRJNA393181	13536	328	1.896907	6.22185496	Cannabis sativa	3483	Plants	Plants	52.8	0.031	NTclustered	gi\|2748541970\|gb\|CP158650.1\|	3483	g13430	i0	100	0.0853658536585366	28	0	9	0	222	249	60922556	60922583	Cannabis sativa cultivar ERBxHO40_23 chromosome 9	blastn	28	52.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Cannabaceae	Cannabis	Cannabis sativa
23362427	23362427	PRJNA393181_S_NODE_22199_length_247_cov_81.442857_g22093_i0	PRJNA393181	22199	247	81.442857	201.16385679	Cecropia pachystachya	1472306	Plants	Plants	76.8	1.32e-9	NTclustered	gi\|2254130330\|gb\|OM892756.1\|	1472306	g22093	i0	92.593	18.0526315789474	54	2	28	2	2	54	2974	2922	Cecropia pachystachya isolate W55 18S small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S large subunit ribosomal RNA gene, partial sequence	blastn	4459	76.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Urticaceae	Cecropia	Cecropia pachystachya
24637085	24637085	PRJNA393181_S_NODE_37920_length_175_cov_2.384058_g37814_i0	PRJNA393181	37920	175	2.384058	4.1721015	Macleaya cordata	56857	Plants	Plants	65.9	2.66e-11	NR	OVA17630.1	56857	g37814	i0	59.6	3.75428571428571	57	21	94.3	1	165	1	113	169	OVA17630.1 Small GTPase superfamily [Macleaya cordata]	diamond	657	65.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ranunculales	Papaveraceae	Macleaya	Macleaya cordata
29460173	29460173	PRJNA393181_S_NODE_31930_length_197_cov_0.968750_g31824_i0	PRJNA393181	31930	197	0.96875	1.9084375	Magnoliopsida	3398	Plants	Plants	63.9	1.22e-10	NR	XP_028115218.1	4442	g31824	i0	64.4	7.29441624365482	59	20	88.3	1	196	23	87	145	XP_028115218.1 transmembrane protein 208-like [Camellia sinensis]	diamond	1437	63.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ericales	Theaceae	Camellia	Camellia sinensis
31339194	31339194	PRJNA393181_S_NODE_43996_length_159_cov_0.942623_g43890_i0	PRJNA393181	43996	159	0.942623	1.49877057	Ceratodon purpureus	3225	Plants	Plants	89.4	2.77e-21	NR	KAG0576969.1	3225	g43890	i0	90.6	1	53	5	100	0	159	1	46	98	KAG0576969.1 hypothetical protein KC19_5G122100 [Ceratodon purpureus]	diamond	159	89.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Bryopsida	Pseudoditrichales	Ditrichaceae	Ceratodon	Ceratodon purpureus
32761960	32761960	PRJNA393181_S_NODE_34500_length_187_cov_1.280000_g34394_i0	PRJNA393181	34500	187	1.28	2.3936	Trapa incisa	236973	Plants	Plants	42.4	0.0237	NR	KAK4750609.1	236973	g34394	i0	39.2	1.66844919786096	51	30	80.2	1	152	3	257	307	KAK4750609.1 hypothetical protein SAY87_004091 [Trapa incisa]	diamond	312	42.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Myrtales	Lythraceae	Trapa	Trapa incisa

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