metadata: contig_metadata: 15 rows where bioproject = "PRJNA397733" and tax

15 rows where bioproject = "PRJNA397733" 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
4239182	4239182	PRJNA397733_S_NODE_12724_length_171_cov_2.014085_g12636_i0	PRJNA397733	12724	171	2.014085	3.44408535	Timema cristinae	61476	Arthropoda	Arthropoda	58.4	3.08e-4	NTclustered	gi\|1947043246\|emb\|OC446893.1\|	61476	g12636	i0	97.059	1.29239766081871	34	1	20	0	120	153	221	254	3_Tce_b3v08	blastn	221	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema cristinae
10616025	10616025	PRJNA397733_S_NODE_1149_length_629_cov_12.186667_g1084_i0	PRJNA397733	1149	629	12.186667	76.65413543	Demodex environmental sample	1856688	Arthropoda	Arthropoda	920	0	NTclustered	gi\|1040064834\|gb\|KU363928.1\|	1856688	g1084	i0	94.5	88.9268680445151	600	28	95	5	26	622	598	1	Demodex environmental sample clone K-7-14-37 28S ribosomal RNA gene, partial sequence	blastn	55935	920	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Demodicidae	Demodex	Demodex environmental sample
20813736	20813736	PRJNA397733_S_NODE_16757_length_151_cov_2.368852_g16669_i0	PRJNA397733	16757	151	2.368852	3.57696652	Monomorium pharaonis	307658	Arthropoda	Arthropoda	56.5	0.001	NTclustered	gi\|1911066375\|ref\|XM_036283671.1\|	307658	g16669	i0	100	0.794701986754967	30	0	20	0	101	130	3053	3082	PREDICTED: Monomorium pharaonis chondroitin sulfate proteoglycan 4 (LOC105840134), transcript variant X4, mRNA	blastn	120	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Formicidae	Monomorium	Monomorium pharaonis
27169957	27169957	PRJNA397733_S_NODE_9222_length_198_cov_4.846154_g9134_i0	PRJNA397733	9222	198	4.846154	9.59538492	Pseudolycoriella hygida	35572	Arthropoda	Arthropoda	95.9	3.57e-21	NR	KAJ6643114.1	35572	g9134	i0	89.8	11.4242424242424	49	5	74.2	0	50	196	72	120	KAJ6643114.1 Elongation factor 1-alpha 1, partial [Pseudolycoriella hygida]	diamond	2262	95.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Sciaridae	Pseudolycoriella	Pseudolycoriella hygida
27896518	27896518	PRJNA397733_S_NODE_2365_length_406_cov_3.599469_g2277_i0	PRJNA397733	2365	406	3.599469	14.61384414	Pararge aegeria aegeria	348720	Arthropoda	Arthropoda	69.7	2.71e-12	NR	CAH2218350.1	348720	g2277	i0	66.7	0.399014778325123	54	10	36.2	2	160	14	6	56	CAH2218350.1 jg429 [Pararge aegeria aegeria]	diamond	162	69.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Nymphalidae	Pararge	Pararge aegeria
28496670	28496670	PRJNA397733_S_NODE_11927_length_176_cov_2.455782_g11839_i0	PRJNA397733	11927	176	2.455782	4.32217632	Operophtera brumata	104452	Arthropoda	Arthropoda	103	2.5299999999999998e-24	NR	KOB66908.1	104452	g11839	i0	82.8	0.988636363636364	58	10	98.9	0	2	175	6	63	KOB66908.1 Slimb, partial [Operophtera brumata]	diamond	174	103	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Geometridae	Operophtera	Operophtera brumata
29302621	29302621	PRJNA397733_S_NODE_12969_length_169_cov_2.571429_g12881_i0	PRJNA397733	12969	169	2.571429	4.34571501	Metazoa	33208	Arthropoda	Arthropoda	111	5.25e-27	NR	XP_013777835.1	6850	g12881	i0	98.2	81.5147928994083	56	1	99.4	0	2	169	55	110	XP_013777835.1 eukaryotic peptide chain release factor subunit 1-like [Limulus polyphemus]	diamond	13776	112	0.991071428571429	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Merostomata	Xiphosura	Limulidae	Limulus	Limulus polyphemus
29523677	29523677	PRJNA397733_S_NODE_13410_length_167_cov_1.644928_g13322_i0	PRJNA397733	13410	167	1.644928	2.74702976	root	1	Root_unresolved	Root_unresolved	124	2.5299999999999993e-31	NR	XP_013778015.1	6850	g13322	i0	98.2	63.2335329341317	55	1	98.8	0	165	1	242	296	XP_013778015.1 LOW QUALITY PROTEIN: splicing factor 3B subunit 3-like [Limulus polyphemus]	diamond	10560	125	0.992	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Merostomata	Xiphosura	Limulidae	Limulus	Limulus polyphemus
30723982	30723982	PRJNA397733_S_NODE_11834_length_176_cov_5.047619_g11746_i0	PRJNA397733	11834	176	5.047619	8.88380944	Hymenoptera	7399	Arthropoda	Arthropoda	58.9	7.97e-9	NR	XP_014210477.1	29053	g11746	i0	90.3	7.92613636363636	31	3	52.8	0	24	116	144	174	XP_014210477.1 caltractin [Copidosoma floridanum]	diamond	1395	58.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Encyrtidae	Copidosoma	Copidosoma floridanum
30897050	30897050	PRJNA397733_S_NODE_16994_length_150_cov_2.710744_g16906_i0	PRJNA397733	16994	150	2.710744	4.066116	Iphiclides podalirius	110791	Arthropoda	Arthropoda	104	1.44e-24	NR	CAH2042624.1	110791	g16906	i0	98	109.76	49	1	98	0	148	2	351	399	CAH2042624.1 unnamed protein product, partial [Iphiclides podalirius]	diamond	16464	105	0.990476190476191	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Papilionidae	Iphiclides	Iphiclides podalirius
31117777	31117777	PRJNA397733_S_NODE_7855_length_215_cov_2.553763_g7767_i0	PRJNA397733	7855	215	2.553763	5.49059045	Rhipicephalus microplus	6941	Arthropoda	Arthropoda	122	2.4999999999999998e-31	NR	KAL3255901.1	6941	g7767	i0	87.1	1.96744186046512	70	9	97.7	0	214	5	170	239	KAL3255901.1 hypothetical protein MRX96_046638 [Rhipicephalus microplus]	diamond	423	122	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Ixodidae	Rhipicephalus	Rhipicephalus microplus
31134441	31134441	PRJNA397733_S_NODE_10375_length_187_cov_3.113924_g10287_i0	PRJNA397733	10375	187	3.113924	5.82303788	Metazoa	33208	Arthropoda	Arthropoda	120	7.7e-30	NR	AAR28532.1	6728	g10287	i0	98.4	1056.06417112299	62	1	99.5	0	2	187	844	905	AAR28532.1 plasma membrane calcium ATPase PMCA3 [Procambarus clarkii]	diamond	197484	121	0.991735537190083	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Cambaridae	Procambarus	Procambarus clarkii
31212386	31212386	PRJNA397733_S_NODE_5475_length_259_cov_2.904348_g5387_i0	PRJNA397733	5475	259	2.904348	7.52226132	Portunus trituberculatus	210409	Arthropoda	Arthropoda	134	3.65e-37	NR	MPC24561.1	210409	g5387	i0	70.6	3.9034749034749	85	25	98.5	0	257	3	86	170	MPC24561.1 Coatomer subunit beta' [Portunus trituberculatus]	diamond	1011	134	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Portunidae	Portunus	Portunus trituberculatus
31672312	31672312	PRJNA397733_S_NODE_8917_length_201_cov_5.819767_g8829_i0	PRJNA397733	8917	201	5.819767	11.69773167	Metazoa	33208	Arthropoda	Arthropoda	139	7.18e-37	NR	TRY63579.1	6832	g8829	i0	93.9	285.671641791045	66	4	98.5	0	2	199	21	86	TRY63579.1 hypothetical protein TCAL_10343 [Tigriopus californicus]	diamond	57420	140	0.992857142857143	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Harpacticoida	Harpacticidae	Tigriopus	Tigriopus californicus
32715737	32715737	PRJNA397733_S_NODE_14840_length_159_cov_2.992308_g14752_i0	PRJNA397733	14840	159	2.992308	4.75776972	Metazoa	33208	Arthropoda	Arthropoda	112	1.01e-29	NR	XP_046451926.1	6669	g14752	i0	100	112.830188679245	52	0	98.1	0	158	3	104	155	XP_046451926.1 NEDD8-conjugating enzyme Ubc12 [Daphnia pulex]	diamond	17940	112	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia pulex

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