metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA492280" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA492280" 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
26855143	26855143	PRJNA492280_P_NODE_6881_length_198_cov_358.844720_g6774_i0	PRJNA492280	6881	198	358.84472	710.5125456	Naja naja	35670	Chordata	Chordata	42.7	0.0198	NR	KAG8126713.1	35670	g6774	i0	54.7	1.84848484848485	64	29	97	0	192	1	61	124	KAG8126713.1 hypothetical protein E2320_021784 [Naja naja]	diamond	366	43.1	0.990719257540603	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Elapidae	Naja	Naja naja
28939729	28939729	PRJNA492280_P_NODE_10348_length_167_cov_7.692308_g10241_i0	PRJNA492280	10348	167	7.692308	12.84615436	Sus scrofa	9823	Chordata	Chordata	55.8	3.14e-7	NR	XP_020938199.1	9823	g10241	i0	96	1.34730538922156	25	1	44.9	0	167	93	376	400	XP_020938199.1 ribonuclease inhibitor isoform X2 [Sus scrofa]	diamond	225	55.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
29145354	29145354	PRJNA492280_P_NODE_20429_length_164_cov_3.267717_g20322_i0	PRJNA492280	20429	164	3.267717	5.35905588	Mammalia	40674	Chordata	Chordata	54.7	7.76e-7	NR	XP_004717300.2	9371	g20322	i0	100	29.890243902439	25	0	45.7	0	76	2	463	487	XP_004717300.2 UHRF1-binding protein 1, partial [Echinops telfairi]	diamond	4902	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia		Tenrecidae	Echinops	Echinops telfairi
30107894	30107894	PRJNA492280_P_NODE_25532_length_164_cov_2.448819_g25425_i0	PRJNA492280	25532	164	2.448819	4.01606316	Cricetulus griseus	10029	Chordata	Chordata	52.4	4.71e-6	NR	ERE47263.1	10029	g25425	i0	100	0.457317073170732	25	0	45.7	0	2	76	135	159	ERE47263.1 Flagellar hook-associated protein 1, partial [Cricetulus griseus]	diamond	75	52.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Cricetulus	Cricetulus griseus
30107897	30107897	PRJNA492280_P_NODE_4232_length_244_cov_2.521739_g4125_i0	PRJNA492280	4232	244	2.521739	6.15304316	Limnonectes cf. grunniens	645703	Chordata	Chordata	68.6	9.5e-12	NR	QIV62771.1	645703	g4125	i0	55.7	0.971311475409836	79	35	97.1	0	8	244	22	100	QIV62771.1 cytochrome c oxidase subunit I, partial [Limnonectes cf. grunniens]	diamond	237	68.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Dicroglossidae	Limnonectes	Limnonectes cf. grunniens
30440122	30440122	PRJNA492280_P_NODE_5033_length_226_cov_67.349206_g4926_i0	PRJNA492280	5033	226	67.349206	152.20920556	Mammalia	40674	Chordata	Chordata	48.9	1.96e-4	NR	XP_055003046.1	42254	g4926	i0	89.3	0.730088495575221	28	3	37.2	0	16	99	23	50	XP_055003046.1 collagen alpha-1(I) chain-like [Sorex araneus]	diamond	165	49.3	0.991886409736308	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Eulipotyphla	Soricidae	Sorex	Sorex araneus
31245430	31245430	PRJNA492280_P_NODE_17455_length_164_cov_3.850394_g17348_i0	PRJNA492280	17455	164	3.850394	6.31464616	Chinchilla lanigera	34839	Chordata	Chordata	43.1	0.00935	NR	XP_013358660.1	34839	g17348	i0	51.2	5.19512195121951	41	15	75	1	41	163	179	214	XP_013358660.1 PREDICTED: arylsulfatase G isoform X3 [Chinchilla lanigera]	diamond	852	43.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Chinchillidae	Chinchilla	Chinchilla lanigera
32605604	32605604	PRJNA492280_P_NODE_31980_length_151_cov_1.210526_g31873_i0	PRJNA492280	31980	151	1.210526	1.82789426	Polypterus senegalus	55291	Chordata	Chordata	47	3.39e-4	NR	KAG2459877.1	55291	g31873	i0	61.8	1.41059602649007	34	13	67.5	0	22	123	27	60	KAG2459877.1 TCB1 transposase, partial [Polypterus senegalus]	diamond	213	47	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
32668503	32668503	PRJNA492280_P_NODE_27740_length_160_cov_6.317073_g27633_i0	PRJNA492280	27740	160	6.317073	10.1073168	Capra hircus	9925	Chordata	Chordata	42.4	0.00286	NR	ABO20784.1	9925	g27633	i0	41.2	1.9125	51	30	95.6	0	8	160	25	75	ABO20784.1 cytochrome b, partial [Capra hircus]	diamond	306	42.7	0.992974238875878	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Capra	Capra hircus

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