metadata: contig_metadata: 10 rows where bioproject = "PRJNA881257" and tax

10 rows where bioproject = "PRJNA881257" 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
2133911	2133911	PRJNA881257_P_NODE_11942_length_188_cov_1.122302_g11697_i0	PRJNA881257	11942	188	1.122302	2.10992776	Timema poppense	170557	Arthropoda	Arthropoda	52.8	0.016	NTclustered	gi\|1946153605\|emb\|OD012397.1\|	170557	g11697	i0	100	0.148936170212766	28	0	15	0	126	153	9148	9121	1_Tps_b3v08	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema poppense
5961863	5961863	PRJNA881257_P_NODE_5725_length_311_cov_1.324427_g5481_i0	PRJNA881257	5725	311	1.324427	4.11896797	Helicoverpa assulta	52344	Arthropoda	Arthropoda	52.8	0.029	NTclustered	gi\|2636206773\|emb\|OY979801.1\|	52344	g5481	i0	100	0.090032154340836	28	0	9	0	254	281	3484913	3484940	Helicoverpa assulta genome assembly, chromosome: 27	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Helicoverpa	Helicoverpa assulta
11062248	11062248	PRJNA881257_P_NODE_909_length_896_cov_2.794569_g738_i0	PRJNA881257	909	896	2.794569	25.03933824	Callophrys avis	700180	Arthropoda	Arthropoda	86.1	8.92e-12	NTclustered	gi\|2918384071\|emb\|OZ238072.1\|	700180	g738	i0	89.552	0.732142857142857	67	7	7	0	25	91	2089441	2089507	Callophrys avis genome assembly, chromosome: 5	blastn	656	86.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Lycaenidae	Callophrys	Callophrys avis
11062250	11062250	PRJNA881257_P_NODE_9149_length_224_cov_0.891429_g8904_i0	PRJNA881257	9149	224	0.891429	1.99680096	Agapeta hamana	1100904	Arthropoda	Arthropoda	54.7	0.006	NTclustered	gi\|2918369971\|emb\|OZ237863.1\|	1100904	g8904	i0	94.286	0.15625	35	2	16	0	53	87	16934804	16934838	Agapeta hamana genome assembly, chromosome: 4	blastn	35	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Tortricidae	Agapeta	Agapeta hamana
12337728	12337728	PRJNA881257_P_NODE_2250_length_570_cov_1.840691_g2014_i0	PRJNA881257	2250	570	1.840691	10.4919387	Timema californicum	61474	Arthropoda	Arthropoda	56.5	0.004	NTclustered	gi\|1965181363\|emb\|OE475415.1\|	61474	g2014	i0	90.909	0.0771929824561404	44	1	7	2	392	432	309	266	2_Tcm_b3v08	blastn	44	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema californicum
13612161	13612161	PRJNA881257_P_NODE_12951_length_179_cov_0.769231_g12706_i0	PRJNA881257	12951	179	0.769231	1.37692349	Glaucopsyche melanops	1002887	Arthropoda	Arthropoda	54.7	0.004	NTclustered	gi\|2919550840\|emb\|OZ238361.1\|	1002887	g12706	i0	100	0.162011173184358	29	0	16	0	22	50	14100601	14100629	Glaucopsyche melanops genome assembly, chromosome: 20	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Lycaenidae	Glaucopsyche	Glaucopsyche melanops
16161217	16161217	PRJNA881257_P_NODE_13273_length_175_cov_2.769841_g13028_i0	PRJNA881257	13273	175	2.769841	4.84722175	Timema douglasi	61478	Arthropoda	Arthropoda	67.6	5.27e-7	NTclustered	gi\|1936906359\|emb\|OA565832.1\|	61478	g13028	i0	91.837	13.0228571428571	49	2	27	2	71	117	143505	143553	1_Tdi_b3v08	blastn	2279	67.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema douglasi
16161281	16161281	PRJNA881257_P_NODE_18233_length_162_cov_0.920354_g17988_i0	PRJNA881257	18233	162	0.920354	1.49097348	Entomobrya marginata	1387110	Arthropoda	Arthropoda	300	4.36e-77	NTclustered	gi\|2522517248\|gb\|OR149203.1\|	1387110	g17988	i0	100	100.006172839506	162	0	100	0	1	162	849	688	Entomobrya marginata voucher CS400-Emar-01 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	16201	300	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Collembola	Entomobryomorpha	Entomobryidae	Entomobrya	Entomobrya marginata
16161294	16161294	PRJNA881257_P_NODE_6413_length_288_cov_1.087866_g6168_i0	PRJNA881257	6413	288	1.087866	3.13305408	Lucidina sp.	3143922	Arthropoda	Arthropoda	58.4	5.73e-4	NTclustered	gi\|2725684541\|gb\|OR402791.1\|	3143922	g6168	i0	97.143	0.121527777777778	35	0	12	1	169	203	11277	11244	Lucidina sp. mitochondrion, complete genome	blastn	35	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Lampyridae	Lucidina	Lucidina sp.
30497735	30497735	PRJNA881257_P_NODE_8613_length_234_cov_0.837838_g8368_i0	PRJNA881257	8613	234	0.837838	1.96054092	Sipha flava	143950	Arthropoda	Arthropoda	52.4	1.38e-5	NR	XP_025412285.1	143950	g8368	i0	33.3	1.58974358974359	63	42	80.8	0	13	201	555	617	XP_025412285.1 prosaposin isoform X1 [Sipha flava]	diamond	372	52.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Sipha	Sipha flava

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