contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA1009807" and tax_kingdom = "Viridiplantae"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 154851 | 154851 | PRJNA1009807_S_NODE_881_length_319_cov_4.207143_g853_i0 | PRJNA1009807 | 881 | 319 | 4.207143 | 13.42078617 | Mantoniella squamata | 13608 | Plants | Plants | 228 | 4.6299999999999985e-55 | NTclustered | gi|290770784|emb|FN563096.1| | 13608 | g853 | i0 | 80.124 | 76.3761755485893 | 322 | 50 | 98 | 14 | 5 | 317 | 2829 | 2513 | Mantoniella squamata plastid 16S rRNA gene (partial), ITS1, tRNA-Ile gene, tRNA-Ala gene and 23S rRNA gene (partial), strain CCAP 1965/1 | blastn | 24364 | 228 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Mantoniella | Mantoniella squamata | ||
| 1001396 | 1001396 | PRJNA1009807_S_NODE_281_length_497_cov_20.032751_g254_i0 | PRJNA1009807 | 281 | 497 | 20.032751 | 99.56277247 | Selaginella | 3246 | Plants | Plants | 137 | 1.3e-27 | NTclustered | gi|2484062546|gb|OQ799636.1| | 189553 | g254 | i0 | 76.753 | 25.6378269617706 | 271 | 48 | 53 | 12 | 3 | 266 | 4408 | 4146 | Selaginella dregei voucher B Liu 62298 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 | 12742 | 137 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Lycopodiopsida | Selaginellales | Selaginellaceae | Selaginella | Selaginella dregei | |
| 1429580 | 1429580 | PRJNA1009807_S_NODE_2222_length_210_cov_2.093567_g2194_i0 | PRJNA1009807 | 2222 | 210 | 2.093567 | 4.3964907 | Chloroparvula pacifica | 1883388 | Plants | Plants | 84.2 | 6.53e-12 | NTclustered | gi|1693285448|ref|NC_042603.1| | 1883388 | g2194 | i0 | 96.078 | 10.1285714285714 | 51 | 2 | 24 | 0 | 146 | 196 | 41357 | 41407 | Chloroparvula pacifica culture RCC:4656 mitochondrion, complete genome | blastn | 2127 | 84.2 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Chloropicophyceae | Chloropicales | Chloropicaceae | Chloroparvula | Chloroparvula pacifica | ||
| 2276523 | 2276523 | PRJNA1009807_S_NODE_1222_length_274_cov_12.791489_g1194_i0 | PRJNA1009807 | 1222 | 274 | 12.791489 | 35.04867986 | Eukaryota | 2759 | Plants | Plants | 211 | 3.92e-50 | NTclustered | gi|371782091|emb|HE610123.1| | 3107 | g1194 | i0 | 92.157 | 55.8394160583942 | 153 | 7 | 56 | 4 | 1 | 153 | 4979 | 5126 | Hydrodictyon reticulatum 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain M2243 | blastn | 15300 | 211 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Hydrodictyaceae | Hydrodictyon | Hydrodictyon reticulatum | |
| 9929392 | 9929392 | PRJNA1009807_S_NODE_2348_length_205_cov_1.861446_g2320_i0 | PRJNA1009807 | 2348 | 205 | 1.861446 | 3.8159643 | Klebsormidium | 3174 | Plants | Plants | 379 | 7.229999999999999e-101 | NTclustered | gi|21635219|gb|AF393598.1| | 3175 | g2320 | i0 | 100 | 148.931707317073 | 205 | 0 | 100 | 0 | 1 | 205 | 5446 | 5650 | Klebsormidium flaccidum small subunit ribosomal RNA (rrs) gene, partial sequence; tRNA-Ile (trnI(gau)) and tRNA-Ala (trnA(ugc)) genes, complete sequence; large subunit ribosomal RNA (rrl) gene, complete sequence; and 5S ribosomal RNA (rrf) gene, partial sequence; chloroplast genes for chloroplast products | blastn | 30531 | 379 | 1 | Eukaryota | Viridiplantae | Streptophyta | Klebsormidiophyceae | Klebsormidiales | Klebsormidiaceae | Klebsormidium | Klebsormidium flaccidum | ||
| 9929418 | 9929418 | PRJNA1009807_S_NODE_688_length_353_cov_24.519108_g660_i0 | PRJNA1009807 | 688 | 353 | 24.519108 | 86.55245124 | Eukaryota | 2759 | Plants | Plants | 643 | 4.329999999999998e-180 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g660 | i0 | 99.715 | 99.3031161473088 | 351 | 1 | 99 | 0 | 3 | 353 | 887 | 537 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 35054 | 645 | 0.996899224806202 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 11633411 | 11633411 | PRJNA1009807_S_NODE_3190_length_181_cov_1.140845_g3162_i0 | PRJNA1009807 | 3190 | 181 | 1.140845 | 2.06492945 | Cucumis melo | 3656 | Plants | Plants | 54.7 | 0.004 | NTclustered | gi|733578316|emb|LN713263.1| | 3656 | g3162 | i0 | 96.97 | 0.364640883977901 | 33 | 0 | 18 | 1 | 111 | 143 | 23720629 | 23720598 | Cucumis melo genomic chromosome, chr_9 | blastn | 66 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cucurbitales | Cucurbitaceae | Cucumis | Cucumis melo | |
| 12908502 | 12908502 | PRJNA1009807_S_NODE_4531_length_157_cov_1.330508_g4503_i0 | PRJNA1009807 | 4531 | 157 | 1.330508 | 2.08889756 | Sinapis alba | 3728 | Plants | Plants | 285 | 1.17e-72 | NTclustered | gi|21157|emb|X66325.1| | 3728 | g4503 | i0 | 99.363 | 19.7707006369427 | 157 | 1 | 100 | 0 | 1 | 157 | 6675 | 6831 | S.alba 18S, 5.8S & 25S rRNA genes | blastn | 3104 | 285 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Sinapis | Sinapis alba | |
| 16731683 | 16731683 | PRJNA1009807_S_NODE_1074_length_293_cov_1.897638_g1046_i0 | PRJNA1009807 | 1074 | 293 | 1.897638 | 5.56007934 | Camellia sinensis | 4442 | Plants | Plants | 73.1 | 2.09e-8 | NTclustered | gi|1585687555|ref|XR_003647768.1| | 4442 | g1046 | i0 | 78.899 | 0.573378839590444 | 109 | 22 | 37 | 1 | 134 | 242 | 1850 | 1957 | PREDICTED: Camellia sinensis 28S ribosomal RNA (LOC114315374), rRNA | blastn | 168 | 73.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Theaceae | Camellia | Camellia sinensis | |
| 18006551 | 18006551 | PRJNA1009807_S_NODE_2615_length_196_cov_1.815287_g2587_i0 | PRJNA1009807 | 2615 | 196 | 1.815287 | 3.55796252 | Caulerpa sertularioides | 76315 | Plants | Plants | 76.8 | 1.01e-9 | NTclustered | gi|1799633313|gb|MK792750.1| | 148953 | g2587 | i0 | 87.692 | 2.13265306122449 | 65 | 8 | 33 | 0 | 32 | 96 | 9400 | 9336 | Caulerpa sertularioides f. longipes chloroplast, complete genome | blastn | 418 | 76.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Caulerpaceae | Caulerpa | Caulerpa sertularioides | |
| 22678234 | 22678234 | PRJNA1009807_S_NODE_4158_length_162_cov_3.634146_g4130_i0 | PRJNA1009807 | 4158 | 162 | 3.634146 | 5.88731652 | Pedinomonas | 3158 | Plants | Plants | 134 | 4.6800000000000005e-27 | NTclustered | gi|371782136|emb|HE610168.1| | 160064 | g4130 | i0 | 91.753 | 91.1111111111111 | 97 | 7 | 59 | 1 | 65 | 160 | 2528 | 2624 | Pedinomonas tuberculata plastid 16S rRNA gene (partial), 23S rRNA gene (partial), tRNA-Ile gene, tRNA-Ala gene and ITS1, strain SAG 42.84 | blastn | 14760 | 134 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinomonadales | Pedinomonadaceae | Pedinomonas | Pedinomonas tuberculata |
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);;