metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA556842" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA556842" and tax_kingdom = "Metazoa"

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
3072721	3072721	PRJNA556842_P_NODE_15563_length_168_cov_1.145038_g15058_i0	PRJNA556842	15563	168	1.145038	1.92366384	Zeugodacus cucurbitae	28588	Arthropoda	Arthropoda	52.8	0.014	NTclustered	gi\|2460017187\|ref\|XM_011186644.3\|	28588	g15058	i0	100	0.166666666666667	28	0	17	0	10	37	6951	6978	PREDICTED: Zeugodacus cucurbitae IDLSRF-like peptide (LOC105213665), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Tephritidae	Zeugodacus	Zeugodacus cucurbitae
6227810	6227810	PRJNA556842_P_NODE_3125_length_554_cov_16.705996_g2661_i0	PRJNA556842	3125	554	16.705996	92.55121784	Staphylinidae	29026	Arthropoda	Arthropoda	209	3.06e-49	NTclustered	gi\|693464834\|gb\|KJ844884.1\|	1541375	g2661	i0	74.582	12.956678700361	598	94	99	42	4	554	922	336	Pselaptrichus sp. DDM1181 28S ribosomal RNA gene, partial sequence	blastn	7178	209	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Staphylinidae	Pselaptrichus	Pselaptrichus sp. DDM1181
10052581	10052581	PRJNA556842_P_NODE_16248_length_162_cov_1.696000_g15743_i0	PRJNA556842	16248	162	1.696	2.74752	Insecta	50557	Arthropoda	Arthropoda	182	1.6499999999999996e-41	NTclustered	gi\|2733082149\|emb\|OX466067.1\|	7070	g15743	i0	93.496	68.7839506172839	123	7	78	1	40	162	1520426	1520547	Tribolium castaneum genome assembly, chromosome: LG7	blastn	11143	182	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Tenebrionidae	Tribolium	Tribolium castaneum
12603117	12603117	PRJNA556842_P_NODE_3430_length_521_cov_16.450413_g2951_i0	PRJNA556842	3430	521	16.450413	85.70665173	Insecta	50557	Arthropoda	Arthropoda	388	3.4299999999999996e-103	NTclustered	gi\|2209605878\|ref\|XR_006974651.1\|	7009	g2951	i0	96.203	67.6545105566219	237	9	69	0	1	237	3573	3337	PREDICTED: Schistocerca americana large subunit ribosomal RNA (LOC124584255), rRNA	blastn	35248	388	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Orthoptera	Acrididae	Schistocerca	Schistocerca americana
14550815	14550815	PRJNA556842_P_NODE_10992_length_224_cov_1.320856_g10487_i0	PRJNA556842	10992	224	1.320856	2.95871744	Erpetoichthys calabaricus	27687	Chordata	Chordata	176	1.13e-39	NTclustered	gi\|2327557302\|ref\|XM_028813649.2\|	27687	g10487	i0	81.614	25.1383928571429	223	31	96	8	1	215	3145	3365	PREDICTED: Erpetoichthys calabaricus ras homolog gene family, member Aa (rhoaa), mRNA	blastn	5631	176	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus
15824553	15824553	PRJNA556842_P_NODE_5293_length_394_cov_2.008403_g4794_i0	PRJNA556842	5293	394	2.008403	7.91310782	Pseudoterpna coronillaria	1007376	Arthropoda	Arthropoda	56.5	0.003	NTclustered	gi\|2918369770\|emb\|OZ237837.1\|	1007376	g4794	i0	92.5	0.101522842639594	40	2	10	1	2	41	5854551	5854513	Pseudoterpna coronillaria genome assembly, chromosome: 12	blastn	40	56.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Geometridae	Pseudoterpna	Pseudoterpna coronillaria
19648136	19648136	PRJNA556842_P_NODE_15096_length_172_cov_1.118519_g14591_i0	PRJNA556842	15096	172	1.118519	1.92385268	Anthonomus grandis	7044	Arthropoda	Arthropoda	307	2.79e-79	NTclustered	gi\|2293499837\|ref\|XR_007665257.1\|	2921223	g14591	i0	98.837	105	172	2	100	0	1	172	2145	1974	PREDICTED: Anthonomus grandis grandis large subunit ribosomal RNA (LOC126749694), rRNA	blastn	18060	307	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Curculionidae	Anthonomus	Anthonomus grandis
23474214	23474214	PRJNA556842_P_NODE_11639_length_212_cov_6.822857_g11134_i0	PRJNA556842	11639	212	6.822857	14.46445684	Liposcelidae sp. B1763	322491	Arthropoda	Arthropoda	392	9.67e-105	NTclustered	gi\|62529117\|gb\|AY900135.1\|	322491	g11134	i0	100	99.0188679245283	212	0	100	0	1	212	1833	1622	Liposcelidae sp. B1763 18S small subunit ribosomal RNA gene, partial sequence	blastn	20992	392	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Psocodea	Liposcelididae		Liposcelidae sp. B1763
23474226	23474226	PRJNA556842_P_NODE_3619_length_503_cov_6.375536_g3135_i0	PRJNA556842	3619	503	6.375536	32.06894608	Schistocerca americana	7009	Arthropoda	Arthropoda	172	3.62e-38	NTclustered	gi\|2209603692\|ref\|XR_006972637.1\|	7009	g3135	i0	84.571	129.699801192843	175	25	35	2	1	174	3725	3898	PREDICTED: Schistocerca americana large subunit ribosomal RNA (LOC124577385), rRNA	blastn	65239	172	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Orthoptera	Acrididae	Schistocerca	Schistocerca americana
25350511	25350511	PRJNA556842_P_NODE_16440_length_160_cov_3.894309_g15935_i0	PRJNA556842	16440	160	3.894309	6.2308944	Chordata	7711	Chordata	Chordata	52.8	0.013	NTclustered	gi\|2721460824\|emb\|HG999682.4\|	9103	g15935	i0	100	0.35	28	0	18	0	74	101	32418365	32418392	Meleagris gallopavo genome assembly, chromosome: 3	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Galliformes	Phasianidae	Meleagris	Meleagris gallopavo
25350514	25350514	PRJNA556842_P_NODE_17180_length_155_cov_1.966102_g16675_i0	PRJNA556842	17180	155	1.966102	3.0474581	Metazoa	33208	Mollusca	Mollusca	71.3	3.52e-8	NTclustered	gi\|2912981848\|dbj\|AP039587.1\|	145626	g16675	i0	93.617	25.2774193548387	47	3	30	0	1	47	18004735	18004781	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence	blastn	3918	71.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris

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