metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJEB56027" and tax

7 rows where analysis = "diamond", bioproject = "PRJEB56027" and tax_phylum = "Chordata"

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
28542975	28542975	PRJEB56027_P_NODE_125227_length_245_cov_1.151163_g122418_i0	PRJEB56027	125227	245	1.151163	2.82034935	Chondrichthyes	7777	Chordata	Chordata	42.7	0.00357	NR	XP_043920545.1	7888	g122418	i0	72.7	2.27755102040816	22	6	26.9	0	3	68	14	35	XP_043920545.1 mitochondrial import receptor subunit TOM7 homolog [Protopterus annectens]	diamond	558	42.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Ceratodontiformes	Protopteridae	Protopterus	Protopterus annectens
29149834	29149834	PRJEB56027_P_NODE_82589_length_295_cov_1.887387_g79780_i0	PRJEB56027	82589	295	1.887387	5.56779165	Apodemus speciosus	105296	Chordata	Chordata	45.4	0.00713	NR	GAB1285821.1	105296	g79780	i0	76	0.254237288135593	25	6	25.4	0	293	219	210	234	GAB1285821.1 BRO1 domain-containing protein BROX [Apodemus speciosus]	diamond	75	45.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Apodemus	Apodemus speciosus
30476044	30476044	PRJEB56027_P_NODE_106013_length_260_cov_4.786096_g103204_i0	PRJEB56027	106013	260	4.786096	12.4438496	Cricetulus griseus	10029	Chordata	Chordata	62.8	3.95e-9	NR	XP_035294646.1	10029	g103204	i0	70.6	0.588461538461538	51	15	58.8	0	3	155	64	114	XP_035294646.1 triadin isoform X2 [Cricetulus griseus]	diamond	153	62.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Cricetulus	Cricetulus griseus
30823476	30823476	PRJEB56027_P_NODE_95614_length_274_cov_9.437811_g92805_i0	PRJEB56027	95614	274	9.437811	25.85960214	Marmota monax	9995	Chordata	Chordata	110	1.78e-26	NR	KAF7473563.1	9995	g92805	i0	84	0.821167883211679	75	8	82.1	1	274	50	79	149	KAF7473563.1 hypothetical protein GHT09_015818 [Marmota monax]	diamond	225	110	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Sciuridae	Marmota	Marmota monax
31076358	31076358	PRJEB56027_P_NODE_130335_length_242_cov_1.822485_g127526_i0	PRJEB56027	130335	242	1.822485	4.4104137	Pitangus sulphuratus	371930	Chordata	Chordata	51.6	1.27e-5	NR	KAJ7423106.1	371930	g127526	i0	45.6	1.59917355371901	57	31	70.7	0	65	235	60	116	KAJ7423106.1 hypothetical protein BTVI_11052 [Pitangus sulphuratus]	diamond	387	51.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Tyrannidae	Pitangus	Pitangus sulphuratus
31550775	31550775	PRJEB56027_P_NODE_134496_length_238_cov_2.357576_g131687_i0	PRJEB56027	134496	238	2.357576	5.61103088	Neofelis nebulosa	61452	Chordata	Chordata	43.9	0.0131	NR	XP_058578297.1	61452	g131687	i0	43.3	0.756302521008403	60	27	66.8	1	226	68	131	190	XP_058578297.1 LINE-1 retrotransposable element ORF2 protein isoform X3 [Neofelis nebulosa]	diamond	180	43.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Neofelis	Neofelis nebulosa
31740165	31740165	PRJEB56027_P_NODE_109897_length_256_cov_1.229508_g107088_i0	PRJEB56027	109897	256	1.229508	3.14754048	Melopsittacus undulatus	13146	Chordata	Chordata	43.9	0.0172	NR	XP_033929501.1	13146	g107088	i0	49.1	0.64453125	55	23	58.6	1	210	61	35	89	XP_033929501.1 serine/threonine-protein kinase TAO2-like, partial [Melopsittacus undulatus]	diamond	165	43.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Psittaciformes	Psittaculidae	Melopsittacus	Melopsittacus undulatus

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