metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA401346" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA401346" 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
414255	414255	PRJNA401346_P_NODE_6861_length_207_cov_0.876712_g6840_i0	PRJNA401346	6861	207	0.876712	1.81479384	Artemia franciscana	6661	Arthropoda	Arthropoda	268	1.6499999999999994e-67	NTclustered	gi\|2743059734\|ref\|XM_065724477.1\|	6661	g6840	i0	94.767	1.66183574879227	172	9	83	0	13	184	775	946	PREDICTED: Artemia franciscana small ribosomal subunit protein uS5 (LOC136040257), mRNA	blastn	344	268	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
2965038	2965038	PRJNA401346_P_NODE_6283_length_209_cov_0.864865_g6262_i0	PRJNA401346	6283	209	0.864865	1.80756785	Artemia franciscana	6661	Arthropoda	Arthropoda	331	2.1e-86	NTclustered	gi\|2743044901\|ref\|XM_065718670.1\|	6661	g6262	i0	95.215	2	209	10	100	0	1	209	2380	2172	PREDICTED: Artemia franciscana putative mediator of RNA polymerase II transcription subunit 12 (LOC136036434), transcript variant X2, mRNA	blastn	418	331	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
11284382	11284382	PRJNA401346_P_NODE_3689_length_273_cov_1.028302_g3668_i0	PRJNA401346	3689	273	1.028302	2.80726446	Drosophila	7215	Arthropoda	Arthropoda	303	6.27e-78	NTclustered	gi\|2046254948\|ref\|XM_017213696.2\|	29029	g3668	i0	87.938	91.8864468864469	257	31	94	0	4	260	371	115	PREDICTED: Drosophila eugracilis elongation factor 1-alpha 1 (LOC108106543), mRNA	blastn	25085	303	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila eugracilis
11892977	11892977	PRJNA401346_P_NODE_1850_length_360_cov_1.561873_g1829_i0	PRJNA401346	1850	360	1.561873	5.6227428	Hydrometra stagnorum	446445	Arthropoda	Arthropoda	501	2.82e-137	NTclustered	gi\|1131051030\|gb\|KX821841.1\|	446445	g1829	i0	91.576	50.1555555555556	368	23	100	4	1	360	1425	1058	Hydrometra stagnorum 28S ribosomal RNA gene, partial sequence	blastn	18056	501	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Hydrometridae	Hydrometra	Hydrometra stagnorum
11893145	11893145	PRJNA401346_P_NODE_7790_length_204_cov_0.895105_g7769_i0	PRJNA401346	7790	204	0.895105	1.8260142	Artemia franciscana	6661	Arthropoda	Arthropoda	350	5.64e-92	NTclustered	gi\|2743057729\|ref\|XM_065728959.1\|	6661	g7769	i0	97.549	6.68137254901961	204	5	100	0	1	204	140	343	PREDICTED: Artemia franciscana small ribosomal subunit protein eS4 (LOC136043915), mRNA	blastn	1363	350	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
15716910	15716910	PRJNA401346_P_NODE_3273_length_287_cov_0.986726_g3252_i0	PRJNA401346	3273	287	0.986726	2.83190362	Grylloblattella sp. SDS12-059A	2497025	Arthropoda	Arthropoda	158	5.47e-34	NTclustered	gi\|1594521178\|gb\|MH945332.1\|	2497025	g3252	i0	79.73	5.63763066202091	222	41	77	4	1	220	29	248	Grylloblattella sp. SDS12-059A histone H4-like gene, partial sequence	blastn	1618	158	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Grylloblattodea	Grylloblattidae	Grylloblattella	Grylloblattella sp. SDS12-059A
16383490	16383490	PRJNA401346_P_NODE_5133_length_235_cov_1.413793_g5112_i0	PRJNA401346	5133	235	1.413793	3.32241355	root	1	Root_unresolved	Root_unresolved	427	3e-115	NTclustered	gi\|1962580707\|emb\|OC914906.1\|	334625	g5112	i0	99.573	62.3531914893617	234	1	99	0	2	235	10787	10554	Oppiella nova	blastn	14653	427	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppiella	Oppiella nova
22758048	22758048	PRJNA401346_P_NODE_798_length_515_cov_3.502203_g777_i0	PRJNA401346	798	515	3.502203	18.03634545	Drosophila	7215	Arthropoda	Arthropoda	333	1.61e-86	NTclustered	gi\|1037114479\|ref\|XM_017277711.1\|	30023	g777	i0	82.383	69.9728155339806	386	64	75	2	48	433	129	510	PREDICTED: Drosophila elegans 40S ribosomal protein S23 (LOC108149836), mRNA	blastn	36036	333	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila elegans
23366341	23366341	PRJNA401346_P_NODE_5619_length_223_cov_1.382716_g5598_i0	PRJNA401346	5619	223	1.382716	3.08345668	Drosophila nasuta	42062	Arthropoda	Arthropoda	60.2	1.18e-4	NTclustered	gi\|2617351841\|ref\|XM_060807130.1\|	42062	g5598	i0	94.737	1.152466367713	38	2	17	0	134	171	3031	2994	PREDICTED: Drosophila nasuta hormone receptor 4 (LOC132796093), mRNA	blastn	257	60.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila nasuta

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