metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA283169" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA283169" and tax_kingdom = "Metazoa"

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
26598975	26598975	PRJNA283169_P_NODE_4401_length_201_cov_1.309211_g4338_i0	PRJNA283169	4401	201	1.309211	2.63151411	Hypanus sabinus	79690	Chordata	Chordata	44.3	0.00591	NR	XP_059837717.1	79690	g4338	i0	43.1	1.55223880597015	51	27	73.1	1	17	163	200	250	XP_059837717.1 uncharacterized protein LOC132400604 [Hypanus sabinus]	diamond	312	44.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Myliobatiformes	Dasyatidae	Hypanus	Hypanus sabinus
26694188	26694188	PRJNA283169_S_NODE_3481_length_161_cov_0.857143_g3467_i0	PRJNA283169	3481	161	0.857143	1.38000023	Staurois parvus	386267	Chordata	Chordata	43.9	0.00122	NR	CAI9618505.1	386267	g3467	i0	50	1.49068322981366	40	20	74.5	0	2	121	12	51	CAI9618505.1 unnamed protein product, partial [Staurois parvus]	diamond	240	43.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
26775469	26775469	PRJNA283169_P_NODE_2301_length_271_cov_1.513514_g2239_i0	PRJNA283169	2301	271	1.513514	4.10162294	root	1	Root_unresolved	Root_unresolved	151	1.74e-40	NR	CAD7254458.1	69355	g2239	i0	82.4	3.02214022140221	91	14	98.5	1	3	269	253	343	CAD7254458.1 unnamed protein product, partial [Darwinula stevensoni]	diamond	819	152	0.993421052631579	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Darwinulidae	Darwinula	Darwinula stevensoni
26838863	26838863	PRJNA283169_S_NODE_2321_length_187_cov_1.108696_g2307_i0	PRJNA283169	2321	187	1.108696	2.07326152	root	1	Root_unresolved	Root_unresolved	45.1	0.00275	NR	PFX21664.1	50429	g2307	i0	42.2	1.31550802139037	45	26	72.2	0	160	26	230	274	PFX21664.1 hypothetical protein AWC38_SpisGene13848 [Stylophora pistillata]	diamond	246	45.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
26979169	26979169	PRJNA283169_S_NODE_2722_length_175_cov_1.214286_g2708_i0	PRJNA283169	2722	175	1.214286	2.1250005	Asterias rubens	7604	Echinodermata	other_Eukaryota	68.9	1.82e-12	NR	XP_033630533.1	7604	g2708	i0	62.7	1.71428571428571	51	19	87.4	0	153	1	24	74	XP_033630533.1 apolipoprotein D-like [Asterias rubens]	diamond	300	68.9	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
28828528	28828528	PRJNA283169_P_NODE_5688_length_179_cov_1.976923_g5625_i0	PRJNA283169	5688	179	1.976923	3.53869217	Arthropoda	6656	Arthropoda	Arthropoda	63.9	2e-10	NR	XP_014247543.1	79782	g5625	i0	66.7	7.18994413407821	39	13	65.4	0	1	117	161	199	XP_014247543.1 trafficking protein particle complex subunit 4 [Cimex lectularius]	diamond	1287	64.3	0.993779160186625	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Cimicidae	Cimex	Cimex lectularius
30264006	30264006	PRJNA283169_P_NODE_7192_length_165_cov_1.258621_g7129_i0	PRJNA283169	7192	165	1.258621	2.07672465	Adineta vaga	104782	Rotifera	other_Eukaryota	58.5	3.5e-8	NR	UJR28860.1	104782	g7129	i0	61.5	0.709090909090909	39	15	70.9	0	138	22	186	224	UJR28860.1 hypothetical protein I4U23_010083 [Adineta vaga]	diamond	117	58.5	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
30913419	30913419	PRJNA283169_P_NODE_6094_length_173_cov_1.580645_g6031_i0	PRJNA283169	6094	173	1.580645	2.73451585	Opisthokonta	33154	Chordata	Chordata	61.6	3.18e-9	NR	XP_053571958.1	8345	g6031	i0	73.7	4.59537572254335	38	10	65.9	0	58	171	1209	1246	XP_053571958.1 maestro heat-like repeat-containing protein family member 1 [Bombina bombina]	diamond	795	61.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bombinatoridae	Bombina	Bombina bombina
31008086	31008086	PRJNA283169_P_NODE_714_length_453_cov_2.002475_g652_i0	PRJNA283169	714	453	2.002475	9.07121175	root	1	Root_unresolved	Root_unresolved	171	3.2899999999999993e-46	NR	CAK8618466.1	30338	g652	i0	56.5	23.3576158940397	147	64	97.4	0	449	9	538	684	CAK8618466.1 Transposon Tf2-6 polyprotein [Bufotes viridis]	diamond	10581	172	0.994186046511628	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
31147947	31147947	PRJNA283169_S_NODE_1335_length_235_cov_2.150538_g1321_i0	PRJNA283169	1335	235	2.150538	5.0537643	Lasius niger	67767	Arthropoda	Arthropoda	43.1	0.0228	NR	KMQ86303.1	67767	g1321	i0	53.3	0.382978723404255	30	14	38.3	0	20	109	216	245	KMQ86303.1 copia protein [Lasius niger]	diamond	90	43.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Formicidae	Lasius	Lasius niger
31179629	31179629	PRJNA283169_P_NODE_2855_length_246_cov_0.944162_g2792_i0	PRJNA283169	2855	246	0.944162	2.32263852	Gigantopelta aegis	1735272	Mollusca	Mollusca	54.3	3.15e-6	NR	XP_041355333.1	1735272	g2792	i0	61.5	0.475609756097561	39	15	47.6	0	200	84	369	407	XP_041355333.1 signal peptide peptidase-like 2B [Gigantopelta aegis]	diamond	117	54.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neomphalida	Peltospiridae	Gigantopelta	Gigantopelta aegis
31608799	31608799	PRJNA283169_S_NODE_1716_length_212_cov_0.104294_g1702_i0	PRJNA283169	1716	212	0.104294	0.22110328	Pocilloporidae	46729	Cnidaria	other_Eukaryota	57.4	1.71e-7	NR	RMX41873.1	46731	g1702	i0	42.6	5.17924528301887	61	35	86.3	0	184	2	899	959	RMX41873.1 hypothetical protein pdam_00019624, partial [Pocillopora damicornis]	diamond	1098	57.8	0.993079584775087	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis
31970667	31970667	PRJNA283169_P_NODE_5598_length_181_cov_1.136364_g5535_i0	PRJNA283169	5598	181	1.136364	2.05681884	Dysidea avara	196820	Porifera	other_Eukaryota	50.1	4.27e-5	NR	XP_065895271.1	196820	g5535	i0	43.1	0.961325966850829	58	33	96.1	0	177	4	457	514	XP_065895271.1 uncharacterized protein [Dysidea avara]	diamond	174	50.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
32160754	32160754	PRJNA283169_P_NODE_8038_length_162_cov_0.920354_g7975_i0	PRJNA283169	8038	162	0.920354	1.49097348	Staurois parvus	386267	Chordata	Chordata	56.2	6.51e-9	NR	CAI9620946.1	386267	g7975	i0	71.4	0.648148148148148	35	10	64.8	0	161	57	25	59	CAI9620946.1 unnamed protein product [Staurois parvus]	diamond	105	56.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
32192289	32192289	PRJNA283169_P_NODE_8058_length_162_cov_0.920354_g7995_i0	PRJNA283169	8058	162	0.920354	1.49097348	Maniola jurtina	191418	Arthropoda	Arthropoda	58.9	2.47e-8	NR	XP_045776096.1	191418	g7995	i0	50	1.94444444444444	54	26	98.1	1	162	4	523	576	XP_045776096.1 uncharacterized protein LOC123874648 [Maniola jurtina]	diamond	315	58.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Nymphalidae	Maniola	Maniola jurtina

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