metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1233317" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1233317" and tax_kingdom = "Viridiplantae"

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
335702	335702	PRJNA1233317_S_NODE_8621_length_263_cov_3.186275_g8585_i0	PRJNA1233317	8621	263	3.186275	8.37990325	Viridiplantae	33090	Plants	Plants	57	1.94e-7	NR	KDD75683.1	1291522	g8585	i0	100	2.36121673003802	26	0	29.7	0	1	78	165	190	KDD75683.1 hypothetical protein H632_c551p0 [Helicosporidium sp. ATCC 50920]	diamond	621	57	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Helicosporidium	Helicosporidium sp. ATCC 50920
16349638	16349638	PRJNA1233317_S_NODE_3273_length_353_cov_8.370748_g3237_i0	PRJNA1233317	3273	353	8.370748	29.54874044	Eukaryota	2759	Plants	Plants	100	5.639999999999999e-24	NR	AFK43985.1	34305	g3237	i0	52.9	1.48725212464589	87	41	73.9	0	349	89	87	173	AFK43985.1 unknown [Lotus japonicus]	diamond	525	101	0.99009900990099	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fabales	Fabaceae	Lotus	Lotus japonicus
27389026	27389026	PRJNA1233317_S_NODE_2083_length_389_cov_2.469697_g2047_i0	PRJNA1233317	2083	389	2.469697	9.60712133	Chlamydomonas eustigma	1157962	Plants	Plants	52	9.6e-5	NR	GAX76654.1	1157962	g2047	i0	46.7	0.694087403598972	90	41	68.6	3	121	387	124	207	GAX76654.1 hypothetical protein CEUSTIGMA_g4100.t1 [Chlamydomonas eustigma]	diamond	270	52	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas eustigma
27578274	27578274	PRJNA1233317_S_NODE_12364_length_220_cov_5.304348_g12328_i0	PRJNA1233317	12364	220	5.304348	11.6695656	Corylus avellana	13451	Plants	Plants	43.1	0.0194	NR	XP_059455071.1	13451	g12328	i0	45.7	0.627272727272727	46	25	62.7	0	14	151	38	83	XP_059455071.1 LEAF RUST 10 DISEASE-RESISTANCE LOCUS RECEPTOR-LIKE PROTEIN KINASE-like 2.1 [Corylus avellana]	diamond	138	43.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Fagales	Betulaceae	Corylus	Corylus avellana
28575759	28575759	PRJNA1233317_S_NODE_3047_length_359_cov_9.760000_g3011_i0	PRJNA1233317	3047	359	9.76	35.0384	Trebouxia	13786	Plants	Plants	65.9	9.91e-10	NR	KAL0029491.1	2905653	g3011	i0	57.1	1.22841225626741	49	21	40.9	0	2	148	350	398	KAL0029491.1 hypothetical protein WJX77_011613 [Trebouxia sp. C0004]	diamond	441	65.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0004
29346520	29346520	PRJNA1233317_S_NODE_15929_length_192_cov_3.894737_g15893_i0	PRJNA1233317	15929	192	3.894737	7.47789504	Gossypium hirsutum	3635	Plants	Plants	41.2	0.0267	NR	XP_040962453.1	3635	g15893	i0	42.9	0.65625	42	19	57.8	1	156	46	68	109	XP_040962453.1 uncharacterized protein [Gossypium hirsutum]	diamond	126	41.2	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Malvales	Malvaceae	Gossypium	Gossypium hirsutum
30326067	30326067	PRJNA1233317_S_NODE_13632_length_209_cov_1.626667_g13596_i0	PRJNA1233317	13632	209	1.626667	3.39973403	Micractinium conductrix	554055	Plants	Plants	58.5	6.42e-8	NR	PSC69493.1	554055	g13596	i0	49.2	0.933014354066986	65	33	93.3	0	13	207	809	873	PSC69493.1 Acyl-coenzyme A thioesterase mitochondrial [Micractinium conductrix]	diamond	195	58.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Micractinium	Micractinium conductrix
30641326	30641326	PRJNA1233317_S_NODE_9113_length_257_cov_2.646465_g9077_i0	PRJNA1233317	9113	257	2.646465	6.80141505	Coccomyxa subellipsoidea C-169	574566	Plants	Plants	93.2	2.38e-22	NR	XP_005649206.1	574566	g9077	i0	79.2	1.23735408560311	53	11	61.9	0	255	97	13	65	XP_005649206.1 ribosomal protein 60S [Coccomyxa subellipsoidea C-169]	diamond	318	93.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea

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