metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA1245487" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA1245487" and tax_phylum = "Arthropoda"

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
1051574	1051574	PRJNA1245487_P_NODE_9101_length_401_cov_0.951220_g8763_i0	PRJNA1245487	9101	401	0.95122	3.8143922	Rhynocoris fuscipes	488301	Arthropoda	Arthropoda	175	2.62e-51	NR	KAK9506973.1	488301	g8763	i0	61.7	0.99501246882793	133	47	99.5	2	2	400	101	229	KAK9506973.1 hypothetical protein O3M35_008812 [Rhynocoris fuscipes]	diamond	399	175	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Reduviidae	Rhynocoris	Rhynocoris fuscipes
9279323	9279323	PRJNA1245487_P_NODE_18248_length_260_cov_1.438503_g17910_i0	PRJNA1245487	18248	260	1.438503	3.7401078	Insecta	50557	Arthropoda	Arthropoda	98.6	5.86e-25	NR	XP_022196191.1	108931	g17910	i0	81.7	4.93846153846154	60	11	69.2	0	73	252	1	60	XP_022196191.1 nuclear protein 1 [Nilaparvata lugens]	diamond	1284	99.4	0.991951710261569	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Delphacidae	Nilaparvata	Nilaparvata lugens
11829764	11829764	PRJNA1245487_P_NODE_21810_length_243_cov_0.917647_g21472_i0	PRJNA1245487	21810	243	0.917647	2.22988221	Cherax quadricarinatus	27406	Arthropoda	Arthropoda	70.9	6.38e-13	NR	KAK8741022.1	27406	g21472	i0	54.9	5.25925925925926	71	17	87.7	1	213	1	3	58	KAK8741022.1 hypothetical protein OTU49_002452 [Cherax quadricarinatus]	diamond	1278	70.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Parastacidae	Cherax	Cherax quadricarinatus
16928334	16928334	PRJNA1245487_P_NODE_20274_length_248_cov_2.211429_g19936_i0	PRJNA1245487	20274	248	2.211429	5.48434392	Eurytemora carolleeae	1294199	Arthropoda	Arthropoda	138	4.41e-38	NR	XP_023348667.1	1294199	g19936	i0	82.9	1.98387096774194	82	14	99.2	0	2	247	215	296	XP_023348667.1 ADP,ATP carrier protein 3, mitochondrial [Eurytemora carolleeae]	diamond	492	138	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Calanoida	Temoridae	Eurytemora	Eurytemora carolleeae
26978631	26978631	PRJNA1245487_P_NODE_22302_length_238_cov_6.460606_g21964_i0	PRJNA1245487	22302	238	6.460606	15.37624228	Nephila pilipes	299642	Arthropoda	Arthropoda	43.1	0.00628	NR	GFT14838.1	299642	g21964	i0	56.4	1.86554621848739	39	17	49.2	0	1	117	50	88	GFT14838.1 hypothetical protein NPIL_94451 [Nephila pilipes]	diamond	444	43.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Nephilidae	Nephila	Nephila pilipes
28841930	28841930	PRJNA1245487_P_NODE_21768_length_243_cov_0.917647_g21430_i0	PRJNA1245487	21768	243	0.917647	2.22988221	Melanaphis sacchari	742174	Arthropoda	Arthropoda	106	3.4300000000000005e-27	NR	XP_025201385.1	742174	g21430	i0	67.1	2.93827160493827	79	24	97.5	1	240	4	81	157	XP_025201385.1 uncharacterized protein LOC112598932 [Melanaphis sacchari]	diamond	714	106	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Melanaphis	Melanaphis sacchari
29757563	29757563	PRJNA1245487_P_NODE_20971_length_246_cov_0.901734_g20633_i0	PRJNA1245487	20971	246	0.901734	2.21826564	Sitodiplosis mosellana	263140	Arthropoda	Arthropoda	112	9.03e-27	NR	XP_055300312.1	263140	g20633	i0	65.9	1	82	27	100	1	1	246	56	136	XP_055300312.1 importin-13 [Sitodiplosis mosellana]	diamond	246	112	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Cecidomyiidae	Sitodiplosis	Sitodiplosis mosellana
29820636	29820636	PRJNA1245487_P_NODE_16811_length_273_cov_1.045000_g16473_i0	PRJNA1245487	16811	273	1.045	2.85285	Penaeus vannamei	6689	Arthropoda	Arthropoda	43.5	0.0287	NR	ROT80995.1	6689	g16473	i0	58.6	0.637362637362637	58	19	59.3	2	264	103	246	302	ROT80995.1 hypothetical protein C7M84_000262 [Penaeus vannamei]	diamond	174	43.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Penaeidae	Penaeus	Penaeus vannamei
30768754	30768754	PRJNA1245487_P_NODE_20574_length_247_cov_1.781609_g20236_i0	PRJNA1245487	20574	247	1.781609	4.40057423	Oedothorax gibbosus	931172	Arthropoda	Arthropoda	48.1	4.32e-5	NR	KAG8155865.1	931172	g20236	i0	53.7	0.497975708502024	41	19	49.8	0	138	16	26	66	KAG8155865.1 hypothetical protein JTE90_008714 [Oedothorax gibbosus]	diamond	123	48.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Linyphiidae	Oedothorax	Oedothorax gibbosus
31906880	31906880	PRJNA1245487_P_NODE_16237_length_278_cov_2.521951_g15899_i0	PRJNA1245487	16237	278	2.521951	7.01102378	Oedothorax gibbosus	931172	Arthropoda	Arthropoda	44.7	0.0102	NR	KAG8171369.1	931172	g15899	i0	59.5	0.399280575539568	37	15	39.9	0	4	114	83	119	KAG8171369.1 hypothetical protein JTE90_007611 [Oedothorax gibbosus]	diamond	111	44.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Linyphiidae	Oedothorax	Oedothorax gibbosus
32445022	32445022	PRJNA1245487_P_NODE_19919_length_250_cov_0.881356_g19581_i0	PRJNA1245487	19919	250	0.881356	2.20339	Chironomus riparius	315576	Arthropoda	Arthropoda	162	1.7699999999999998e-45	NR	CAG9798748.1	315576	g19581	i0	95.2	0.996	83	4	99.6	0	250	2	207	289	CAG9798748.1 unnamed protein product [Chironomus riparius]	diamond	249	162	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Chironomus	Chironomus riparius

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