metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA290839" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA290839" 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
6750611	6750611	PRJNA290839_P_NODE_766_length_292_cov_1.036530_g745_i0	PRJNA290839	766	292	1.03653	3.0266676	Drosophila busckii	30019	Arthropoda	Arthropoda	54.7	0.008	NTclustered	gi\|1829323352\|ref\|XM_017991740.2\|	30019	g745	i0	96.97	0.339041095890411	33	0	11	1	165	197	321	352	PREDICTED: Drosophila busckii shootin-1 (LOC108603182), transcript variant X1, mRNA	blastn	99	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Drosophilidae	Drosophila	Drosophila busckii
9987627	9987627	PRJNA290839_P_NODE_1188_length_250_cov_0.870056_g1167_i0	PRJNA290839	1188	250	0.870056	2.17514	Diptera	7147	Arthropoda	Arthropoda	460	3.17e-125	NTclustered	gi\|422898859\|gb\|JQ613602.1\|	335710	g1167	i0	100	99.6	249	0	99	0	2	250	1020	772	Bradysia difformis voucher 122 18S ribosomal RNA gene, partial sequence	blastn	24900	460	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Sciaridae	Bradysia	Bradysia impatiens
15675632	15675632	PRJNA290839_P_NODE_1653_length_242_cov_0.899408_g1632_i0	PRJNA290839	1653	242	0.899408	2.17656736	Phenacoccus solenopsis	483260	Arthropoda	Arthropoda	161	3.47e-35	NTclustered	gi\|675275138\|gb\|KJ909511.1\|	483260	g1632	i0	81.407	42.5247933884297	199	35	82	2	1	198	498	301	Phenacoccus solenopsis putative tubulin beta-1 chain mRNA, partial cds	blastn	10291	161	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Pseudococcidae	Phenacoccus	Phenacoccus solenopsis
16950292	16950292	PRJNA290839_P_NODE_1554_length_243_cov_0.917647_g1533_i0	PRJNA290839	1554	243	0.917647	2.22988221	Vespula pensylvanica	30213	Arthropoda	Arthropoda	191	4.45e-44	NTclustered	gi\|2098661466\|ref\|XM_043811691.1\|	30213	g1533	i0	83.744	97.1481481481482	203	31	83	2	42	243	339	138	PREDICTED: Vespula pensylvanica ubiquitin-40S ribosomal protein S27a (LOC122628880), mRNA	blastn	23607	191	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Vespidae	Vespula	Vespula pensylvanica
16950300	16950300	PRJNA290839_P_NODE_654_length_317_cov_1.036885_g633_i0	PRJNA290839	654	317	1.036885	3.28692545	Papilio polytes	76194	Arthropoda	Arthropoda	431	3.26e-116	NTclustered	gi\|389615034\|dbj\|AK405121.1\|	76194	g633	i0	99.574	0.741324921135647	235	1	74	0	1	235	235	1	Papilio polytes mRNA for ribosomal protein L10Ab, complete cds, sequence id: Pp-0672, expressed in epidermis	blastn	235	431	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Papilionidae	Papilio	Papilio polytes
22049325	22049325	PRJNA290839_P_NODE_1138_length_251_cov_0.865169_g1117_i0	PRJNA290839	1138	251	0.865169	2.17157419	Chrysoperla carnea	189513	Arthropoda	Arthropoda	254	5.81e-63	NTclustered	gi\|2125146824\|ref\|XM_044885461.1\|	189513	g1117	i0	87.615	84.7171314741036	218	27	87	0	19	236	568	785	PREDICTED: Chrysoperla carnea ATP synthase subunit beta, mitochondrial (LOC123302507), mRNA	blastn	21264	254	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Neuroptera	Chrysopidae	Chrysoperla	Chrysoperla carnea
24599004	24599004	PRJNA290839_P_NODE_1480_length_245_cov_0.901163_g1459_i0	PRJNA290839	1480	245	0.901163	2.20784935	Queda youngi	1458196	Arthropoda	Arthropoda	128	3.57e-25	NTclustered	gi\|751960357\|gb\|KJ548853.1\|	1458196	g1459	i0	92.308	30.0897959183673	91	6	37	1	11	101	502	413	Queda youngi voucher UNM KBMQuyo455 RNA polymerase II (RNA Pol II) gene, partial cds	blastn	7372	128	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Dytiscidae	Queda	Queda youngi

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