metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA1215774" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA1215774" 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
27578193	27578193	PRJNA1215774_P_NODE_82264_length_242_cov_0.911243_g81944_i0	PRJNA1215774	82264	242	0.911243	2.20520806	Humulus lupulus	3486	Plants	Plants	46.6	0.00155	NR	XP_062093395.1	3486	g81944	i0	58.8	0.421487603305785	34	14	42.1	0	140	241	100	133	XP_062093395.1 uncharacterized protein LOC133799391 [Humulus lupulus]	diamond	102	46.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Cannabaceae	Humulus	Humulus lupulus
29788224	29788224	PRJNA1215774_P_NODE_55671_length_282_cov_1.296651_g55351_i0	PRJNA1215774	55671	282	1.296651	3.65655582	Ficus carica	3494	Plants	Plants	161	9.08e-46	NR	GMN27810.1	3494	g55351	i0	75.5	1	94	23	100	0	1	282	52	145	GMN27810.1 hypothetical protein TIFTF001_001808 [Ficus carica]	diamond	282	161	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Moraceae	Ficus	Ficus carica
30294252	30294252	PRJNA1215774_P_NODE_83252_length_242_cov_0.911243_g82932_i0	PRJNA1215774	83252	242	0.911243	2.20520806	Camellia sinensis var. sinensis	542762	Plants	Plants	43.5	0.0097	NR	GMP76123.1	542762	g82932	i0	35.1	2.75206611570248	74	38	80.6	2	229	35	49	121	GMP76123.1 hypothetical protein CsSME_00032934 [Camellia sinensis var. sinensis]	diamond	666	43.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ericales	Theaceae	Camellia	Camellia sinensis
31684400	31684400	PRJNA1215774_P_NODE_74537_length_247_cov_0.885057_g74217_i0	PRJNA1215774	74537	247	0.885057	2.18609079	Ficus carica	3494	Plants	Plants	58.9	1.81e-9	NR	GMN54804.1	3494	g74217	i0	61.1	0.65587044534413	54	14	65.6	1	2	163	15	61	GMN54804.1 hypothetical protein TIFTF001_023931 [Ficus carica]	diamond	162	58.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Moraceae	Ficus	Ficus carica
32349212	32349212	PRJNA1215774_P_NODE_68119_length_251_cov_1.730337_g67799_i0	PRJNA1215774	68119	251	1.730337	4.34314587	Syzygium oleosum	219896	Plants	Plants	47	0.0013	NR	XP_056158510.1	219896	g67799	i0	37.2	2.18725099601594	86	38	84.9	3	215	3	52	136	XP_056158510.1 uncharacterized protein LOC115667535 [Syzygium oleosum]	diamond	549	47	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Myrtales	Myrtaceae	Syzygium	Syzygium oleosum
32696274	32696274	PRJNA1215774_P_NODE_77500_length_245_cov_1.273256_g77180_i0	PRJNA1215774	77500	245	1.273256	3.1194772	Platanthera zijinensis	2320716	Plants	Plants	50.8	5.13e-5	NR	KAK8944460.1	2320716	g77180	i0	52.8	1.33469387755102	36	17	44.1	0	243	136	119	154	KAK8944460.1 hypothetical protein KSP39_PZI008051 [Platanthera zijinensis]	diamond	327	50.8	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Asparagales	Orchidaceae	Platanthera	Platanthera zijinensis

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