metadata: contig_metadata: 20 rows where bioproject = "PRJNA798905" and tax

20 rows where bioproject = "PRJNA798905" 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
791794	791794	PRJNA798905_S_NODE_17041_length_355_cov_4.578014_g16592_i0	PRJNA798905	17041	355	4.578014	16.2519497	Ceutorhynchus obstrictus	307131	Arthropoda	Arthropoda	54.7	0.009	NTclustered	gi\|2918376608\|emb\|OZ238018.1\|	307131	g16592	i0	100	0.0816901408450704	29	0	8	0	211	239	322672	322700	Ceutorhynchus obstrictus genome assembly, chromosome: 9	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Curculionidae	Ceutorhynchus	Ceutorhynchus obstrictus
2067943	2067943	PRJNA798905_S_NODE_31562_length_268_cov_7.502564_g31113_i0	PRJNA798905	31562	268	7.502564	20.10687152	Daphnia pulex	6669	Arthropoda	Arthropoda	56.5	0.002	NTclustered	gi\|2192734159\|ref\|XM_046600325.1\|	6669	g31113	i0	94.595	0.552238805970149	37	0	13	2	220	254	8462	8498	PREDICTED: Daphnia pulex serine/arginine repetitive matrix protein 2-like (LOC124203620), transcript variant X3, mRNA	blastn	148	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia pulex
5895206	5895206	PRJNA798905_S_NODE_12305_length_403_cov_1.851515_g11856_i0	PRJNA798905	12305	403	1.851515	7.46160545	Tribolium castaneum	7070	Arthropoda	Arthropoda	52.8	0.039	NTclustered	gi\|2733082147\|emb\|OX466065.1\|	7070	g11856	i0	96.774	0.0769230769230769	31	1	8	0	263	293	3716727	3716697	Tribolium castaneum genome assembly, chromosome: LG5	blastn	31	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Tenebrionidae	Tribolium	Tribolium castaneum
8445495	8445495	PRJNA798905_S_NODE_45047_length_198_cov_5.056000_g44598_i0	PRJNA798905	45047	198	5.056	10.01088	Timema shepardi	629360	Arthropoda	Arthropoda	62.1	2.85e-5	NTclustered	gi\|1937823823\|emb\|OC000102.1\|	629360	g44598	i0	93.023	0.631313131313131	43	1	21	2	110	151	114173	114214	2_Tsi_b3v08	blastn	125	62.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema shepardi
11422078	11422078	PRJNA798905_S_NODE_29409_length_279_cov_1.266990_g28960_i0	PRJNA798905	29409	279	1.26699	3.5349021	root	1	Root_unresolved	Root_unresolved	475	1.2899999999999997e-129	NTclustered	gi\|1962580377\|emb\|OC914882.1\|	334625	g28960	i0	99.24	6.59856630824373	263	2	94	0	17	279	48913	48651	Oppiella nova	blastn	1841	475	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppiella	Oppiella nova
13545561	13545561	PRJNA798905_S_NODE_25291_length_300_cov_2.035242_g24842_i0	PRJNA798905	25291	300	2.035242	6.105726	Medioppia subpectinata	1979941	Arthropoda	Arthropoda	60.2	1.67e-4	NTclustered	gi\|1962536607\|emb\|OC867504.1\|	1979941	g24842	i0	100	0.293333333333333	32	0	11	0	211	242	744	713	Medioppia subpectinata	blastn	88	60.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Medioppia	Medioppia subpectinata
16094663	16094663	PRJNA798905_S_NODE_29873_length_276_cov_5.270936_g29424_i0	PRJNA798905	29873	276	5.270936	14.54778336	Timema genevievae	629358	Arthropoda	Arthropoda	52.8	0.025	NTclustered	gi\|1965352161\|emb\|OE839429.1\|	629358	g29424	i0	100	0.101449275362319	28	0	10	0	165	192	207360	207387	5_Tge_b3v08	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema genevievae
16094975	16094975	PRJNA798905_S_NODE_45093_length_197_cov_14.024194_g44644_i0	PRJNA798905	45093	197	14.024194	27.62766218	Medioppia subpectinata	1979941	Arthropoda	Arthropoda	52.8	0.017	NTclustered	gi\|1964708817\|emb\|OC858617.1\|	1979941	g44644	i0	100	0.142131979695431	28	0	14	0	100	127	5067	5040	Medioppia subpectinata	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Medioppia	Medioppia subpectinata
16520965	16520965	PRJNA798905_S_NODE_13913_length_384_cov_7.588424_g13464_i0	PRJNA798905	13913	384	7.588424	29.13954816	Heliconius	33416	Arthropoda	Arthropoda	54.7	0.01	NTclustered	gi\|193082852\|emb\|CU914733.2\|	33419	g13464	i0	100	0.2265625	29	0	8	0	293	321	27219	27247	H.numata DNA sequence from clone AEHN-38C19, complete sequence	blastn	87	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Nymphalidae	Heliconius	Heliconius numata
17370484	17370484	PRJNA798905_S_NODE_28954_length_281_cov_1.846154_g28505_i0	PRJNA798905	28954	281	1.846154	5.18769274	Bemisia tabaci	7038	Arthropoda	Arthropoda	56.5	0.002	NTclustered	gi\|1101347013\|ref\|XM_019043783.1\|	7038	g28505	i0	96.97	0.117437722419929	33	1	12	0	175	207	5411	5379	PREDICTED: Bemisia tabaci NACHT domain- and WD repeat-containing protein 1 (LOC109031926), mRNA	blastn	33	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aleyrodidae	Bemisia	Bemisia tabaci
18643908	18643908	PRJNA798905_S_NODE_43515_length_219_cov_6.349315_g43066_i0	PRJNA798905	43515	219	6.349315	13.90499985	Aedes albopictus	7160	Arthropoda	Arthropoda	58.4	4.16e-4	NTclustered	gi\|2669937771\|ref\|XM_062844686.1\|	7160	g43066	i0	97.059	2.60730593607306	34	1	16	0	24	57	1880	1913	PREDICTED: Aedes albopictus LIM domain transcription factor LMO4.1 (LOC109401927), transcript variant X4, mRNA	blastn	571	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Aedes	Aedes albopictus
19919224	19919224	PRJNA798905_S_NODE_44336_length_208_cov_3.444444_g43887_i0	PRJNA798905	44336	208	3.444444	7.16444352	Chelonus insularis	460826	Arthropoda	Arthropoda	52.8	0.018	NTclustered	gi\|1860503868\|ref\|XM_035092635.1\|	460826	g43887	i0	100	0.403846153846154	28	0	13	0	151	178	3426	3453	PREDICTED: Chelonus insularis GTP-binding protein 2 (LOC118072621), transcript variant X2, mRNA	blastn	84	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Braconidae	Chelonus	Chelonus insularis
20344606	20344606	PRJNA798905_S_NODE_24236_length_306_cov_1.742489_g23787_i0	PRJNA798905	24236	306	1.742489	5.33201634	root	1	Root_unresolved	Root_unresolved	566	8.239999999999998e-157	NTclustered	gi\|1962580312\|emb\|OC914878.1\|	334625	g23787	i0	100	18.4183006535948	306	0	100	0	1	306	22202	22507	Oppiella nova	blastn	5636	566	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppiella	Oppiella nova
21194857	21194857	PRJNA798905_S_NODE_43357_length_221_cov_10.168919_g42908_i0	PRJNA798905	43357	221	10.168919	22.47331099	Timema poppense	170557	Arthropoda	Arthropoda	52.8	0.02	NTclustered	gi\|1946153605\|emb\|OD012397.1\|	170557	g42908	i0	100	0.393665158371041	28	0	13	0	67	94	9148	9121	1_Tps_b3v08	blastn	87	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema poppense
21620334	21620334	PRJNA798905_S_NODE_31977_length_266_cov_5.772021_g31528_i0	PRJNA798905	31977	266	5.772021	15.35357586	root	1	Root_unresolved	Root_unresolved	71.3	6.72e-8	NTclustered	gi\|2918386062\|emb\|OZ238105.1\|	346795	g31528	i0	97.561	7.35714285714286	41	1	15	0	226	266	46471003	46470963	Longitarsus dorsalis genome assembly, chromosome: 12	blastn	1957	71.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Chrysomelidae	Longitarsus	Longitarsus dorsalis
23744785	23744785	PRJNA798905_S_NODE_27739_length_287_cov_2.042056_g27290_i0	PRJNA798905	27739	287	2.042056	5.86070072	Satyrium ilicis	876074	Arthropoda	Arthropoda	52.8	0.027	NTclustered	gi\|2918386079\|emb\|OZ238116.1\|	876074	g27290	i0	100	0.0975609756097561	28	0	10	0	188	215	9620616	9620589	Satyrium ilicis genome assembly, chromosome: 7	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Lycaenidae	Satyrium	Satyrium ilicis
23745133	23745133	PRJNA798905_S_NODE_43659_length_217_cov_7.472222_g43210_i0	PRJNA798905	43659	217	7.472222	16.21472174	Medioppia subpectinata	1979941	Arthropoda	Arthropoda	54.7	0.005	NTclustered	gi\|1964668523\|emb\|OC856572.1\|	1979941	g43210	i0	100	0.419354838709677	29	0	13	0	76	104	5755	5783	Medioppia subpectinata	blastn	91	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Medioppia	Medioppia subpectinata
23745308	23745308	PRJNA798905_S_NODE_9539_length_444_cov_4.350404_g9090_i0	PRJNA798905	9539	444	4.350404	19.31579376	Dinoponera quadriceps	609295	Arthropoda	Arthropoda	58.4	0.001	NTclustered	gi\|951563086\|ref\|XM_014624970.1\|	609295	g9090	i0	92.683	0.184684684684685	41	2	9	1	129	168	5982	6022	PREDICTED: Dinoponera quadriceps uncharacterized LOC106747452 (LOC106747452), transcript variant X1, mRNA	blastn	82	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Formicidae	Dinoponera	Dinoponera quadriceps
27749217	27749217	PRJNA798905_S_NODE_3244_length_743_cov_613.671642_g2826_i0	PRJNA798905	3244	743	613.671642	4559.58030006	Bactrocera tryoni	59916	Arthropoda	Arthropoda	62.4	2.23e-7	NR	XP_039967484.1	59916	g2826	i0	65.9	0.177658142664872	44	15	17.8	0	372	503	1	44	XP_039967484.1 DNA ligase-like, partial [Bactrocera tryoni]	diamond	132	62.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Tephritidae	Bactrocera	Bactrocera tryoni
30117034	30117034	PRJNA798905_S_NODE_40912_length_236_cov_2.993865_g40463_i0	PRJNA798905	40912	236	2.993865	7.0655214	Trichonephila clavata	2740835	Arthropoda	Arthropoda	45.1	0.00443	NR	GFQ94560.1	2740835	g40463	i0	46.3	0.686440677966102	54	26	66.1	2	60	215	153	205	GFQ94560.1 helitron_like_N domain-containing protein [Trichonephila clavata]	diamond	162	45.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Nephilidae	Trichonephila	Trichonephila clavata

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