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

10 rows where bioproject = "PRJNA397065" 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
4239071	4239071	PRJNA397065_S_NODE_19924_length_150_cov_1.942149_g19674_i0	PRJNA397065	19924	150	1.942149	2.9132235	Subhimalus nigrifacialis	2962722	Arthropoda	Arthropoda	278	1.85e-70	NTclustered	gi\|2266173005\|gb\|ON944133.1\|	2962722	g19674	i0	100	77.7333333333333	150	0	100	0	1	150	89	238	Subhimalus nigrifacialis voucher 25.2 large subunit ribosomal RNA gene, partial sequence	blastn	11660	278	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Cicadellidae	Subhimalus	Subhimalus nigrifacialis
5515720	5515720	PRJNA397065_S_NODE_18585_length_158_cov_3.666667_g18335_i0	PRJNA397065	18585	158	3.666667	5.79333386	Psychoda cinerea	7202	Arthropoda	Arthropoda	224	2.62e-54	NTclustered	gi\|2190489\|emb\|X93404.1\|	7202	g18335	i0	91.667	78.8227848101266	168	4	100	8	1	158	44	211	P.cinerea 28S rRNA gene, expansion segment D7	blastn	12454	224	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Psychodidae	Psychoda	Psychoda cinerea
7457321	7457321	PRJNA397065_S_NODE_15486_length_183_cov_1.519481_g15236_i0	PRJNA397065	15486	183	1.519481	2.78065023	Chironomidae	7149	Arthropoda	Arthropoda	333	4.97e-87	NTclustered	gi\|2486656239\|gb\|OQ819027.1\|	7152	g15236	i0	99.454	100	183	1	100	0	1	183	3182	3364	Chironomus sp. isolate OVO4158 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence	blastn	18300	333	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Chironomus	Chironomus sp.
16381948	16381948	PRJNA397065_S_NODE_18413_length_159_cov_4.915385_g18163_i0	PRJNA397065	18413	159	4.915385	7.81546215	Psychodidae	7197	Arthropoda	Arthropoda	209	7.38e-50	NTclustered	gi\|2582855428\|ref\|XR_009468295.1\|	94469	g18163	i0	96.8	76.3522012578616	125	4	79	0	1	125	2577	2453	PREDICTED: Phlebotomus argentipes large subunit ribosomal RNA (LOC132258975), rRNA	blastn	12140	211	0.990521327014218	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Psychodidae	Phlebotomus	Phlebotomus argentipes
21481104	21481104	PRJNA397065_S_NODE_16057_length_177_cov_4.412162_g15807_i0	PRJNA397065	16057	177	4.412162	7.80952674	Psychodidae	7197	Arthropoda	Arthropoda	172	1.0999999999999999e-38	NTclustered	gi\|1128619224\|gb\|KX356025.1\|	252620	g15807	i0	95.37	63.7627118644068	108	5	61	0	69	176	1432	1539	Nyssomyia flaviscutellata 28S ribosomal RNA gene, partial sequence	blastn	11286	172	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Psychodidae	Nyssomyia	Nyssomyia flaviscutellata
22088494	22088494	PRJNA397065_S_NODE_15018_length_187_cov_2.753165_g14768_i0	PRJNA397065	15018	187	2.753165	5.14841855	Timema shepardi	629360	Arthropoda	Arthropoda	56.5	0.001	NTclustered	gi\|1937882981\|emb\|OC005343.1\|	629360	g14768	i0	100	0.315508021390374	30	0	16	0	100	129	10869	10840	2_Tsi_b3v08	blastn	59	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Phasmatodea	Timematidae	Timema	Timema shepardi
22088644	22088644	PRJNA397065_S_NODE_9858_length_262_cov_2.888412_g9608_i0	PRJNA397065	9858	262	2.888412	7.56763944	Psychoda cinerea	7202	Arthropoda	Arthropoda	407	4.43e-109	NTclustered	gi\|2190490\|emb\|X93386.1\|	7202	g9608	i0	94.677	100.797709923664	263	13	100	1	1	262	281	19	P.cinerea 28S rRNA gene, expansion segment D1	blastn	26409	407	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Psychodidae	Psychoda	Psychoda cinerea
24638488	24638488	PRJNA397065_S_NODE_6580_length_361_cov_4.593373_g6331_i0	PRJNA397065	6580	361	4.593373	16.58207653	Clogmia albipunctata	85120	Arthropoda	Arthropoda	342	1.8099999999999994e-89	NTclustered	gi\|202070898\|gb\|FJ040537.1\|	85120	g6331	i0	84.551	61.8365650969529	356	43	98	11	3	355	3569	3915	Clogmia albipunctata 28S ribosomal RNA gene, partial sequence	blastn	22323	342	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Psychodidae	Clogmia	Clogmia albipunctata
25305477	25305477	PRJNA397065_S_NODE_13340_length_205_cov_4.767045_g13090_i0	PRJNA397065	13340	205	4.767045	9.77244225	Insecta	50557	Arthropoda	Arthropoda	379	7.229999999999999e-101	NTclustered	gi\|202070898\|gb\|FJ040537.1\|	85120	g13090	i0	100	99.9756097560976	205	0	100	0	1	205	3367	3163	Clogmia albipunctata 28S ribosomal RNA gene, partial sequence	blastn	20495	379	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Psychodidae	Clogmia	Clogmia albipunctata
28875419	28875419	PRJNA397065_S_NODE_19008_length_155_cov_8.325397_g18758_i0	PRJNA397065	19008	155	8.325397	12.90436535	Araneus ventricosus	182803	Arthropoda	Arthropoda	41.6	0.0289	NR	GBM49182.1	182803	g18758	i0	42.2	0.870967741935484	45	26	87.1	0	4	138	76	120	GBM49182.1 hypothetical protein AVEN_2876-1 [Araneus ventricosus]	diamond	135	41.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Araneidae	Araneus	Araneus ventricosus

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